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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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: Sun Dec 08 06:55:24 CST 2024