본문 바로가기

Oracle

Dump Large Pool in SGA


/oracle/app/admin/EJD/udump/ejd_ora_2093200_LARGE_POOL.trc
<<****************************    BEGIN  ****************************>> 
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: 34
Unix process pid: 2093200, image: oracle@EJUWED1 (TNS V1-V3)

*** 2011-07-30 08:28:09.177
******************************************************
HEAP DUMP heap name="large pool"  desc=7000000100019b0
 extent sz=0xfe0 alt=216 het=32767 rec=9 flg=-126 opc=0
 parent=0 owner=0 nex=0 xsz=0x0
 ds for latch 1:
 reserved granule count 0 (granule size 16777216)

"ejd_ora_2093200_LARGE_POOL.trc" 21 lines, 810 characters
<<****************************     END   ****************************>> 

현재  Large Pool 을  적절히 할당하여 사용하지 않고 있기 때문에
해당 내용이 없는 것으로 보임.
 

'Oracle' 카테고리의 다른 글

dump JAVA_POOL  (0) 2011.07.31
Dump PGA_UGA  (0) 2011.07.31
Session trace with SQL Execution  (0) 2011.07.30
Expert Oracle Database Architecture (written by Tom )  (0) 2011.07.28
SYS.DBMS_JOB.SUBMIT( , , , , )  (0) 2011.07.27