Very Slow Response from V$lock / V$locked_object For Oracle 11g
Last updated on SEPTEMBER 13, 2016
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
- Dictionary view v$locked_object takes long time(hours) to execute
- The plan shows many nested loops:
- HASH_JOIN_ENABLED is set to false.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms