KGHFND_IN_FREE_LISTS IS VERY SLOW DURING THE FIRST HARD PARSE OF A COMPLEX PROCEDURE OR COMPILE
(Doc ID 2802881.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 19.12.0.0.0 [Release 12.1 to 19]
Information in this document applies to any platform.
Symptoms
- AWR shows all time spent in DB CPU for a complex SQL. The time may or may not be recorded as parse elapsed.
- 10046 shows time is either unaccounted for outside of waits or in cpu(CPU measurement may not be accurate) but is between parse start and end.
- loop of oradebug stacks or a 'perf record' showing all time spent in kghfnd_in_free_lists
- Stack is likely to be deep and recursive in nature
Changes
One of the following changes is likely to have occurred:
- a recent upgrade to a release of 12.1.0.2 or higher
- A new complicated sql with many levels of subqueries has been deployed.
Cause
| |
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.