目录
实例管理类
........................................................................................................................................5
等待事件类
................................................................................................................................5
“TX,TM,DX”锁应急处理
.....................................................................................................5
“
Latch free”
应急处理
.........................................................................................................5
“Cache buffer chains”应急处理
......................................................................................6
“Library cache lock”应急处理
..........................................................................................6
“gc buffer busy”应急处理
.................................................................................................7
“cursor: pin S wait on X”事件应急处理
..........................................................................7
“latch: undo global data”事件应急处理
.........................................................................8
“enq:US-content” or 回滚表空间使用过度事件应急处理
............................................9
“gc buffer busy”问题
.......................................................................................................10
资源消耗类
..............................................................................................................................11
高资源消耗进程应急处理
..............................................................................................11
IO 非常高
..........................................................................................................................11
PGA 使用过大
..................................................................................................................12
CPU 使用过高应急处理
..................................................................................................12
大表索引被删除导致 CPU 100%的应急处理
..............................................................13
网络连接类
..............................................................................................................................14
连接不上数据库
..............................................................................................................14
客户端不定时断开连接
..................................................................................................15
通过监听无法连接数据库
..............................................................................................15
空间管理类
......................................................................................................................................16
表空间故障应急处理
..............................................................................................................16
SYSAUX 表空间爆满没有存储扩容应急处理
.......................................................................17
文件系统使用率达到或超过 95%应急处理
.........................................................................17
临时表空间过度事件应急处理
..............................................................................................18
undo 表空间无法自动扩展
.....................................................................................................19
undo 表空间无法扩展
.............................................................................................................19
数据库恢复类
..................................................................................................................................21
CRS
资源异常类
......................................................................................................................21
RAC 数据库 CRS 无法正常启动
.....................................................................................21
VIP 资源 DOWN 异常处理
...............................................................................................21
数据库
HANG
类
.....................................................................................................................22
数据库 HANG 异常处理
..................................................................................................22
数据库
CRASH
类
...................................................................................................................22
实例 CRASH 应急处理
....................................................................................................22
应用操作类
......................................................................................................................................23
SQL 执行计划变化应急处理
..........................................................................................23
使用绑定变量 SQL 突然运行缓慢的应急处理
.............................................................24
其他分类
..........................................................................................................................................24
升级 PSU 系统报错
.........................................................................................................24
文档被以下合辑收录
相关文档
评论