OraFAQ Forum: Performance Tuning » top query find through sqlplus ?

Home » RDBMS Server » Performance Tuning » top query find through sqlplus ?

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

top query find through sqlplus ? [message #268209]

Tue, 18 September 2007 00:04

nomannishat
Messages: 11
Registered: September 2007
Location: PAKISTAN

Junior Member

Hi,

I need to find out the top sql query. Please let me know how can i find the query through sqlplus in 10g

Thanks

Noman Nishat

Report message to a moderator

Re: top query find through sqlplus ? [message #268210 is a reply to message #268209]

Tue, 18 September 2007 00:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I need to find out the top sql query.
Based upon which metric(s)?
If you have a basket full of multi-colored balls, which color is "top" ball?

[Updated on: Tue, 18 September 2007 00:09] by Moderator

Report message to a moderator

Re: top query find through sqlplus ? [message #268219 is a reply to message #268209]

Tue, 18 September 2007 00:19

nomannishat
Messages: 11
Registered: September 2007
Location: PAKISTAN

Junior Member

i don't understand please clearfy..

Report message to a moderator

Re: top query find through sqlplus ? [message #268226 is a reply to message #268209]

Tue, 18 September 2007 00:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>i don't understand
Obviously.

Is less RAM better than fewer IO operation?

EXACTLY how do you quantify "TOP" when units of measure are not common or convertible?

Report message to a moderator

Re: top query find through sqlplus ? [message #269157 is a reply to message #268209]

Thu, 20 September 2007 22:00

mson77
Messages: 208
Registered: August 2007
Location: Brazil

Senior Member

Hello nomannishat,

Please... can you explain better what do you mean with:

Quote:

top sql query

Also write here your oracle db version with 4 decimals.

Regards,

mson77

Report message to a moderator

Previous Topic:	Tuning of query (Not DBA Level Tuning)
Next Topic:	About Bitmap Index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 11:07:37 CST 2025