dump JAVA_POOL

EJD@/oracle/app/admin/EJD/udump> exit

SQL> oradebug setmypid

Statement processed.

SQL> oradebug unlimit

Statement processed.

SQL> alter session set tracefile_identifier='JAVA_POOL';

Session altered.

SQL> oradebug dump heapdump 128

Statement processed.

SQL> oradebug close_trace

Statement processed.

SQL> host

EJD@/oracle/app/admin/EJD/udump> ls

 

/oracle/app/admin/EJD/udump/ejd_ora_2683086_JAVA_POOL.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

ORACLE_HOME = /oracle/app/product/102

System name:    AIX

Node name:      EJUWED1

Release:        3

Version:        5

Machine:        00C605A24C00

Instance name: EJD

Redo thread mounted by this instance: 1

Oracle process number: 27

Unix process pid: 2683086, image: oracle@EJUWED1 (TNS V1-V3)

*** 2011-07-31 01:40:27.678

*** ACTION NAME:() 2011-07-31 01:40:27.678

*** MODULE NAME:(sqlplus@EJUWED1 (TNS V1-V3)) 2011-07-31 01:40:27.678

*** SERVICE NAME:(SYS$USERS) 2011-07-31 01:40:27.678

*** SESSION ID:(3187.24886) 2011-07-31 01:40:27.678

******************************************************

HEAP DUMP heap name="java pool"  desc=7000000101973f0

 extent sz=0x1040 alt=216 het=32767 rec=9 flg=-126 opc=0

 parent=0 owner=0 nex=0 xsz=0x0

 ds for latch 1: 0x700000010198d48

 reserved granule count 1 (granule size 16777216)

RESERVED EXTENTS

  0x700000050000000

Counted elements on list: 1

******************************************************

HEAP DUMP heap name="java pool"  desc=700000010198d48

 extent sz=0x1040 alt=216 het=32767 rec=9 flg=-126 opc=0

 parent=0 owner=0 nex=0 xsz=0x1000000

 latch set 1 of 1

 durations disabled for this heap

 reserved granules for root 1 (granule size 16777216)

EXTENT 0 addr=700000051000000

  Chunk  700000051000058 sz= 16777128    freeable  "Java granule   "

  contains 4k-pages for java: 3278 in-use  817 free    0 noacc

Total heap size    = 16777128

FREE LISTS:

 Bucket 0 size=0

Total free space   =        0

UNPINNED RECREATABLE CHUNKS (lru first):

  Chunk  700000079349ad0 sz=      432    recreate  "joxlod exec hp "  latch=700000084fe3288

SEPARATOR

Unpinned space     =      432  rcr=0 trn=1

PERMANENT CHUNKS:

Permanent space    =        0

******************************************************