OraFAQ Forum: Server Administration » How to set cursor

Home » RDBMS Server » Server Administration » How to set cursor_sharing refresh interval (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit)

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

How to set cursor_sharing refresh interval [message #560252]

Wed, 11 July 2012 09:26

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

Hi,

Correct me if I have wrong understanding about cursor_sharing.

"Oracle parse sql and stores explain plan, if the same sql comes again then oracle don't parse it again (soft parse) and gets the explain plan through cursor sharing."

Is there any parameter through which I can set cursor_sharing refresh interval to generate new execution plan?

Thanks,
Manu

Report message to a moderator

Re: How to set cursor_sharing refresh interval [message #560253 is a reply to message #560252]

Wed, 11 July 2012 09:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there any parameter through which I can set cursor_sharing refresh interval to generate new execution plan?
no & why would you want to?

Report message to a moderator

Re: How to set cursor_sharing refresh interval [message #560256 is a reply to message #560253]

Wed, 11 July 2012 09:56

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

Senior Member

_optimizer_invalidation_period=18000 by default in 11.2.0.3, I believe that this limits the maximum time before invalidating cached SQL following gathering statistics if you use dbms_stats.auto_invalidate. This is why I always specify no_invalidate=false.

Report message to a moderator

Re: How to set cursor_sharing refresh interval [message #560269 is a reply to message #560256]

Wed, 11 July 2012 10:41

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

anything in 10g?

Report message to a moderator

Previous Topic:	Will the RMAN> BACKUP DATABASE command populate the view V$DATABASE_BLOCK_CORRUPTION
Next Topic:	Can I remove the synonym STATS$SNAPSHOT_ID?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Oct 01 15:59:09 CDT 2026