| Oracle® Database Reference 11g Release 2 (11.2) E40402-08 |
|
|
PDF · Mobi · ePub |
| Oracle® Database Reference 11g Release 2 (11.2) E40402-08 |
|
|
PDF · Mobi · ePub |
| Property | Description |
|---|---|
| Parameter type | String |
| Syntax | CURSOR_SHARING = { EXACT | FORCE } |
| Default value | EXACT |
| Modifiable | ALTER SESSION, ALTER SYSTEM |
| Basic | No |
CURSOR_SHARING determines what kind of SQL statements can share the same cursors.
Values:
FORCE
Allows the creation of a new cursor if sharing an existing cursor, or if the cursor plan is not optimal.
EXACT
Only allows statements with identical text to share the same cursor.
See Also:
Oracle Database Performance Tuning Guide before setting the
CURSOR_SHARING parameter to learn about the performance implications
|
 Copyright © 2002, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|