Skip to Main Content
Forums

SQL & PL/SQL

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 detect hard parse queries?

770799May 6 2010 — edited May 6 2010
Oracle 11gR2 on Aix...
I would like to test queries for soft or hard parse..

how could I do that?
I created a query for that, but I don't think it's appropriate

select substr(sql_text,1,50), PARSING_SCHEMA_NAME, count(*) from v$sql
where parsing_schema_name not in ('XDB', 'SYS', 'DBSNMP', 'FLOWS_030000', 'EXFSYS', 'SPOTLIGHT')
group by substr(sql_text,1,50), PARSING_SCHEMA_NAME having count(*) > 25
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2010
Added on May 6 2010
4 comments
6,637 views