SQL Baseline Not Used for a Query With Nested Table Bind
(Doc ID 2470495.1)
Last updated on MARCH 28, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
Sql baseline for query with nested table bind is not getting used . it just ignored
The 10053 trace shows the followings:
SPM: recursive compile failed so skipping current accepted plan, planName = SQL_PLAN_*******, sig = 3756163430007884078
SPM: OCIcode = 22905, OCImesg = ORA-22905: cannot access rows from a non-nested table item
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document