|
Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today. |
|
Sponsored by:
Links to external sites are subject to change; DBAzine.com and BMC Software do not control or endorse the content of these external web sites, and are not responsible for their content. LEGAL STATEMENT © 2007 DBAzine.com. All Rights Reserved. |
Oracle allows you to "lock" statistics for a table or an entire schema. Once statistics are locked, no modifications can be made to those statistics until the statistics have been unlocked.
The DBMS_STATS package provides LOCK_SCHEMA_STATS and LOCK_TABLE_STATS to lock statistics in place and UNLOCK_SCHEMA_STATS, UNLOCK_TABLE_STATS to free them.