Question
How do I enable automatic statistics collection in
11g r2? I want to automatically collect my optimizer
statistics.
Answer: This script will
set-up a job to automatically re-analyze your
optimizer statistics in 11g release 2:
begin
dbms_auto_task_admin.enable(
client_name =>
'auto optimizer stats collection',
operation => NULL,
window_name => 'SUNDAY_WINDOW');
end;
/
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
buy it
for 30% off directly from the publisher.
|
