draft a proposal about how to support different plan for different parameters in SPM

[zz-jason]

Feature Request

Is your feature request related to a problem? Please describe:

For now, all the baseline in SPM are optimized for only one parameter of a normalized SQL. It can led to a sub-optimal plan when another parameter is presented by the user.

Describe the feature you'd like:

Find a workaround to solve this issue. Seems we can consider oracle adaptive cursor sharing.

Describe alternatives you've considered:

No

Teachability, Documentation, Adoption, Migration Strategy:

For oracle adaptive cursor sharing, these documents may help:

• Update on Adaptive Cursor Sharing
• Adaptive Cursors and SQL Plan Management