OraFAQ Forum: SQL & PL/SQL » NO_CPU

Home » SQL & PL/SQL » SQL & PL/SQL » NO_CPU_COSTING hint (Oracle 12c)

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

NO_CPU_COSTING hint [message #666345]

Mon, 30 October 2017 10:09

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hello,

Good day!!

In one of the queries where we are joining too many tables/view was having the execution plan cost around 3091219.
When I used the hint, /*+ NO_CPU_COSTING */ cost has come doing nearly 50% to 1412267.

Please let us know, if we can use the same or will it have any impact in future. The execution time is also better.

Thanks,
SRK

Report message to a moderator

Re: NO_CPU_COSTING hint [message #666348 is a reply to message #666345]

Mon, 30 October 2017 11:31

John Watson
Messages: 8927
Registered: January 2010
Location: Global Village

Senior Member

Most likely your system stats are wrong or missing. You should gather them rather than using a hint to cover this up.

Report message to a moderator

Re: NO_CPU_COSTING hint [message #666350 is a reply to message #666348]

Tue, 31 October 2017 02:09

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Thank you!!

Regards,
SRK

Report message to a moderator

Re: NO_CPU_COSTING hint [message #666353 is a reply to message #666350]

Tue, 31 October 2017 03:09

John Watson
Messages: 8927
Registered: January 2010
Location: Global Village

Senior Member

If you post the results of SELECT * FROM SYS.AUX_STATS$ the cause of the problem may become clear.

Report message to a moderator

Previous Topic:	Multiple Rows to a Single Row
Next Topic:	to_char date conversion not working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 00:13:47 CDT 2024