Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

In Oracle 10g, does the automatic statistics collection job analyze all the objects in the database every night?

April 26, 2017analyze automatic collection database Job Night objects Oracle statistics

0

Posted

In Oracle 10g, does the automatic statistics collection job analyze all the objects in the database every night?

1 Answer

0

Posted

No. It only analyzes the objects that do not have statistics or whose statistics are stale. The statistics are considered to be stale when total amount of modifications to the table reach 10% or if the table is truncated since last analyze.