Home » RDBMS Server » Server Administration » find worst queries in form of CPU usage
find worst queries in form of CPU usage [message #53833] Mon, 14 October 2002 09:58 Go to next message
Sandy Mamoli
Messages: 1
Registered: October 2002
Junior Member
When finding the worst queries in the sga I normally go after disk reads.

Now I'd like to run a similar query but find the CPU usage. Is that possible? Does anyoney know how to do this?

Any help'd be appreciated!

Report message to a moderator

Re: find worst queries in form of CPU usage [message #53843 is a reply to message #53833] Mon, 14 October 2002 15:11 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
If you are on UNIX, then This Shell script to display CPU intensive Oracle Processes will do the job.

It could be used for displaying the CPU intensive Oracle processes. It will return the session's information along with the SQL text currently executed.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site



Report message to a moderator

Previous Topic: how to update part of the column data
Next Topic: Oracle Virtual Exhibition
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 16:34:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.