Slow Performance of a Query With Adaptive Plan with LOB Column from PLSQL Block
(Doc ID 2436574.1)
Last updated on APRIL 17, 2023
Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
- Performance of query slow when running from PLSQL block with adaptive plan
- Query runs faster with NO_ADAPTIVE_PLAN hint although same plan is used
- There are LOB columns in SELECT clause
- PSTACKs show most of the time spent in 'qerlbFetch' and 'qerscFetch'
Issue reproduces when query is executed from PLSQL block and has LOB columns in SELECT clause.
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.