Statistics collection

Tuning de Banco, Tuning de SQL, Ferramentas de tuning

Poston Thu, 13 Jul 2017 8:27 am

Good morning guys, is there any way to collect statistics for a table after her being populated for the first time or every time she is populated?

The " auto optimizer stats collection if " is enabled as will be his operation?

Thank you.

Poston Tue, 26 Sep 2017 5:20 pm

From the Oracle 12 c when you perform certain operations such as CTAS and INSERT the SELECT with hint append (see ... oads-12cr1 ) have automatic statistics collection occurs in the table.

As for the " auto optimizer stats collection ", when it is enabled, it allows the automatic statistics collection on time window (2nd to 6th of 10:00 pm at 2:00 or 2:00 to 2:00 Saturday from Sunday).

[] s
Location: São Paulo - SP

Fábio Prado

Return to DBA Tuning

Who is online

Users browsing this forum: No registered users and 1 guest