11g - set_schema_stats only applies to objects already created
- From: "Reardon, Bruce (RTABBAY)" <Bruce.Reardon@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Aug 2009 16:27:37 +1000
Just want to share this behaviour I'd observed and now found the
explanation for.
If you want to use the built in statistics job in 11g, and decide to let
Oracle keep potentially creating histograms for its "internal" objects,
you may decide to do something like:
exec dbms_stats.set_schema_prefs ( 'MYUSER' , 'method_opt' , 'FOR ALL
COLUMNS SIZE 1' )
If so, take note of
http://optimizermagic.blogspot.com/2009/08/understanding-dbmsstatssetpre
fs.html
The set_schema_prefs only applies to objects created prior to running
it.
Hope this helps someone.
Regards,
Bruce Reardon
This email is confidential and may also be privileged. If you are not the
intended recipient, please notify us immediately and delete this message from
your system without first printing or copying it. Any personal data in this
email (including any attachments) must be handled in accordance with the Rio
Tinto Group Data Protection Policy and all applicable data protection laws.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » 11g - set_schema_stats only applies to objects already created - Reardon, Bruce (RTABBAY)
