Home » RDBMS Server » Server Administration » How to set cursor_sharing refresh interval (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit)
How to set cursor_sharing refresh interval [message #560252] Wed, 11 July 2012 09:26 Go to next message
manubatham20
Messages: 450
Registered: September 2010
Location: Champaign, IL
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
Re: How to set cursor_sharing refresh interval [message #560253 is a reply to message #560252] Wed, 11 July 2012 09:29 Go to previous messageGo to next message
BlackSwan
Messages: 22688
Registered: January 2009
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?
Re: How to set cursor_sharing refresh interval [message #560256 is a reply to message #560253] Wed, 11 July 2012 09:56 Go to previous messageGo to next message
John Watson
Messages: 4481
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.
Re: How to set cursor_sharing refresh interval [message #560269 is a reply to message #560256] Wed, 11 July 2012 10:41 Go to previous message
manubatham20
Messages: 450
Registered: September 2010
Location: Champaign, IL
Senior Member

anything in 10g?
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:
  


Current Time: Thu Aug 21 05:28:42 CDT 2014

Total time taken to generate the page: 0.48417 seconds