ITPub博客

首页 > Linux操作系统 > Linux操作系统 > dump oracle memory

dump oracle memory

原创 Linux操作系统 作者:lcmlsj 时间:2019-02-07 16:00:07 0 删除 编辑

Shared memory can be dumped to trace file using
$ sqlplus /nolog
SQL> CONNECT SYS/ AS SYSDBA
Connected
SQL> ORADEBUG SETMYPID
Statement processed
SQL> ORADEBUG IPC
Information written to trace file
SQL> ORADEBUG TRACEFILE_NAME
/var/opt/oracle/admin/LX092001/udump/lx092001_ora_9824.trc


Granules can be dumped using
ALTER SESSION SET EVENTS‘immediate trace name granulelist level ’
Heap Level
Null Granule 255
Home Granule 511
Shared Pool 767
Large Pool 1023
Java Pool 1279
Buffer Cache 1535


Global Area Dumps
ALTER SESSION SET EVENTS‘immediate trace name global_area level ’
Heap Level
PGA 1
SGA 2
PGA + SGA 3
UGA 4
PGA + UGA 5
SGA + UGA 6
PGA + SGA + UGA 7

Heap Dumps
ALTER SESSION SET EVENTS‘immediate trace name heapdump level ’;
Heap Summary Detail
PGA 1 1025
SGA 2 2050
UGA 4 4100
CGA – Current Call 8 8200
CGA – User Call 16 16400
LGA – Large Pool 32 32800

Subheap Dumps
In Oracle 9.0.1 and below to dump a subheap, first obtain the address of the subheap and convert to decimal
0x56b95c0c = 1454988300
For a summary dump use
ALTER SESSION SET EVENTS ‘immediate trace name heapdump_addr level 1454988300’;
For a detailed dump add 1 to the address e.g.
ALTER SESSION SET EVENTS ‘immediate trace name heapdump_addr level 1454988301’;
In Oracle 9.2 and above to dump the subheap summary use
ALTER SESSION SET EVENTS ‘immediate trace name heapdump_addr level 1, addr 0x56b95c0c’;
For a detailed dump use
ALTER SESSION SET EVENTS ‘immediate trace name heapdump_addr level 2, addr 0x56b95c0c’;


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9599/viewspace-472889/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2002-04-09

  • 博文量
    100
  • 访问量
    114098