Home » RDBMS Server » Server Administration » How to check the list of SQL statements that occupies more system resource in a DB server ?
How to check the list of SQL statements that occupies more system resource in a DB server ? [message #165920] Mon, 03 April 2006 06:03 Go to next message
jprakashm
Messages: 9
Registered: January 2006
Junior Member
I'm maintaining a Oracle 9i DB running in Windows 2000.

I need to check the list of SQL statements (in a sorted order) that occupies highest system resource (memory and I/O) in a DB server.

I don't have STATSPACK installed, but believe that i need to fiddle around with v$sql views etc.,

A ready-made DB script for doing this, would be appreciated.

Please help.

Regards,
Jayaprakash

Report message to a moderator

Re: How to check the list of SQL statements that occupies more system resource in a DB server ? [message #165924 is a reply to message #165920] Mon, 03 April 2006 06:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Statspack is the easiest method and is a 'ready-made' script.
You can find the top resource consuming sql and the top wait events .
Zoran Hudec has written a handy script which may be helpful for you.
http://www.dba-village.com/dba/village/dvp_scripts.ScriptDetails?ScriptIdA=2526
( You may need a free account here).

Report message to a moderator

Re: How to check the list of SQL statements that occupies more system resource in a DB server ? [message #166049 is a reply to message #165924] Tue, 04 April 2006 04:37 Go to previous message
jprakashm
Messages: 9
Registered: January 2006
Junior Member
Thanks Mahesh.

Report message to a moderator

Previous Topic: Please Help
Next Topic: Rollback segments and ORACLE 9.0.2
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 04 03:01:42 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.