Home » RDBMS Server » Performance Tuning » Io cost too high (Oracle 10G/Linux)
Io cost too high [message #381837] Tue, 20 January 2009 01:27 Go to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
I have a queries with high IO Cost.But the Optimizer cost is very low only.Please suggest me how to decrease the IO cost.


Regards,
Dhanalakshmi.P
Re: Io cost too high [message #381844 is a reply to message #381837] Tue, 20 January 2009 01:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Optimize the statements.

Regards
Michel
Re: Io cost too high [message #381847 is a reply to message #381844] Tue, 20 January 2009 01:55 Go to previous messageGo to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
What exactly you meant by optimize the statements. The optimizer cost is already low....can you explain in detail plz.
Re: Io cost too high [message #381849 is a reply to message #381847] Tue, 20 January 2009 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OraFAQ Forum Guide, Performance Tuning section
Performances Tuning sticky
OraFAQ Performance Tuning
Rosco's SQL Tuning Guide
Database Performance Tuning Guide.

Regards
Michel

[Updated on: Tue, 20 January 2009 01:59]

Report message to a moderator

Re: Io cost too high [message #382262 is a reply to message #381847] Wed, 21 January 2009 10:25 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Can you show us what the problem is?

An explain plan, or better - an autotrace, plus the query and details of the indexes is the minimum amount fo data we need.
Previous Topic: Concurrency and row cache lock problem in oracle10.2
Next Topic: HOW to tune this query
Goto Forum:
  


Current Time: Thu Dec 08 00:36:30 CST 2016

Total time taken to generate the page: 0.20011 seconds