Home » RDBMS Server » Performance Tuning » How to identify the top 10 long running queries in oracle
How to identify the top 10 long running queries in oracle [message #65221] Sat, 19 June 2004 16:33 Go to next message
meeta bhagra
Messages: 1
Registered: June 2004
Junior Member
Hi,

I want to find out which are the top 10 long running queries in databaseusing dictionary tables or views. Is there some way I can identify without using tools?

Any help will be greatly appreciated.

thanks,
meeta
Re: How to identify the top 10 long running queries in oracle [message #65222 is a reply to message #65221] Sun, 20 June 2004 08:15 Go to previous message
dieter
Messages: 17
Registered: February 2002
Junior Member
i offer a shareware tool called top100 that can be used to gather the information you need. you can freely use top100 for 30 days without registration and might want to have a look at it.
basically the tool offers the information available in the v$sql and v$sqltext views that offer most of the information you need to identify the most resource consuming sql statements.

dieter oberkofler
info@materialdreams.com
www.materialdreams.com/oracle
Previous Topic: urgent.
Next Topic: Mutiple Schema VS Single Schema.Help Urgently
Goto Forum:
  


Current Time: Wed Feb 21 19:10:05 CST 2024