This content has been marked as final. Show 5 replies
cursor_sharing parameter in the init. ora allows you to change the shared pool's default behaviour when parsing and caching SQL statements.
force - allows two SQL statements, which differ only by a literal value, to share parsed code cached in the shared pool. the difference in literal values must not change the meaning of the statement.
similar - allows two sql statements, which differ only by a literal value, to share parsed code cached in the shared pool. the difference in literal values must not change the meaning of the statement or its cached execution plan.
exact - two sql statements must match exactly in order to share the parse code cached in shared pool.
refer the link given below , you will get answer for all your questions.
to know Parsing in Oracle, refer.
Edited by: rajeysh on Jun 19, 2010 12:40 PM
I need some details about this cursor_sharing parameter to set SIMILAR,FORCE,EXACT..
please give the answer for my below questions..
1.what is cursor and its operation in oracle?example fot this?
2. if setting cursor_sharing=force,exact,similar ..what are the operation will be done by this parameter?example?
See my reply in this thread from a couple of days ago.
Re: Considerations for setting cursor_sharing=force
It has references to articles by Jonathan Lewis and Charles Hooper that discuss cursor sharing in detail.