How to hanganalyze and systemstate dumps
2024-08-29 00:42:42
Oracle support request hang analysis and system state dumps when rasing SR.
One 10.1 or higher versions login as
sqlplus -prelim / as sysdba
To do a hanganalyze
oradebug setmypid;
oradebug unlimit;
oradebug hanganalyze 3;
Wait 60 – 90 seconds and run the last command again to identify the process state changes.
To get a systemstate dump
oradebug setmypid;
oradebug unlimit;
oradebug dump systemstate 266;
Wait 60 – 90 seconds and run again to identify the system state changes.
If it is taking too long then cancel and run with level 258.
One a cluster environment use
oradebug -g all hanganalyze 3
for hang analyze
oradebug -g all dump systemstate 266
for system state dumps.
oradebug tracefile_name
get dump trace file path
最新文章
- 从零自学Hadoop(15):Hive表操作
- sniffer底层网络配置记录
- 【Java每日一题】20161020
- BZOJ-1143&;&;BZOJ-2718 祭祀river&;&;毕业旅行 最长反链(Floyed传递闭包+二分图匹配)
- Shell学习笔记 - 环境变量配置文件
- 《Python 学习手册4th》 第十七章 作用域
- 自定义TypeConverter把基础类型转换为复杂类型
- 用openssl库RSA加密解密
- 事后诸葛亮分析(Beta阶段)
- Java经典编程题50道之四十六
- 收官之作:利用Microsoft Teams构建中大型社区的技术架构与运营经验
- jquery 控制 video 视频播放和暂停
- ORACLE数据库,数据量大,转移数据到备份表语句
- Pointer-network的tensorflow实现-1
- Session共享的四种方法
- 使用C#进行应用程序间通信(WPF与Unity通信)
- Codeforces Round #281 (Div. 2) A. Vasya and Football 模拟
- C#实现U盘检查,并写入文件
- 迭代解析JSON简单实例
- 【Unity笔记】Behaviour Designer的使用方法