OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » find out top sql

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

find out top sql [message #250798]

Wed, 11 July 2007 06:41

ursg02
Messages: 10
Registered: July 2007
Location: Pune

Junior Member

Hi,
How can find out top SQL in our database ?

Report message to a moderator

Re: find out top sql [message #250800 is a reply to message #250798]

Wed, 11 July 2007 06:45

MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA

Senior Member

And your definiton of Top Sql is what ?

Report message to a moderator

Re: find out top sql [message #250806 is a reply to message #250800]

Wed, 11 July 2007 06:54

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.

Report message to a moderator

Re: find out top sql [message #250810 is a reply to message #250798]

Wed, 11 July 2007 07:09

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.

Report message to a moderator

Re: find out top sql [message #250811 is a reply to message #250810]

Wed, 11 July 2007 07:12

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?

Report message to a moderator

Re: find out top sql [message #250812 is a reply to message #250811]

Wed, 11 July 2007 07:13

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: find out top sql [message #250814 is a reply to message #250812]

Wed, 11 July 2007 07:23

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;

Report message to a moderator

Re: find out top sql [message #250815 is a reply to message #250812]

Wed, 11 July 2007 07:24

Maaher
Messages: 7065
Registered: December 2001

Senior Member

How to Find top 10 expensive sql's

MHE

Report message to a moderator

Previous Topic:	Upgrade of database
Next Topic:	users

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 06:41:17 CST 2024