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!