Aprenda PL/SQL

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.
netonasc

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 https://oracle-base.com/articles/12c/on ... 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
fbifabio
Location: São Paulo - SP

Fábio Prado
www.fabioprado.net



Return to DBA Tuning

Who is online

Users browsing this forum: No registered users and 1 guest