Home » RDBMS Server » Performance Tuning » High CPU Cost and low optimizer cost (Oracle 10G /Linux)
High CPU Cost and low optimizer cost [message #382401] Thu, 22 January 2009 03:04 Go to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
Please tell me how to reduce the cpu cost for a query at query level.


regards
dhanalakshmi P

[Updated on: Thu, 22 January 2009 03:07]

Report message to a moderator

Re: High CPU Cost and low optimizer cost [message #382403 is a reply to message #382401] Thu, 22 January 2009 03:10 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
Re: High CPU Cost and low optimizer cost [message #382411 is a reply to message #382403] Thu, 22 January 2009 03:38 Go to previous messageGo to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
Here i have attached my query with explain plan for your reference.



regards,
dhanalakshmi.P
Re: High CPU Cost and low optimizer cost [message #382417 is a reply to message #382411] Thu, 22 January 2009 03:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing is attached.

Before attaching something, be sure you are posting ALL necessary information as stated in guide and forum sticky.

Regards
Michel

[Updated on: Thu, 22 January 2009 03:54]

Report message to a moderator

Re: High CPU Cost and low optimizer cost [message #382560 is a reply to message #382417] Fri, 23 January 2009 00:42 Go to previous messageGo to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
Please find the attachment.
Re: High CPU Cost and low optimizer cost [message #382561 is a reply to message #382560] Fri, 23 January 2009 00:43 Go to previous messageGo to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
Please find the attached explain plain jpg file.
Re: High CPU Cost and low optimizer cost [message #382562 is a reply to message #382401] Fri, 23 January 2009 00:47 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Please tell me how to reduce the cpu cost for a query at query level.
SELECT '1' FROM DUAL;
reduces cost as requested.
Re: High CPU Cost and low optimizer cost [message #382581 is a reply to message #382562] Fri, 23 January 2009 01:51 Go to previous messageGo to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
Hi,
sorry,i didn't get you..Have you gone thro my attachments.Please explain it in detail that you would trying to convey.


regards,
Dhanalakshmi.P
Re: High CPU Cost and low optimizer cost [message #382585 is a reply to message #382581] Fri, 23 January 2009 01:59 Go to previous messageGo to next message
dhanamukesh
Messages: 51
Registered: January 2009
Member
blackswan,
i got your point.Thanks a lot.

[Updated on: Fri, 23 January 2009 02:00]

Report message to a moderator

Re: High CPU Cost and low optimizer cost [message #415527 is a reply to message #382585] Tue, 28 July 2009 03:26 Go to previous messageGo to next message
bangalibor
Messages: 15
Registered: September 2008
Location: dhaka
Junior Member

Can you Please explain what you have understood?

Thanks
Re: High CPU Cost and low optimizer cost [message #466589 is a reply to message #382585] Tue, 20 July 2010 04:28 Go to previous message
kvelrajan@gmail.com
Messages: 1
Registered: December 2009
Location: Chennai
Junior Member

Hi,

Can you please tell what you have understood from the post?
I have the same situation here..

Thanks,
Rajan
Previous Topic: Oracle server Tuning
Next Topic: Query Optimization
Goto Forum:
  


Current Time: Wed Dec 07 22:06:39 CST 2016

Total time taken to generate the page: 0.16934 seconds