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 get the count of executions for a specific sql query

Nimai_KarmakarJan 10 2014 — edited Jan 10 2014

Dear All,

Db version - Oracle 11g r2

O/s - redhat linux 5.6

We have a Extended RAC enviorment with Enterprise manager, and have a query which is used my multiple sessions at a time and at that time it got executed it used a lots of CPU (more than 80%).

Now my query is is there any query or any way to find out that how many times did this query get executed as we have elapsed time for the query which is near about 47000 secs.

All I want to know that the execution time for the query if only one user fire it.

Please mention if you need any thing else to know.

Thanks & Regards

Nimai Karmakar

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2014

Added on Jan 10 2014

#enterprise, #general-database-discussions, #manager

6 comments

1,339 views