Analyze is taking lot of time for a set of tables in particular schema
From: Shastry(DBA) <"Shastry>
Date: Mon, 9 Feb 2009 12:21:02 +0530
Message-ID: <5b294dab0902082251w1d7a3793pa68b305d9e0188ee_at_mail.gmail.com>
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.
Date: Mon, 9 Feb 2009 12:21:02 +0530
Message-ID: <5b294dab0902082251w1d7a3793pa68b305d9e0188ee_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 09 2009 - 00:51:02 CST