Oracle常用dump命令介绍

一.Memory Dumps1）.Global AreaALTER SESSION SET EVENTS "immediate trace name global_area level n";1 包含PGA
2 包含SGA
4 包含UGA
8 包含indrect memory2）.Library CacheALTER SESSION SET EVENTS "immediate trace name library_cache level n";1 library cache统计信息
2 包含hash table histogram
3 包含object handle
4 包含object结构（Heap 0）3）.Row CacheALTER SESSION SET EVENTS "immediate trace name row_cache level n";1 row cache统计信息
2 包含hash table histogram
8 包含object结构4）.BuffersALTER SESSION SET EVENTS "immediate trace name buffers level n";1 buffer header
2 level 1 + block header
3 level 2 + block contents
4 level 1 + hash chain
5 level 2 + hash chain
6 level 3 + hash chain
8 level 4 + users/waiters
9 level 5 + users/waiters
10 level 6 + users/waiters5）.BufferALTER SESSION SET EVENTS "immediate trace name buffer level n";n为某个指定block的rdba，该命令可以转储某个block在buffer中的所有版本。6）.HeapALTER SESSION SET EVENTS "immediate trace name heapdump level level";1 PGA摘要
2 SGA摘要
4 UGA摘要
8 Current call（CGA）摘要
16 User call（CGA）摘要
32 Large call（LGA）摘要
1025 PGA内容
2050 SGA内容
4100 UGA内容
8200 Current call内容
16400 User call内容
32800 Large call内容7）.Sub HeapOracle 9.0.1版本之前ALTER SESSION SET EVENTS "immediate trace name heapdump_addr level n";若n为subheap的地址，转储的是subheap的摘要信息
若n为subheap的地址+1，转储的则是subheap的内容Oracle 9.2.0版本之后ALTER SESSION SET EVENTS "immediate trace name heapdump_addr level n, addr m";其中m为subheap的地址n为1转储subheap的摘要，n为2转储subheap的内容8）.Process StateALTER SESSION SET EVENTS "immediate trace name processstate level n";9）.System StateALTER SESSION SET EVENTS "immediate trace name systemstate level n";10）.Error StateALTER SESSION SET EVENTS "immediate trace name errorstack level n";0 Error stack
1 level 0 + function call stack
2 level 1 + process state
3 level 2 + context area11）.Hang AnalysisALTER SESSION SET EVENTS "immediate trace name hanganalyze level n";12）.Work AreaALTER SESSION SET EVENTS "immediate trace name workareatab_dump level n";1 SGA信息
2 Workarea Table摘要信息
3 Workarea Table详细信息13）.LatchesALTER SESSION SET EVENTS "immediate trace name latches level n";1 latch信息
2 统计信息14）.EventsALTER SESSION SET EVENTS "immediate trace name events level n";1 session
2 process
3 system

Oracle数据块详解RMAN DUPLICATE详解相关资讯 Oracle命令 Oracle常用命令 dump

Oracle以及SDE维护常用命令-查看表（02月02日）
Oracle模拟MySQL的show index from （06/28/2014 13:41:35）
DUMP的AWR报告如何导入到Oracle详（03/24/2014 14:37:17）

Linux环境Oracle常用命令（05/08/2015 18:51:00）
Oracle常用ASM操作命令（06/10/2014 19:51:53）
Oracle工具之nid命令的使用（01/23/2014 15:22:08）

本文评论查看全部评论（0）