Home » RDBMS Server » Server Administration » find out top sql
find out top sql [message #250798] Wed, 11 July 2007 06:41 Go to next message
ursg02
Messages: 10
Registered: July 2007
Location: Pune
Junior Member
Hi,
How can find out top SQL in our database ?
Re: find out top sql [message #250800 is a reply to message #250798] Wed, 11 July 2007 06:45 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
And your definiton of Top Sql is what ?
Re: find out top sql [message #250806 is a reply to message #250800] Wed, 11 July 2007 06:54 Go to previous messageGo to next message
ursg02
Messages: 10
Registered: July 2007
Location: Pune
Junior Member
A SQL may be CPU intensive. But only executed once every 24 hours.

Another SQL may use very little CPU, not much memory, and not that much I/O. But it can be executed a 1000 times a second.
Re: find out top sql [message #250810 is a reply to message #250798] Wed, 11 July 2007 07:09 Go to previous messageGo to next message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
You still haven't told us what you are looking for, you just gave two possible interpretations of top SQL.
Re: find out top sql [message #250811 is a reply to message #250810] Wed, 11 July 2007 07:12 Go to previous messageGo to next message
ursg02
Messages: 10
Registered: July 2007
Location: Pune
Junior Member
Hi,
i want top 10 sql or process just like stackpack
but not stackpack like as v$sql etc.
but how can find out?

Re: find out top sql [message #250812 is a reply to message #250811] Wed, 11 July 2007 07:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So in clear what is your meaning of top 10 sql?
Give a formula that can be used to order the SQL.

Regards
Michel
Re: find out top sql [message #250814 is a reply to message #250812] Wed, 11 July 2007 07:23 Go to previous messageGo to next message
ursg02
Messages: 10
Registered: July 2007
Location: Pune
Junior Member
Hi,
Ni but in my database i hv use following script
select * from v$sql
where rownum < 5;
Re: find out top sql [message #250815 is a reply to message #250812] Wed, 11 July 2007 07:24 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
How to Find top 10 expensive sql's

MHE
Previous Topic: Upgrade of database
Next Topic: users
Goto Forum:
  


Current Time: Sat Dec 10 18:54:46 CST 2016

Total time taken to generate the page: 0.25900 seconds