OraFAQ Forum: Performance Tuning » how to calculate IO for specific SQL Query...

Home » RDBMS Server » Performance Tuning » how to calculate IO for specific SQL Query... (Oracle 10g HP Unix)

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

how to calculate IO for specific SQL Query... [message #342034]

Thu, 21 August 2008 02:20

santoshorcl
Messages: 24
Registered: August 2007
Location: pune

Junior Member

Hi all,
Could u please tell me how to calculate IO for specific SQL Query.

Regards,
Santosh.

Report message to a moderator

Re: how to calculate IO for specific SQL Query... [message #342040 is a reply to message #342034]

Thu, 21 August 2008 02:45

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

Senior Member
Account Moderator

Explain what you mean with "how to calculate".

Have a look at:
explain plan
v$sqlarea
set autotrace

Regards
Michel

Report message to a moderator

Re: how to calculate IO for specific SQL Query... [message #342056 is a reply to message #342040]

Thu, 21 August 2008 03:31

santoshorcl
Messages: 24
Registered: August 2007
Location: pune

Junior Member

Thanks Michel,

some resource profile are applied on few schema's. before execute any query I need to estimate IO for query in mb/gb. hence i put calculate.

Regards,
Santosh.

Report message to a moderator

Re: how to calculate IO for specific SQL Query... [message #342061 is a reply to message #342056]

Thu, 21 August 2008 03:55

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

Senior Member
Account Moderator

There is no way to calculate it.

Regards
Michel

Report message to a moderator

Previous Topic:	Sql stmt tuning
Next Topic:	Query Taking very long time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 22:18:10 CST 2024