OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Io cost too high (Oracle 10G/Linux)

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

Io cost too high [message #381837]

Tue, 20 January 2009 01:27

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

Report message to a moderator

Re: Io cost too high [message #381844 is a reply to message #381837]

Tue, 20 January 2009 01:41

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

Senior Member
Account Moderator

Optimize the statements.

Regards
Michel

Report message to a moderator

Re: Io cost too high [message #381847 is a reply to message #381844]

Tue, 20 January 2009 01:55

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.

Report message to a moderator

Re: Io cost too high [message #381849 is a reply to message #381847]

Tue, 20 January 2009 01:59

Michel Cadot
Messages: 68716
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

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.

Report message to a moderator

Previous Topic:	Concurrency and row cache lock problem in oracle10.2
Next Topic:	HOW to tune this query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 01:40:38 CST 2024