Oracle Tuning analysis of effective cursor management

Analysis of effective cursor management

"Thinking Analysis"

Cursors can be understood as shared execution plans, and when SQL is not shared, there are two directions to the general approach:

1. Adjust the size of the shared pool (share the execution 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. Do not reuse execution plan (missing bound variable)

2. The reuse of the execution plan is not preserved (shared pool size is too small)