Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Getting Execution Statistics (Inserts/Deletes/Updates) for an execution

976501Nov 27 2012 — edited Nov 28 2012

I am using Oracle 11g R2.

I would like to know what is the most efficient way of getting the modification stats on all modified tables from the execution of a stored procedure.

The USER_TAB_... show only the modified tables so I cannot collect their stats before the execution of a procedure and make afterwards a delta.
Touching all tables beforehands does not seem to be the most efficient way of doing it :(

is there a way of purging - resetting the "usage stats" on all tables? without having to "gather_schema_stats"?

Thank You,
Matt

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2012

Added on Nov 27 2012

#11g, #general-database-discussions

12 comments

888 views