아래는 Oracle 23ai(23.5) 기준 CDB AWR Report의 TOC(Table of Contents)입니다. PDB AWR Report에는 주석에 PDB로 표시한 항목만 표시됩니다.
Main Report
Report Summary
- Top ADDM Findings by Average Active Sessions -- PDB
- Load Profile -- PDB
- Instance Efficiency Percentages (Target 100%)
- Top 10 Foreground Events by Total Wait Time -- PDB
- Wait Classes by Total Wait Time -- PDB
- Host CPU
- Instance CPU
- IO Profile -- PDB
- Memory Statistics
- Database Resource Limits -- PDB
- Cache Sizes
- Shared Pool Statistics
Wait Events Statistics
Time Model Statistics -- PDB
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class -- PDB
Foreground Wait Events -- PDB
Background Wait Events
Wait Event Histogram
Wait Event Histogram (up to 64 us)
Wait Event Histogram (up to 32 ms)
Wait Event Histogram (up to 2 sec)
Wait Event Histogram (up to 2 min)
Wait Event Histogram (up to 1 hr)
Service Statistics -- PDB
Service Wait Class Stats -- PDB
Top 10 Channel Waits
Top Process Types by Wait Class -- PDB
Top Process Types by CPU Used -- PDB
SQL Statistics
SQL ordered by Elapsed Time -- PDB
SQL ordered by CPU Time -- PDB
SQL ordered by User I/O Wait Time -- PDB
SQL ordered by Gets -- PDB
SQL ordered by Reads -- PDB
SQL ordered by Physical Reads (UnOptimized) -- PDB
SQL ordered by Offload Eligible Bytes
SQL ordered by Executions -- PDB
SQL ordered by Parse Calls -- PDB
SQL ordered by Sharable Memory -- PDB
SQL ordered by Version Count -- PDB
SQL ordered by Cluster Wait Time -- PDB
Complete List of SQL Text -- PDB
Instance Activity Statistics
Key Instance Activity Stats -- PDB
Instance Activity Stats -- PDB
Instance Activity Stats - Absolute Values -- PDB
Instance Activity Stats - Thread Activity
IO Stats
IOStat by Function summary
IOStat by Filetype summary -- PDB
IOStat by Function/Filetype summary
Tablespace IO Stats -- PDB
File IO Stats -- PDB
Buffer Pool Statistics
Buffer Pool Statistics
Checkpoint Activity
Advisory Statistics
Instance Recovery Stats
MTTR Advisory
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory
Wait Statistics
Buffer Wait Statistics -- PDB
Enqueue Activity
Undo Statistics -- PDB
Undo Segment Summary
Undo Segment Stats
Undo Tablespace Stats
Latch Statistics
Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Mutex Sleep Summary
Parent Latch Statistics
Child Latch Statistics
Segment Statistics -- PDB
Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits
Segments by Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received
Segments by Global Cache Remote Grants
Dictionary Cache Statistics -- PDB
Dictionary Cache Stats
Dictionary Cache Stats (RAC)
Library Cache Statistics -- PDB
Library Cache Activity
Library Cache Activity (RAC)
Memory Statistics
Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference by Pool and Name
Replication Statistics (GoldenGate, XStream) -- PDB, changed in 23.5
Replication System Resource Usage
Replication SGA Usage
Replication Foreground Wait Events
Replication Background Wait Events
Replication SQL ordered by Elapsed Time
Replication SQL ordered by CPU Time
Replication SQL ordered by User I/O Wait Time
Replication SQL ordered by Executions
GoldenGate Integrated Extract
GoldenGate Integrated Replicat
GoldenGate Replicat
XStreamOUT Capture
XStreamOUT Outbound Server
XStreamIN
Table Statistics by DML Operations
Table Statistics by Conflict Resolutions
Replication Large Transaction Statistics
XStream Replication Long Running Transaction Statistics
Complete List of SQL Text for Replication Statistics
Advanced Queuing
Advanced Queue CPU/IO Usage
Buffered Queues
Buffered Queue Subscribers
Rule Set
Persistent Queues
Persistent Queues Rate
Persistent Queue Subscribers
Resource Limit Statistics
Shared Server Statistics
Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers
Initialization Parameters -- PDB
Parameters modified by this container
Parameters modified by other containers
Multi-Valued Parameters modified by this container
Multi-Valued Parameters modified by other containers
Active Session History (ASH) Report -- PDB
Top SQL with Top Events
Top SQL with Top Row Sources
Top Sessions
Top Blocking Sessions
Top PL/SQL Procedures
Top Events
Top Event P1/P2/P3 Values
Top DB Objects
Activity Over Time
ADDM Reports -- PDB
Report Footnotes -- PDB, added in 23.5
RAC Statistics
RAC Report Summary
- Global Cache Load Profile
- Global Cache Efficiency Percentages (Target local+remote 100%)
- Global Cache and Enqueue Services - Workload Characteristics
- Global Cache and Enqueue Services - Messaging Statistics
- Global Cache Receiver Statistics -- added in 23.5
- Cluster Interconnect
Global Messaging Statistics
Global CR Server Statistics
Global Current Server Statistics
Global Cache Transfer Statistics
Global Cache Transfer Statistics
Global Cache Transfer Times (us)
Global Cache Transfer (Immediate)
Global Cache Times (Immediate)
Global Cache RDMA Statistics
Interconnect Statistics
Interconnect Ping Latency Statistics
Interconnect Ping Latency Histogram (500 bytes) -- added in 23.5
Interconnect Ping Latency Histogram (8K) -- added in 23.5
Interconnect Throughput by Client
Interconnect Device Statistics
Dynamic Lock Redirection Statistics -- added in 23.5
Dynamic Lock Redirection Statistics -- changed from Dynamic Remastering Statistics
Dynamic Lock Redirection Freeze Time Histogram
Exadata Configuration and Statistics
-- Exadata Report Summary
Exadata Server Configuration
Exadata Storage Server Model
Exadata Storage Server Version
Exadata Storage Information
Exadata Griddisks
Exadata Celldisks
ASM Diskgroups
IORM Objective
Exadata Server Health Report
Exadata Alerts Summary
Exadata Alerts Detail
Exadata Non-Online Disks
Exadata Statistics
Performance Summary
- I/O Summary
- OS I/O Summary
- Cell I/O Summary
- Cache Savings
- Flash Activity
- Disk Activity
- IO Reason Summary
- Single Block Reads
- Small Read Histogram - Detail
- ASH Samples for Single Block Reads
- Database IO Summary
- Smart Scan Summary
- Temp IO and Large Writes Summary
Exadata Resource Statistics
Exadata Outlier Summary
Outlier Summary - Cell Level
Outlier Summary - Disk Level
Exadata OS Statistics Outliers
Exadata OS IO Statistics
Outlier Cells
Outlier Disks
Exadata OS IO Latency
Outlier Cells
Outlier Disks
Exadata OS CPU Statistics - Outlier Cells
Exadata Cell Server Statistics Outliers
Exadata Cell Server IOPS Statistics
Outlier Cells
Outlier Disks
Exadata Cell Server IO MB/s Statistics
Outlier Cells
Outlier Disks
Exadata Cell Server IO Latency
Outlier Cells
Outlier Disks
Exadata Outlier Details
Exadata OS IO Statistics Details
Outlier Cells
Outlier Disks
Exadata Cell Server Details
Outlier Cells
Outlier Disks
Exadata OS Statistics Top
Exadata OS IO Statistics
Top Cells
Top Disks
Exadata OS IO Latency
Top Cells
Top Disks
Exadata OS CPU Statistics - Top Cells
Exadata Cell Server Statistics Top
Exadata Cell Server IOPS Statistics
Top Cells
Top Disks
Exadata Cell Server IO MB/s Statistics
Top Cells
Top Disks
Exadata Cell Server IO Latency
Top Cells
Top Disks
Exadata Smart Statistics
Smart IO Statistics
Smart IO
Flash Log Statistics
Flash Log
Redo Write Histogram
XRMEM Log Statistics
XRMEM Log Writes
XRMEM Log Band Details
XRMEM Log Band Writes
XRMEM Log Request Sizes
XRMEM Log Max Buffer Usage
Flash Cache
Flash Cache Configuration
Flash Cache Space Usage
Flash Cache User Reads
Flash Cache User Reads Per Second
Flash Cache User Reads Efficiency
Flash Cache User Reads - Skips
Columnar Cache Efficiency
Flash Cache User Writes
Flash Cache User Writes - Skips
Flash Cache User Writes - Large Writes
Flash Cache User Writes - Large Write Details
Flash Cache User Writes - Large Write Rejections
Flash Cache Redo Caching
Flash Cache Internal Reads
Flash Cache Replacements
Flash Cache Internal Writes
Columnar Cache Population
Columnar Cache Population - Current
Flash Cache Scan Population
XRMEM Cache
XRMEM Cache Configuration
XRMEM Cache Space Usage
XRMEM Cache User Reads
XRMEM Cache Internal Writes
Exadata IO Reasons
Top IO Reasons by Requests
Top IO Reasons by MB
Exadata Top Database Consumers
Top Databases by IO Requests
Top Databases By IO Requests - Details
Top Databases by IO Throughput
Top Databases by IO Requests per Cell
Top Databases by IO Requests per Cell - Details
Top Databases by IO Throughput per Cell
Top PDBs by Database IO Requests
Exadata IO Latency Capping
Cancelled IOs - Client
Cancelled IOs - Cells
Cancelled IOs - Cells
Database Cancelled IOs
Exadata Flash Write Usage -- linked from Exadata Flash Wear
아래는 Oracle 23ai(23.5) 기준 PDB AWR Report의 TOC(Table of Contents)입니다.
Main Report
Report Summary
- Top ADDM Findings by Average Active Sessions
- Load Profile
- Top 10 Foreground Events by Total Wait Time
- Wait Classes by Total Wait Time
- IO Profile
- Database Resource Limits
Wait Events Statistics
Time Model Statistics
Foreground Wait Class
Foreground Wait Events
Service Statistics
Service Wait Class Stats
Top Process Types by Wait Class
Top Process Types by CPU Used
SQL Statistics
SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
SQL ordered by Cluster Wait Time
Complete List of SQL Text
Instance Activity Statistics
Key Instance Activity Stats
Instance Activity Stats
Instance Activity Stats - Absolute Values
IO Stats
IOStat by Filetype summary
Tablespace IO Stats
File IO Stats
Buffer Wait Statistics
Undo Statistics
Undo Segment Summary
Undo Segment Stats
Undo Tablespace Stats
Segment Statistics
Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits
Segments by Global Cache Buffer Busy
Segments by CR Blocks Received
Segments by Current Blocks Received
Segments by Global Cache Remote Grants
Dictionary Cache Statistics
Dictionary Cache Stats
Dictionary Cache Stats (RAC)
Library Cache Statistics
Library Cache Activity
Library Cache Activity (RAC)
Replication Statistics (GoldenGate, XStream) -- changed in 23.5
Replication System Resource Usage
Replication SGA Usage
Replication Foreground Wait Events
Replication Background Wait Events
Replication SQL ordered by Elapsed Time
Replication SQL ordered by CPU Time
Replication SQL ordered by User I/O Wait Time
Replication SQL ordered by Executions
GoldenGate Integrated Extract
GoldenGate Integrated Replicat
GoldenGate Replicat
XStreamOUT Capture
XStreamOUT Outbound Server
XStreamIN
Table Statistics by DML Operations
Table Statistics by Conflict Resolutions
Replication Large Transaction Statistics
XStream Replication Long Running Transaction Statistics
Complete List of SQL Text for Replication Statistics
Initialization Parameters
Parameters modified by this container
Parameters modified by other containers
Multi-Valued Parameters modified by this container
Multi-Valued Parameters modified by other containers
Active Session History (ASH) Report
Top SQL with Top Events
Top SQL with Top Row Sources
Top Sessions
Top Blocking Sessions
Top PL/SQL Procedures
Top Events
Top Event P1/P2/P3 Values
Top DB Objects
Activity Over Time
ADDM Reports
Report Footnotes -- added in 23.5