Consequences of Analyzing SYS and SYSTEM tables?
- From: David Wagoner <dwagoner@xxxxxxxxxxxxxxxxxx>
- To: "ORACLE-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 1 Apr 2004 14:51:52 -0500
I was just working in another DBA's database and found that all tables are
analyzed each day, including SYS and SYSTEM. His script uses the following
syntax:
analyze table SYS.table_name validate structure cascade;
Can anyone think of a good reason to do this? The "validate structure"
clause tells Oracle not to use the statisitics for the optimizer, and just
validates the integrity of data blocks and rows.
I've heard that you are NOT supposed to analyze SYS and SYSTEM objects, so I
don't. But, what are the implications if you do? Anyone had any errors or
performance problems as a result? Seems like I've read such accounts, I
just don't recall where.
This DB is 9iR1, so I plan to direct the DBA to the DBMS_STATS package for
gathering statistics.
Thanks.
Best regards,
David B. Wagoner
Database Administrator
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
