Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is there any way to estimate the time required to gather stats

728006Dec 21 2011 — edited Dec 22 2011

Hi All,

Is there any way to estimate the time required to gather stats on a big tables? because we are having 150gb to 300gb tables so I need to know how much time it is going to take to gather the stats on those tables.

db version - 10.2.0.5
os-linux

Thanks

KK

Edited by: user12061936 on Dec 21, 2011 12:00 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 19 2012

Added on Dec 21 2011

#general-database-discussions, #performance

6 comments

1,245 views