There are generally two types of GET operations:
Each hard parse requires looking up object metadata in row cache. Thousands of sessions doing ALTER SESSION SET ... or unshared SQL. kqr row cache contention check gets
Specifically, when investigating performance spikes, you may encounter wait events or statistics pointing to This series of keywords points to a specific struggle within the Data Dictionary Cache, where the database engine is fighting to retrieve or modify metadata definitions. There are generally two types of GET operations: