Script to Collect Log File Sync Diagnostic Information (lfsdiag.sql)
(Doc ID 1064487.1)
Last updated on SEPTEMBER 03, 2024
Applies to:
Oracle Database Cloud Service - Version N/A and laterOracle Database - Enterprise Edition - Version 10.2.0.4 to 21.4 [Release 10.2 to 21.0]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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.
Goal
This script is intended to provide a user friendly guide to troubleshoot log file sync waits. The script will look at important parameters involved in log file sync waits, log file sync wait histogram data, and the script will look at some of the worst average log file sync times in the active session history data and AWR data and dump information to help determine why those times were the highest. The script will create a file called lfsdiag_<timestamp>.out in your local directory.
See <Note: 857576.1> for more information on troubleshooting 'log file sync' waits and see <Note: 34592.1> for a definition of 'log file sync' and a list of known bugs.
Solution
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
| Goal |
| Solution |
| Requirements |
| Configuring |
| Instructions |
| Script |
| Sample Output |
| References |