Home » RDBMS Server » Performance Tuning » how to calculate IO for specific SQL Query... (Oracle 10g HP Unix)
how to calculate IO for specific SQL Query... [message #342034] Thu, 21 August 2008 02:20 Go to next message
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.
Re: how to calculate IO for specific SQL Query... [message #342040 is a reply to message #342034] Thu, 21 August 2008 02:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Explain what you mean with "how to calculate".

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

Regards
Michel
Re: how to calculate IO for specific SQL Query... [message #342056 is a reply to message #342040] Thu, 21 August 2008 03:31 Go to previous messageGo to next message
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.
Re: how to calculate IO for specific SQL Query... [message #342061 is a reply to message #342056] Thu, 21 August 2008 03:55 Go to previous message
Michel Cadot
Messages: 64144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no way to calculate it.

Regards
Michel
Previous Topic: Sql stmt tuning
Next Topic: Query Taking very long time
Goto Forum:
  


Current Time: Fri Dec 09 11:25:23 CST 2016

Total time taken to generate the page: 0.10575 seconds