Analyze is taking lot of time for a set of tables in particular schema

  • From: "Shastry(DBA)" <shastry17@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 9 Feb 2009 12:21:02 +0530

Hi all,
Analyze is taking too much time on particular schema(PROD database), i see
the latest time stamp in last_analyzed column. But these days the gather
stats is taking too much time. Any workarounds on this please. It will
be grateful.

Thanks in advance,
Ann

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2009