Oracle Tuning analysis of effective cursor management

Analysis of effective cursor management

"Thinking Analysis"

The ability to interpret cursors as shared run schedules when SQL is not shared. There are two directions to the conventional approach:

1. Adjust the size of the shared pool (shared operation plan in the library buffer of the shared pool);

2, SQL writing as far as possible to reuse the binding variables, in order to play the role of shared SQL.

"Poor cursor management embodies"

1. No reuse of run schedules (missing bound variables)

2, the reuse of the running plan is not preserved (shared pool size is too small)

Oracle Tuning analysis of effective cursor management