Oracle 故障信息收集向导

原创界外玄学 2023-12-20

332

Oracle 故障信息收集向导：

Performance Related Oracle Service Request Data Collection (SRDC) Articles (Doc ID 1938786.1)

Problem Type	Recommended SRDCs / Troubleshooting Guides
Whole Database is slow/hung or multiple SQLs Slow	Document 2315692.1 SRDC - How to Collect Standard Information for a Database Performance Problem Using TFA Collector (Recommended) or Manual Steps

High CPU/Memory Usage or I/O Issues	Document 2040712.1 SRDC - How to Collect Standard Information for High CPU/Memory Usage or I/O Issues

PMON failed to acquire latch	Document 1951971.1 SRDC - How to Collect Standard Information for Issues Where 'PMON failed to acquire latch, see PMON dump' Warnings are Seen in the Alert Document 976714.1 Resolving Issues Where 'PMON failed to acquire latch, see PMON dump' Warnings are Seen in the Alert Log

Slow SQL, Hung SQL, SQL Not Using an Index	Document 1594386.1 SRDC - How to Collect Standard Information for a SQL Performance Problem Document 742112.1 Troubleshooting Query Performance Degradation - Recommended Actions
Wrong Results	Document 1683787.1 SRDC - How to Collect Standard Information for a Wrong Results Issue Document 150895.1 Wrong Results Issues - Recommended Actions

ORA-00600/7445 error with slow database or SQL performance	Document 1638904.1 SRDC - ORA-600 / ORA-7445: Checklist of Evidence to Supply Document 1521912.1 ORA-00600 Troubleshooting Tool Document 1521910.1 ORA-7445 Troubleshooting Tool Document 153788.1 ORA-600/ORA-7445/ORA-700 Error Look-up Tool
ORA-00054 Errors	Document 1985913.1 SRDC - How to Collect Standard Information for an "ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired" Problem Document 1945579.1Troubleshooting issues where “ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired” errors are being encountered Document 1986754.1 Script to Collect Basic Diagnostic Information Regarding Lock Holders
ORA-00060 Errors	Document 1595614.1 SRDC - How to Collect Standard Information for an "ORA-00060 Deadlock Detected" Problem Document 62365.1 Troubleshooting "ORA-00060 Deadlock Detected" Errors
"ORA-12751: cpu time or run time policy violation" Errors	Document 2012853.1 SRDC - How to Collect Standard Information for an "ORA-12751: cpu time or run time policy violation" Problem Document 761298.1 Troubleshooting ORA-12751 "cpu time or run time policy violation" Errors

Waits for 'enq: TX - ...' type events	Document 1595636.1 SRDC - How to Collect Standard Information for an Issue Where 'enq: TX - ...' Type Waits Are the Primary Waiters on the Database Document 1476298.1 Resolving Issues Where 'enq: TX - row lock contention' Waits are Occurring
Waits for 'latch: cache buffers chains'	Document 1595650.1 SRDC - How to Collect Standard Information for an Issue Where 'latch: cache buffers chains' Waits are the Primary Waiters on the Database Document 1342917.1 Troubleshooting 'latch cache buffers chains' Wait Contention
Waits for 'log file sync'	Document 1595672.1 SRDC - How to Collect Standard Information for an Issue Where 'log file sync' Waits are the Primary Waiters on the Database Document 1376916.1 Troubleshooting: "Log File Sync" Waits
Waits for 'library cache lock'	Document 1904807.1 SRDC - How to Collect Standard Information for an Issue Where 'library cache lock' Waits are the Primary Waiters on the Database Document 444560.1 Troubleshooting Library Cache Lock, Pin and Load Lock

Using or troubleshooting SPM	Document 1644732.1 SRDC - How to Collect Standard Information for an Issue Where a SQL Plan Management (SPM) Baseline is Not Used Document 1663691.1 How to Diagnose Issues where a SQL Plan Management (SPM) Baseline is not Used Document 1938314.1 Script to Collect Basic Diagnostic Information for Issues Where a SQL Plan Management (SPM) Baseline is Not Used

Database Replay Pre-Processing Issues	Document 1903585.1 SRDC - How to Collect Standard Information for Database Replay Pre-Processing Issues Document 463263.1 Database Capture and Replay: Common Errors and Reasons
Database Replay Initialization Performance Problem	Document 1903582.1 SRDC - How to Collect Standard Information for a Database Replay Initialization Performance Problem Document 463263.1 Database Capture and Replay: Common Errors and Reasons
Database Replay Problem	Document 1903127.1 SRDC - How to Collect Standard Information for a Database Replay Problem Document 463263.1 Database Capture and Replay: Common Errors and Reasons
Database Capture Problem	Document 1901265.1 SRDC - How to Collect Standard Information for a Database Capture Problem Document 463263.1 Database Capture and Replay: Common Errors and Reasons

Excessive SYSAUX Space used by the Automatic Workload Repository (AWR)	Document 1934108.1 SRDC - How to Collect Standard Information for an Issue where Excessive SYSAUX Space is Used by the Automatic Workload Repository (AWR) Document 1399365.1 Troubleshooting Issues with SYSAUX Usage by the Automatic Workload Repository (AWR)

Materialized View Rewrite	Document 1672774.1 SRDC - Data to Supply for Create/Maintain Materialized View and Materialized View log Issues<br><br>

Parallel Execution	Document 1684432.1 SRDC - Data Collection for Parallel Execution Issues Document 280939.1 Checklist for Performance Problems with Parallel Execution

oracle

「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」

关注作者

文章被以下合辑收录

ORACLE（共7篇）

oracle 学习，故障处理

Oracle 故障信息收集向导

Whole Database is slow/hung or multiple SQLs Slow

High CPU/Memory Usage or I/O Issues

PMON failed to acquire latch

Slow SQL, Hung SQL, SQL Not Using an Index

Wrong Results

ORA-00600/7445 error with slow database or SQL performance

ORA-00054 Errors

ORA-00060 Errors

"ORA-12751: cpu time or run time policy violation" Errors

Waits for 'enq: TX - ...' type events

Waits for 'latch: cache buffers chains'

Waits for 'log file sync'

Waits for 'library cache lock'

Using or troubleshooting SPM

Database Replay Pre-Processing Issues

Database Replay Initialization Performance Problem

Database Replay Problem

Database Capture Problem

Excessive SYSAUX Space used by the Automatic Workload Repository (AWR)

Materialized View Rewrite

Parallel Execution

文章被以下合辑收录

评论

相关阅读