Is there any proper way of identifying the exact sql statement running at that particular time when the cpu utilization is 90%.
I was using V$sqlarea but unable to identify it.
Main Topics
Browse All TopicsCPU utilization.
All of a sudden the cpu utilization becomes 70 to 90 percents. I am looking at the top sql in Enterprise manager but this is confusing which column to look for disk per read or cpu time.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
because parse calls consume so much time of CPU. by the way, how can you extract Top SQL in terms of high CPU time.
Only top SQL in terms of below is avialble
1. Top SQL with high buffer gets
2. Top SQL with high physical reads
3. Top SQL with high execution count
4. Top SQL with high shared memory
5. Top SQL with high version count
6. Top SQL with high parse count
Business Accounts
Answer for Membership
by: mohammadzahidPosted on 2007-03-10 at 17:07:09ID: 18695794
Please post the SQL Statement and explain plan output or trace file output