OraFAQ Forum: Performance Tuning » High CPU Cost and low optimizer cost

Home » RDBMS Server » Performance Tuning » High CPU Cost and low optimizer cost (Oracle 10G /Linux)

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

High CPU Cost and low optimizer cost [message #382401]

Thu, 22 January 2009 03:04

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

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

Report message to a moderator

Re: High CPU Cost and low optimizer cost [message #382411 is a reply to message #382403]

Thu, 22 January 2009 03:38

dhanamukesh
Messages: 51
Registered: January 2009

Member

Here i have attached my query with explain plan for your reference.

regards,
dhanalakshmi.P

Report message to a moderator

Re: High CPU Cost and low optimizer cost [message #382417 is a reply to message #382411]

Thu, 22 January 2009 03:53

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

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

dhanamukesh
Messages: 51
Registered: January 2009

Member

Please find the attachment.

Attachment: fgggdjg3c9qrg.sql
(Size: 2.50KB, Downloaded 1718 times)

Report message to a moderator

Re: High CPU Cost and low optimizer cost [message #382561 is a reply to message #382560]

Fri, 23 January 2009 00:43

dhanamukesh
Messages: 51
Registered: January 2009

Member

Please find the attached explain plain jpg file.

Attachment: fgggdjg3c9qrg.jpg
(Size: 213.03KB, Downloaded 1169 times)

Report message to a moderator

Re: High CPU Cost and low optimizer cost [message #382562 is a reply to message #382401]

Fri, 23 January 2009 00:47

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: High CPU Cost and low optimizer cost [message #382581 is a reply to message #382562]

Fri, 23 January 2009 01:51

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

Report message to a moderator

Re: High CPU Cost and low optimizer cost [message #382585 is a reply to message #382581]

Fri, 23 January 2009 01:59

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

bangalibor
Messages: 15
Registered: September 2008
Location: dhaka

Junior Member

Can you Please explain what you have understood?

Thanks

Report message to a moderator

Re: High CPU Cost and low optimizer cost [message #466589 is a reply to message #382585]

Tue, 20 July 2010 04:28

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

Report message to a moderator

Previous Topic:	Oracle server Tuning
Next Topic:	Query Optimization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 05:54:51 CST 2024