|
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 |
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
|
|
|