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!

How to create outline from perfstat.stats$SQL_PLAN table

user7478143Jan 18 2011 — edited Jan 18 2011

How do I create outline (Plan stability in 10gR2database) from perfstat.stats$SQL_PLAN table?

Current V$SQL_PLAN does not contain good but but week older snapshots have good plan.

I can't modify query, it's vendor query so I need to create outline/plan stability.

Thanks for help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 15 2011

Added on Jan 18 2011

#database, #general-database-discussions, #oracle, #performance

5 comments

1,089 views