How do I enable automatic statistics collection in
11g r2? I want to automatically collect my optimizer
Answer: This script will
set-up a job to automatically re-analyze your
optimizer statistics in 11g release 2:
'auto optimizer stats collection',
operation => NULL,
window_name => 'SUNDAY_WINDOW');
Get the Complete
Oracle SQL Tuning Information
The landmark book
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
for 30% off directly from the publisher.