| Oracle execution plan help needed [message #310471] |
Tue, 01 April 2008 06:53  |
gangulyz
Messages: 6
Registered: April 2008
|
Junior Member |
|
|
Hi
Is there a way in Oracle to check if the schema objects need to be re-analyzed to get the statistics?
Is there any data dictionary view to do this?
Actually We want to run the DBMS_STATS.GATHER_SCHEMA_STATS proc only if it is needed.
Kindly help...
Regards
Som
[Updated on: Tue, 01 April 2008 06:55] Report message to a moderator |
|
|
|
| Re: Oracle execution plan help needed [message #310484 is a reply to message #310471] |
Tue, 01 April 2008 07:14  |
michael_bialik
Messages: 621
Registered: July 2006
|
Senior Member |
|
|
You can check DBA_TAB_MODIFICATIONS view.
In 10g all tables are created with MONITORING feature as default.
In 9i - you can do "ALTER TABLE <tabname> MONITORING";
Afterward you will see in DBA_TAB_MODIFICATIONS view the number of INSERTs/DELETEs/UPDATEs for each table and use it to run DBMS_STATS (look for STALE in documentation as well).
HTH.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
