OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 11g (Query plan)

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

Oracle 11g [message #633461]

Thu, 19 February 2015 05:29

ramya_162
Messages: 107
Registered: August 2013
Location: Banglore

Senior Member

Hi All,

How to make sure a particular query always has to use same execution plan?

Is there any hint?

Thanks.

Report message to a moderator

Re: Oracle 11g [message #633462 is a reply to message #633461]

Thu, 19 February 2015 05:32

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

Senior Member

You need to research SQL Plan Baselining or Stored Outlines, depoending on whether you have Enterprise or Standard edition licences.

--update:
There are some baselining demos here,
SQL Plan Baselines (11g)
the mechanism is improved in release 12.

[Updated on: Thu, 19 February 2015 05:35]

Report message to a moderator

Re: Oracle 11g [message #633473 is a reply to message #633461]

Thu, 19 February 2015 07:08

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

ramya_162 wrote on Thu, 19 February 2015 05:29

Hi All,

How to make sure a particular query always has to use same execution plan?

Is there any hint?

Thanks.

Why would you want to?

I know there are some outlying valid reasons, but for the most part I'd trust the CBO every time. So my question is, do you have one of those outlying valid reasons?

Report message to a moderator

Previous Topic:	Trunc Date
Next Topic:	To determine if the column value is decreasing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 14:50:34 CDT 2024