Script to Collect RAC Diagnostic Information

最新推荐文章于 2021-11-18 22:43:38 发布

转载最新推荐文章于 2021-11-18 22:43:38 发布 · 872 阅读

The Oracle Cluster and Grid 专栏收录该内容

6 篇文章

订阅专栏

本文提供了一款用户友好的脚本，用于解决RAChung会话或性能瓶颈问题。该脚本收集关键调试信息，确定RAC会话挂起的原因，并在所有节点的本地目录中创建名为racdiag_.out的文件。脚本同时提醒使用OpenVMS系统的用户，针对特定情况请参阅Note316838.1。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORACLE_CLUSTER_Script to Collect RAC Diagnostic Information

This script is intended to provide a user friendlyguide to troubleshoot RAC hung sessions or slow performance scenerios. Thescript includes information to gather a variety of important debug informationto determine the cause of a RAC session hang. The script will create a filecalled racdiag_.out in your local directory while dumping hang analyze dumps inthe user_dump_dest(s) and background_dump_dest(s) on all nodes. If you areusing OpenVMS, see Note 316838.1 for a VMS specific script.

This script is a one-time data capture. Procwatcher ( Note: 459694.1 ) is a morepowerful tool written that could be used to monitor your system regularly(instead of a one-time data capture).

$ sqlplus '/ as sysdba'

SQL> @racdiag.sql