First page Back Continue Last page Graphics
Cursor Sharing
Database modifies query to use bind variables
- Removes character and number constants
Convert
To this
Permits reuse / sharing of a cursor
Helpful when application code cannot be modified
Notes:
Cursor sharing is an Oracle feature that causes the cost-based optimizer to rewrite a query to remove character and number constants and replace them with bind variables. This can reduce the number of hard parses by allowing a query to share an already parsed query. We learned in the SQL Statement Processing lesson that reducing hard parses decreases latching and increases the scalability of our applications.
This feature can be helpful when the source code cannot be modified. For example, vendor software might benefit from this.