Oracle Database Discussions

Hi All,

I have issued a DBMS_STATS.GATHER_SCHEMA_STATS using the following PL/SQL block on my schema contaning about 7 TBs of data. I used the following PL/SQL block for gathering the schema stats:

DBMS_STATS.GATHER_SCHEMA_STATS
(
ownname =>'SCHEMANAME',
estimate_percent => 20,
block_sample => FALSE,
method_opt => 'FOR ALL INDEXED COLUMNS SIZE 254',
degree => NULL,
granularity => 'DEFAULT',
options => 'GATHER',
cascade => TRUE
);

I had started executing it on Sat 1:30 PM EST and in the past 2 days only 25% of the tables have been analyzed.

If anyone amng you would have encountered a similar situation before, could you please guide me with this.

Thanks in advance.