oracle常用dump命令

《oracle常用dump命令》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、Oracle常用dump命令MemoryDumps1).GlobalAreaALTERSESSIONSETEVENTS'immediatetracenameglobal_arealeveln';1包含PGA2包含SGA4包含UGA8包含indrectmemory2).LibraryCacheALTERSESSIONSETEVENTS'immediatetracenamelibrary_cacheleveln';1librarycache统计信息2包含hashtablehistogram3包含objecthandle4包含object结构（Heap0）3).RowCacheA

2、LTERSESSIONSETEVENTS'immediatetracenamerow_cacheleveln';1rowcache统计信息2包含hashtablehistogram8包含object结构4).BuffersALTERSESSIONSETEVENTS'immediatetracenamebuffersleveln';1bufferheader2level1+blockheader3level2+blockcontents4level1+hashchain5level2+hashchain6level3+hashchain8level4+users/waiter

3、s9level5+users/waiters10level6+users/waiters5).BufferALTERSESSIONSETEVENTS'immediatetracenamebufferleveln';n为某个指定block的rdba，该命令可以转储某个block在buffer中的所有版本。6).HeapALTERSESSIONSETEVENTS'immediatetracenameheapdumplevellevel';1PGA摘要2SGA摘要4UGA摘要8Currentcall(CGA)摘要16Usercall(CGA)摘要32Largecall(LGA)摘

4、要1025PGA内容2050SGA内容4100UGA内容8200Currentcall内容16400Usercall内容32800Largecall内容7).SubHeapOracle9.0.1版本之前ALTERSESSIONSETEVENTS'immediatetracenameheapdump_addrleveln';若n为subheap的地址，转储的是subheap的摘要信息若n为subheap的地址+1，转储的则是subheap的内容Oracle9.2.0版本之后ALTERSESSIONSETEVENTS'immediatetracenameheapdump_add

5、rleveln,addrm';其中m为subheap的地址，n为1转储subheap的摘要，n为2转储subheap的内容8).ProcessStateALTERSESSIONSETEVENTS'immediatetracenameprocessstateleveln';9).SystemStateALTERSESSIONSETEVENTS'immediatetracenamesystemstateleveln';10).ErrorStateALTERSESSIONSETEVENTS'immediatetracenameerrorstackleveln';0Errorsta

6、ck1level0+functioncallstack2level1+processstate3level2+contextarea11).HangAnalysisALTERSESSIONSETEVENTS'immediatetracenamehanganalyzeleveln';12).WorkAreaALTERSESSIONSETEVENTS'immediatetracenameworkareatab_dumpleveln';1SGA信息2WorkareaTable摘要信息3WorkareaTable详细信息13).LatchesALTERSESSIONSETEVENT

7、S'immediatetracenamelatchesleveln';1latch信息2统计信息14).EventsALTERSESSIONSETEVENTS'immediatetracenameeventsleveln';1session2process3system15).LocksALTERSESSIONSETEVENTS'immediatetracenamelocksleveln';16).SharedServerProcessALTERSESSIONSETEVENTS'immediatetracename