My Oracle Support Banner

Reading and Understanding Systemstate Dumps (Doc ID 423153.1)

Last updated on JULY 07, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database - Personal Edition - Version 10.2.0.1 and later
Oracle Database - Standard Edition - Version 10.2.0.1 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Purpose

 

To be able to read a systemstate, or navigate through a systemstate in order to identify what sessions are doing and , 
in the case of a waiting session, which session(s) hold the resource it requires 

Scope

This document is intended for DBAs.

Details

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
Purpose
Scope
Details
 How to use this document
 What is a Systemstate ?
 How to Navigate through a systemstate
 Common wait scenarios and corresponding Entries
 Enqueues
 Rowcache locks
 Library Cache Pins (10G - Mutexes)
 Library Cache Lock
 Latch free

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.