######################################################### error in the alert log -every day getting in alert log. ######################################################### Errors in file /usr/oracle/admin/database_name/bdump/database_name_j002_27356.trc: ORA-12012: error on auto execute of job 9009 ORA-04031: unable to allocate ORA-04031: unable to allocate 63080 bytes of shared memory ("shared pool","DBMS_STATS","PL/SQL MPCODE","BAMIMA: Bam Buffer") bytes of shared memory ("","","","") ############################################# Trace file ############################################## /usr/oracle/admin/database_name/bdump/database_name_j002_27356.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 = /usr/oracle/product/10.2.0 System name: Linux Node name: server_name Release: 2.6.16.46-0.12-smp Version: #1 SMP Thu May 17 14:00:09 UTC 2007 Machine: x86_64 Instance name: database_name Redo thread mounted by this instance: 1 Oracle process number: 18 Unix process pid: 27356, image: oracle@server_name (J002) *** ACTION NAME:(GATHER_STATS_JOB) 2010-07-10 06:00:05.519 *** MODULE NAME:(DBMS_SCHEDULER) 2010-07-10 06:00:05.519 *** SERVICE NAME:(SYS$USERS) 2010-07-10 06:00:05.519 *** SESSION ID:(26.25664) 2010-07-10 06:00:05.519 *** 2010-07-10 06:00:05.519 ================================= Begin 4031 Diagnostic Information ================================= The following information assists Oracle in diagnosing causes of ORA-4031 errors. This trace may be disabled by setting the init.ora _4031_dump_bitvec = 0 ===================================== Allocation Request Summary Informaton ===================================== Current information setting: 04014fff SGA Heap Dump Interval=3600 seconds Dump Interval=300 seconds Last Dump Time=07/10/2010 06:00:05 Dump Count=1 Allocation request for: BAMIMA: Bam Buffer Heap: 0x7652fa68, size: 63080 ****************************************************** HEAP DUMP heap name="sga heap" desc=0x60000058 extent sz=0x47c0 alt=216 het=32767 rec=9 flg=-126 opc=0 parent=(nil) owner=(nil) nex=(nil) xsz=0x1 ds for latch 1: 0x60034d10 reserved granule count 0 (granule size 4194304) ****************************************************** HEAP DUMP heap name="PL/SQL MPCODE" desc=0x7652fa68 extent sz=0xfe8 alt=32767 het=32 rec=0 flg=2 opc=0 parent=0x60000058 owner=(nil) nex=(nil) xsz=0x400000 Subheap has 250336 bytes of memory allocated ==================== Process State Object ==================== ---------------------------------------- SO: 0x7c6e7620, type: 2, owner: (nil), flag: INIT/-/-/0x00 (process) Oracle pid=18, calls cur/top: 0x7c0d7590/0x7c0d99b0, flag: (0) - int error: 0, call error: 0, sess error: 0, txn error 0 (post info) last post received: 0 0 198 last post received-location: kgllldl: post after freeing latch last process to post me: 7c6e6e38 110 0 last post sent: 0 0 117 last post sent-location: kcbzww last process posted by me: 7c6e6e38 110 0 (latch info) wait_event=0 bits=0 Process Group: DEFAULT, pseudo proc: 0x7c7429d0 O/S info: user: oracle, term: UNKNOWN, ospid: 27356 OSD pid info: Unix process pid: 27356, image: oracle@server_name (J002) Dump of memory from 0x000000007C6C7620 to 0x000000007C6C7828 07C6C7620 00000006 00000000 7804AE80 00000000 [...........x....] 07C6C7630 00000010 000313A7 7C0D99B0 00000000 [...........|....] 07C6C7640 00000003 000313A7 7C29BC48 00000000 [........H.)|....] 07C6C7650 0000000B 000313A7 7C76CE88 00000000 [..........v|....] 07C6C7660 00000004 0003129B 78F45000 00000000 [.........P.x....] 07C6C7670 0000005E 000313A7 7B4E64D0 00000000 [^........dN{....] 07C6C7680 00000007 000313A7 00000000 00000000 [................] 07C6C7690 00000000 00000000 00000000 00000000 [................] Repeat 24 times 07C6C7820 00000000 00000000 [........] ========================= User Session State Object ========================= ---------------------------------------- SO: 0x7c76ce88, type: 4, owner: 0x7c6e7620, flag: INIT/-/-/0x00 (session) sid: 26 trans: (nil), creator: 0x7c6e7620, flag: (40010041) USR/- BSY/-/-/-/-/- DID: 0001-0012-0007EBE7, short-term DID: 0000-0000-00000000 txn branch: (nil) oct: 170, prv: 0, sql: 0x7789f6a0, psql: 0x78743db0, user: 0/SYS O/S info: user: oracle, term: UNKNOWN, ospid: 27356, machine: server_name program: oracle@server_name (J002) application name: DBMS_SCHEDULER, hash value=2478762354 action name: GATHER_STATS_JOB, hash value=930355498 last wait for 'db file sequential read' blocking sess=0x(nil) seq=47 wait_time=23 seconds since wait started=0 file#=1, block#=2a90, blocks=1 Dumping Session Wait History for 'db file sequential read' count=1 wait_time=23 file#=1, block#=2a90, blocks=1 for 'db file sequential read' count=1 wait_time=1298 file#=1, block#=2124, blocks=1 for 'db file sequential read' count=1 wait_time=478 file#=1, block#=2127, blocks=1 for 'db file sequential read' count=1 wait_time=17 file#=1, block#=1f07, blocks=1 for 'db file sequential read' count=1 wait_time=3264 file#=1, block#=2125, blocks=1 for 'db file sequential read' count=1 wait_time=9859 file#=1, block#=9459, blocks=1 for 'db file sequential read' count=1 wait_time=3763 file#=1, block#=179c, blocks=1 for 'db file sequential read' count=1 wait_time=15 file#=1, block#=2106, blocks=1 for 'db file sequential read' count=1 wait_time=5408 file#=1, block#=944c, blocks=1 for 'db file sequential read' count=1 wait_time=1652 file#=1, block#=2123, blocks=1 temporary object counter: 0 ---------------------------------------- Virtual Thread: kgskvt: 0x75f38710, sess: 0x7c76ce88, vc: (nil), proc: 0x7c6e7620, numapg: 1 consumer group cur: OTHER_GROUPS (upd? 0), mapped: AUTO_TASK_CONSUMER_GROUP, orig: vt_state: 0x200, vt_flags: 0x8030, blkrun: 0 is_assigned: 1, in_sched: 0 (0) vt_active: 0 (pending: 1) used quanta: 0 (cg: 0) cpu start time: 0, quantum status: 0x0 quantum checks to skip: 0, check thresh: 0 idle time: 0, active time: 0 (cg: 0) cpu yields: 0 (cg: 0), waits: 0 (cg: 0), wait time: 0 (cg: 0) queued time outs: 0, time: 0 (cur 0, cg 0) calls aborted: 0, num est exec limit hit: 0 undo current: 0k max: 0k ---------------------------------------- UOL used : 0 locks(used=2, free=1) KGX Atomic Operation Log 0x76314658 Mutex (nil)(0, 0) idn 0 oper NONE Cursor Pin uid 26 efd 18 whr 10 slp 0 KGX Atomic Operation Log 0x763146a0 Mutex 0x7789f7d0(0, 1) idn 0 oper NONE Cursor Stat uid 26 efd 12 whr 1 slp 0 oper=NONE pt1=0x7789f6a0 pt2=(nil) pt3=(nil) pt4=(nil) u41=0 stt=8 KGX Atomic Operation Log 0x763146e8 Mutex (nil)(0, 0) idn 0 oper NONE Library Cache uid 26 efd 0 whr 0 slp 0 ================== Current KGL Object ================== LIBRARY OBJECT HANDLE: handle=75b90280 mtx=0x75b903b0(0) cdp=0 name=SYS.DBMS_STATS hash=a012bf6e6c76726a5ba2921f6daf6103 timestamp=07-26-2009 06:24:37 namespace=BODY flags=KGHP/TIM/SML/[02000000] kkkk-dddd-llll=0000-0000-0000 lock=N pin=S latch#=5 hpc=0002 hlc=0002 lwt=0x75b90328[0x75b90328,0x75b90328] ltm=0x75b90338[0x75b90338,0x75b90338] pwt=0x75b902f0[0x75b902f0,0x75b902f0] ptm=0x75b90300[0x75b90300,0x75b90300] ref=0x75b90358[0x75b90358,0x75b90358] lnd=0x75b90370[0x75b90370,0x75b90370] LIBRARY OBJECT: object=7631f360 type=PKBD flags=EXS/LOC[0005] pflags=/SWR/IVR[0208] status=VALD load=X DEPENDENCIES: count=53 size=64 ACCESSES: count=53 size=64 DATA BLOCKS: data# heap pointer status pins change whr ----- -------- -------- --------- ---- ------ --- 0 786a1b80 7631f4f8 I/P/A/-/- 0 NONE 00 4 7652fa68 78135388 I/P/A/-/- 1 NONE 00 =========================== Current Instatiation Object =========================== ------------------------------------- INSTANTIATION OBJECT: object=0x2aea954c9628 type=""[48] lock=(nil) handle=(nil) body=0x75cb3578 level=0 flags=NST/NBD/LRU[954c] executions=0 sqltxt(0x7789f6a0)=call dbms_stats.gather_database_stats_job_proc ( ) hash=0e94a70eab3703d5b36b177a050e6143 parent=0x7770c0f8 maxchild=01 plk=0x77d8e458 ppn=n cursor instantiation=0x2aea954c9628 used=1278698405 child#0(0x78612398) pcs=0x7770bd08 clk=0x771eed78 ci=0x77798f90 pn=0x768d8588 ctx=0x75cb3578 kgsccflg=0 llk[0x2aea954c9630,0x2aea954c9630] idx=0 xscflg=c0100276 fl2=c040008 fl3=2222008 fl4=100 Frames pfr 0x2aea956bf1b8 siz=4984 efr 0x2aea956beec8 siz=4360 kxscphp 0x2aea9563e748 siz=984 inu=920 nps=840 ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- ---------------------------- ksedst()+31 call ksedst1() 000000000 ? 000000000 ? 7FFF17B68820 ? 7FFF17B68880 ? 7FFF17B687C0 ? 000000000 ? ksm_4031_dump()+139 call ksedst() 000000000 ? 000000000 ? 9 7FFF17B68820 ? 7FFF17B68880 ? 7FFF17B687C0 ? 000000000 ? ksmasg()+312 call ksm_4031_dump() 000000000 ? 060000058 ? 07652FA68 ? 7FFF17B68880 ? 00000F668 ? 0055F0488 ? kghnospc()+2542 call ksmasg() 000000000 ? 060000058 ? 07652FA68 ? 00000F668 ? 0600000A0 ? 7FFF17B69430 ? kghalp()+1771 call kghnospc() 006109E40 ? 07652FA68 ? 00000F668 ? 07652FAB4 ? 000000000 ? 000000001 ? baminisb()+155 call kghalp() 006109E40 ? 07652FA68 ? 00000F648 ? 000000000 ? 000000000 ? 0055F0488 ? baminis()+12 call baminisb() 006109E40 ? 07652FA68 ? 078135510 ? 002000D03 ? 000000000 ? 0055F0488 ? pkrcd()+1204 call baminis() 006109E40 ? 07652FA68 ? 078135510 ? 002000D03 ? 000000000 ? 0055F0488 ? pkilod()+452 call pkrcd() 7FFF17B699A0 ? 07652FA68 ? 075B90280 ? 002000D03 ? 000000186 ? 000000000 ? kkxlod()+199 call pkilod() 7FFF17B699A0 ? 075B90280 ? 000000004 ? 00A000000 ? 7FFF17B69C20 ? 001A8D5D0 ? kqlplslod()+390 call kkxlod() 075B90280 ? 000000004 ? 000000004 ? 7FFF17B69C20 ? 001A8D5D0 ? 079434020 ? kqlmcdlod()+9 call kqlplslod() 075B90280 ? 000000000 ? 000000000 ? 7FFF17B69C20 ? 001A8D5D0 ? 079434020 ? kqllod()+1618 call kqlmcdlod() 075B90280 ? 000000000 ? 000000000 ? 7FFF17B69C20 ? 001A8D5D0 ? 079434020 ? kglobld()+1074 call kqllod() 006109E40 ? 000000000 ? 000000000 ? 7FFF17B6AC38 ? 000000000 ? 079434020 ? kglobpn()+1185 call kglobld() 006109E40 ? 07631F360 ? 7FFF17B6BF88 ? 0773FC1F0 ? 000000000 ? 004D71360 ? kglpim()+301 call kglobpn() 006109E40 ? 0773FC1F0 ? 7FFF17B6BF88 ? 000000001 ? 0061635E0 ? 004D71360 ? kglpin()+1125 call kglpim() 006109E40 ? 7FFF17B6BF88 ? 0773FC1F0 ? 075B90280 ? 0061635E0 ? 004D71360 ? kglgob()+388 call kglpin() 006109E40 ? 7FFF17B6BF88 ? 0773AB8F8 ? 075B90280 ? 200000002 ? 17B6C5B800000002 ? kgiinb()+2986 call kglgob() 006109E40 ? 7FFF17B6BF88 ? 000000001 ? 000000002 ? 200000000 ? 17B6C5B800000002 ? peiinbd()+64 call kgiinb() 006109E40 ? 000000000 ? 000000040 ? 2AEA954E4C38 ? 7FFF17B6C5B8 ? 000000000 ? kkxpinbd()+189 call peiinbd() 7FFF17B6C1D0 ? 000000040 ? 2AEA954E4C38 ? 7FFF17B6C5B8 ? 7FFF17B6C5B8 ? 000000000 ? kgmexec()+820 call kkxpinbd() 7FFF17B6C1D0 ? 000000040 ? 7FFF17B6C5B8 ? 079434020 ? 7FFF17B6C5B8 ? 000000000 ? evapls()+686 call kgmexec() 006109E40 ? 000000001 ? 7FFF17B6C890 ? 078612398 ? 075CB2C98 ? 2AEA956BF0D0 ? evaopn2()+412 call evapls() 076BDEF30 ? 000000000 ? 2AEA954D00B0 ? 006109E40 ? 076BDEEC8 ? 2AEA956BF0D0 ? kkxmexcs()+135 call evaopn2() 076BDEF30 ? 2AEA9562EEB8 ? 2AEA954D00B0 ? 006109E40 ? 2AEA956BEEC8 ? 2AEA956BF0D0 ? opiexe()+16135 call kkxmexcs() 076BDEF30 ? 2AEA9562EEB8 ? 2AEA954D00B0 ? 076BDEE30 ? 2AEA956BEEC8 ? 2AEA956BF0D0 ? kpoal8()+2273 call opiexe() 000000049 ? 000000003 ? 7FFF17B6DC40 ? 000000003 ? 2AEA956BEEC8 ? 2AEA956BF0D0 ? opiodr()+984 call kpoal8() 00000005E ? 000000000 ? 7FFF17B71228 ? 000000003 ? 000000001 ? 2AEA956BF0D0 ? kpoodr()+450 call opiodr() 00000005E ? 000000000 ? 7FFF17B71228 ? 000000000 ? 005436850 ? 2AEA956BF0D0 ? upirtrc()+2164 call kpoodr() 2AEA954C4EE0 ? 00000005E ? 7FFF17B71228 ? 000000000 ? 005436850 ? 2AEA956BF0D0 ? kpurcsc()+125 call upirtrc() 2AEA954C4EE0 ? 00000005E ? 7FFF17B71228 ? 7FFF17B71390 ? 7FFF17B72300 ? 003A747F2 ? kpuexecv8()+1710 call kpurcsc() 7FFF17B72B00 ? 00000005E ? 7FFF17B71228 ? 7FFF17B71390 ? 7FFF17B72300 ? 003A747F2 ? kpuexec()+2602 call kpuexecv8() 2AEA954C7E50 ? 2AEA9562E6C0 ? 2AEA9562E740 ? 000000000 ? 000000000 ? 7FFF17B73BE4 ? OCIStmtExecute()+41 call kpuexec() 000000001 ? 2AEA9562E6C0 ? 2AEA954C4E70 ? 000000001 ? 2AEA00000000 ? 000000000 ? jslvec_execcb1()+19 call OCIStmtExecute() 000000001 ? 2AEA9562E6C0 ? 30 2AEA954C4E70 ? 000000001 ? 2AEA00000000 ? 000000000 ? jslvswu()+58 call jslvec_execcb1() 7FFF17B768C8 ? 000000000 ? 078735FF8 ? 000000000 ? FA000000000 ? 000000000 ? jslve_execute0()+21 call jslvswu() 000000000 ? 001F74C78 ? 90 7FFF17B768C8 ? 000000000 ? FA000000000 ? 000000000 ? jslve_execute()+278 call jslve_execute0() 7FFF17B7807C ? 000002331 ? 000000002 ? 7FFF17B78060 ? 000000000 ? 78F4503400000000 ? rpiswu2()+420 call jslve_execute() 7FFF17B77F68 ? 000000002 ? 7FFF17B7807C ? 000002331 ? 7FFF17B78060 ? 78F4503400000000 ? kkjex1e()+367 call rpiswu2() 07C76CE88 ? 000000000 ? 7FFF17B77F44 ? 000000002 ? 7FFF17B77FB8 ? 000000000 ? kkjsexe()+339 call kkjex1e() 7FFF17B7807C ? 000002331 ? 000000002 ? 7FFF17B78060 ? 0781B8FF8 ? 17B7000000000000 ? kkjrdp()+892 call kkjsexe() 7FFF17B7807C ? 000002331 ? 000000002 ? 000000000 ? 0781B8FF8 ? 17B7000000000000 ? opirip()+1140 call kkjrdp() 7FFF17B7807C ? 000002331 ? 000000002 ? 000000000 ? 0781B8FF8 ? 17B7000000000000 ? opidrv()+582 call opirip() 000000032 ? 000000004 ? 7FFF17B79768 ? 000000000 ? 0781B8FF8 ? 17B7000000000000 ? sou2o()+114 call opidrv() 000000032 ? 000000004 ? 7FFF17B79768 ? 000000000 ? 0781B8FF8 ? 17B7000000000000 ? opimai_real()+317 call sou2o() 7FFF17B79740 ? 000000032 ? 000000004 ? 7FFF17B79768 ? 0781B8FF8 ? 17B7000000000000 ? main()+116 call opimai_real() 000000003 ? 7FFF17B797D0 ? 000000004 ? 7FFF17B79768 ? 0781B8FF8 ? 17B7000000000000 ? __libc_start_main() call main() 000000003 ? 7FFF17B797D0 ? +244 000000004 ? 7FFF17B79768 ? 0781B8FF8 ? 17B7000000000000 ? _start()+41 call __libc_start_main() 0006D9178 ? 000000001 ? 7FFF17B79928 ? 000000000 ? 0781B8FF8 ? 000000003 ? ----- End of Call Stack Trace ----- ******************* Dumping process map **************** 00400000-05fa0000 r-xp 00000000 fd:1d 49677 /usr/oracle/product/10.2.0/bin/oracle 0609f000-0610a000 rwxp 05b9f000 fd:1d 49677 /usr/oracle/product/10.2.0/bin/oracle 0610a000-06193000 rwxp 0610a000 00:00 0 [heap] 60000000-7ca00000 rwxs 00000000 00:08 4849670 /SYSV4f195d94 (deleted) 2aea92f2f000-2aea92f4a000 r-xp 00000000 68:06 48296 /lib64/ld-2.4.so 2aea92f4a000-2aea92f4c000 rwxp 2aea92f4a000 00:00 0 2aea93049000-2aea9304b000 rwxp 0001a000 68:06 48296 /lib64/ld-2.4.so 2aea9304b000-2aea93074000 r-xp 00000000 fd:1d 377025 /usr/oracle/product/10.2.0/lib/libskgxp10.so 2aea93074000-2aea93174000 ---p 00029000 fd:1d 377025 /usr/oracle/product/10.2.0/lib/libskgxp10.so 2aea93174000-2aea93176000 rwxp 00029000 fd:1d 377025 /usr/oracle/product/10.2.0/lib/libskgxp10.so 2aea93176000-2aea93262000 r-xp 00000000 fd:1d 377013 /usr/oracle/product/10.2.0/lib/libhasgen10.so 2aea93262000-2aea93361000 ---p 000ec000 fd:1d 377013 /usr/oracle/product/10.2.0/lib/libhasgen10.so 2aea93361000-2aea93368000 rwxp 000eb000 fd:1d 377013 /usr/oracle/product/10.2.0/lib/libhasgen10.so 2aea93368000-2aea9336c000 rwxp 2aea93368000 00:00 0 2aea9336c000-2aea9336e000 r-xp 00000000 fd:1d 376969 /usr/oracle/product/10.2.0/lib/libskgxn2.so 2aea9336e000-2aea9346d000 ---p 00002000 fd:1d 376969 /usr/oracle/product/10.2.0/lib/libskgxn2.so 2aea9346d000-2aea9346e000 rwxp 00001000 fd:1d 376969 /usr/oracle/product/10.2.0/lib/libskgxn2.so 2aea9346e000-2aea9346f000 rwxp 2aea9346e000 00:00 0 2aea9346f000-2aea934da000 r-xp 00000000 fd:1d 377010 /usr/oracle/product/10.2.0/lib/libocr10.so 2aea934da000-2aea935da000 ---p 0006b000 fd:1d 377010 /usr/oracle/product/10.2.0/lib/libocr10.so 2aea935da000-2aea935dc000 rwxp 0006b000 fd:1d 377010 /usr/oracle/product/10.2.0/lib/libocr10.so 2aea935dc000-2aea9361c000 r-xp 00000000 fd:1d 377011 /usr/oracle/product/10.2.0/lib/libocrb10.so 2aea9361c000-2aea9371c000 ---p 00040000 fd:1d 377011 /usr/oracle/product/10.2.0/lib/libocrb10.so 2aea9371c000-2aea9371d000 rwxp 00040000 fd:1d 377011 /usr/oracle/product/10.2.0/lib/libocrb10.so 2aea9371d000-2aea9378c000 r-xp 00000000 fd:1d 377012 /usr/oracle/product/10.2.0/lib/libocrutl10.so 2aea9378c000-2aea9388b000 ---p 0006f000 fd:1d 377012 /usr/oracle/product/10.2.0/lib/libocrutl10.so 2aea9388b000-2aea93890000 rwxp 0006e000 fd:1d 377012 /usr/oracle/product/10.2.0/lib/libocrutl10.so 2aea93890000-2aea93893000 rwxp 2aea93890000 00:00 0 2aea93893000-2aea940de000 r-xp 00000000 fd:1d 376869 /usr/oracle/product/10.2.0/lib/libjox10.so 2aea940de000-2aea941de000 ---p 0084b000 fd:1d 376869 /usr/oracle/product/10.2.0/lib/libjox10.so 2aea941de000-2aea94365000 rwxp 0084b000 fd:1d 376869 /usr/oracle/product/10.2.0/lib/libjox10.so 2aea94365000-2aea94366000 rwxp 2aea94365000 00:00 0 2aea94366000-2aea9436e000 r-xp 00000000 fd:1d 377014 /usr/oracle/product/10.2.0/lib/libclsra10.so 2aea9436e000-2aea9446e000 ---p 00008000 fd:1d 377014 /usr/oracle/product/10.2.0/lib/libclsra10.so 2aea9446e000-2aea9446f000 rwxp 00008000 fd:1d 377014 /usr/oracle/product/10.2.0/lib/libclsra10.so 2aea9446f000-2aea9448b000 r-xp 00000000 fd:1d 376961 /usr/oracle/product/10.2.0/lib/libdbcfg10.so 2aea9448b000-2aea9458b000 ---p 0001c000 fd:1d 376961 /usr/oracle/product/10.2.0/lib/libdbcfg10.so 2aea9458b000-2aea9458d000 rwxp 0001c000 fd:1d 376961 /usr/oracle/product/10.2.0/lib/libdbcfg10.so 2aea9458d000-2aea9458e000 rwxp 2aea9458d000 00:00 0 2aea9458e000-2aea9487d000 r-xp 00000000 fd:1d 377136 /usr/oracle/product/10.2.0/lib/libnnz10.so 2aea9487d000-2aea9497c000 ---p 002ef000 fd:1d 377136 /usr/oracle/product/10.2.0/lib/libnnz10.so 2aea9497c000-2aea94a2d000 rwxp 002ee000 fd:1d 377136 /usr/oracle/product/10.2.0/lib/libnnz10.so 2aea94a2d000-2aea94a2e000 rwxp 2aea94a2d000 00:00 0 2aea94a4e000-2aea94a4f000 r-xp 00000000 fd:18 160744 /usr/lib64/libaio.so.1.0.1 2aea94a4f000-2aea94b4e000 ---p 00001000 fd:18 160744 /usr/lib64/libaio.so.1.0.1 2aea94b4e000-2aea94b4f000 rwxp 00000000 fd:18 160744 /usr/lib64/libaio.so.1.0.1 2aea94b4f000-2aea94b51000 r-xp 00000000 68:06 48309 /lib64/libdl-2.4.so 2aea94b51000-2aea94c51000 ---p 00002000 68:06 48309 /lib64/libdl-2.4.so 2aea94c51000-2aea94c53000 rwxp 00002000 68:06 48309 /lib64/libdl-2.4.so 2aea94c53000-2aea94c54000 rwxp 2aea94c53000 00:00 0 2aea94c54000-2aea94ca8000 r-xp 00000000 68:06 48311 /lib64/libm-2.4.so 2aea94ca8000-2aea94da7000 ---p 00054000 68:06 48311 /lib64/libm-2.4.so 2aea94da7000-2aea94da9000 rwxp 00053000 68:06 48311 /lib64/libm-2.4.so 2aea94da9000-2aea94dbb000 r-xp 00000000 68:06 48329 /lib64/libpthread-2.4.so 2aea94dbb000-2aea94eba000 ---p 00012000 68:06 48329 /lib64/libpthread-2.4.so 2aea94eba000-2aea94ebc000 rwxp 00011000 68:06 48329 /lib64/libpthread-2.4.so 2aea94ebc000-2aea94ec0000 rwxp 2aea94ebc000 00:00 0 2aea94ec0000-2aea94ed3000 r-xp 00000000 68:06 48314 /lib64/libnsl-2.4.so 2aea94ed3000-2aea94fd2000 ---p 00013000 68:06 48314 /lib64/libnsl-2.4.so 2aea94fd2000-2aea94fd4000 rwxp 00012000 68:06 48314 /lib64/libnsl-2.4.so 2aea94fd4000-2aea94fd7000 rwxp 2aea94fd4000 00:00 0 2aea94fd7000-2aea950fe000 r-xp 00000000 68:06 48303 /lib64/libc-2.4.so 2aea950fe000-2aea951fe000 ---p 00127000 68:06 48303 /lib64/libc-2.4.so 2aea951fe000-2aea95201000 r-xp 00127000 68:06 48303 /lib64/libc-2.4.so 2aea95201000-2aea95203000 rwxp 0012a000 68:06 48303 /lib64/libc-2.4.so 2aea95203000-2aea9530c000 rwxp 2aea95203000 00:00 0 2aea9530c000-2aea95310000 r-xp 00000000 fd:18 161486 /usr/lib64/libnuma.so.1 2aea95310000-2aea95410000 ---p 00004000 fd:18 161486 /usr/lib64/libnuma.so.1 2aea95410000-2aea95411000 rwxp 00004000 fd:18 161486 /usr/lib64/libnuma.so.1 2aea95411000-2aea9547c000 rwxp 2aea95411000 00:00 0 2aea95483000-2aea95490000 rwxp 00000000 00:0e 2682 /dev/zero 2aea95490000-2aea954a0000 rwxp 00000000 00:0e 2682 /dev/zero 2aea954a0000-2aea954b0000 rwxp 00000000 00:0e 2682 /dev/zero 2aea954b0000-2aea954c0000 rwxp 00000000 00:0e 2682 /dev/zero 2aea954c0000-2aea954d0000 rwxp 00000000 00:0e 2682 /dev/zero 2aea954d0000-2aea954e0000 rwxp 00000000 00:0e 2682 /dev/zero 2aea954e0000-2aea954f0000 rwxp 00000000 00:0e 2682 /dev/zero 2aea954f0000-2aea95500000 rwxp 00000000 00:0e 2682 /dev/zero 2aea95500000-2aea95503000 rwxp 0007d000 00:0e 2682 /dev/zero 2aea95523000-2aea9552d000 r-xp 00000000 68:06 48320 /lib64/libnss_files-2.4.so 2aea9552d000-2aea9562c000 ---p 0000a000 68:06 48320 /lib64/libnss_files-2.4.so 2aea9562c000-2aea9562e000 rwxp 00009000 68:06 48320 /lib64/libnss_files-2.4.so 2aea9562e000-2aea9563e000 rwxp 00000000 00:0e 2682 /dev/zero 2aea9563e000-2aea9564e000 rwxp 00000000 00:0e 2682 /dev/zero 2aea9564e000-2aea9565e000 rwxp 00000000 00:0e 2682 /dev/zero 2aea9565e000-2aea9566e000 rwxp 00000000 00:0e 2682 /dev/zero 2aea9566e000-2aea9567e000 rwxp 00000000 00:0e 2682 /dev/zero 2aea9567e000-2aea9568e000 rwxp 00000000 00:0e 2682 /dev/zero 2aea9568e000-2aea956ae000 rwxp 00000000 00:0e 2682 /dev/zero 2aea956ae000-2aea956be000 rwxp 00000000 00:0e 2682 /dev/zero 2aea956be000-2aea956de000 rwxp 00000000 00:0e 2682 /dev/zero 2aea956de000-2aea957ae000 ---p 00123000 00:0e 2682 /dev/zero 7fff17b57000-7fff17b7b000 rwxp 7fff17b57000 00:00 0 [stack] ffffffffff600000-ffffffffffe00000 ---p 00000000 00:00 0 [vdso] ******************* End of process map dump **************** ============================== Memory Utilization of Subpool 1 ================================ Allocation Name Size _________________________ __________ "free memory " 38623184 "miscellaneous " 0 "Undo Meta Data " 192 "dpslut_kfdsg " 512 "File Space Usage " 11336 "trace buffer " 3227648 "trace_knlasg " 504 "dsktab_kfgsg " 50440 "hot latch diagnostics " 160 "Wait event pointers " 336 "SEQ S.O. " 36000 "ENQUEUE STATS " 11928 "dev2node map " 4096 "dgtab_kfmdsg " 13184 "sql area " 1675568 "UNDO INFO HASH " 7904 "UNDO STAT INFO " 59904 "event classes " 128 "txncallback " 54208 "VIRTUAL CIRCUITS " 3736 "transaction " 539176 "branch " 80632 "sessions " 1234808 "dlo fib struct " 12832 "row cache " 7511248 "KCB where statistics arra" 25888 "KCB buffer wait statistic" 3352 "KCB incremental ckpt entr" 512 "invalid low rba queue " 2048 "table definiti " 0 "temporary tabl " 0 "KGSKI scheduler heap 2 de" 232 "resumable " 2720 "KESTB existence bitvec se" 128 "type object de " 0 "enqueue_hash " 23280 "branch so " 296 "KSXR pending messages que" 856352 "KSXR pending consumption " 20192 "KQF optimizer stats table" 4824 "KTI SGA freeable small po" 0 "trigger inform " 280 "trigger defini " 0 "trigger source " 0 "KTCN: Row Change Segmente" 34496 "KTCN: Obj Invalidation Se" 2336 "KTCN: Hash Table Segmente" 5184 "kolfsgi: KOLF's SGA initi" 8 "kolbsgi: KOLB's SGA initi" 8 "kmgsb circular statistics" 108800 "kgl lock hash table state" 54600 "kglsim size of pinned mem" 16048 "kglsim count of pinned he" 8160 "kzctxgjsi ksuseclid memor" 4752 "kewr MMON Remote Flush Re" 28672 "kea advisor definition ca" 480 "kelr system metrics table" 280 "CCursor " 1482016 "ksb ci process list (each" 704 "ksunfy: is parent statist" 3240 "ksunfy: nodes of hierarch" 320 "ksunfy: system-global sta" 3240 "ksuloi: long op statistic" 154800 "ksuloi: long op free list" 128 "ksuloi: long op used list" 128 "ksuloi: child latches for" 1280 "ksuloi: garbage collectio" 32 "ksbtnfy: infrequent actio" 1800 "ksfd shared pool recovery" 24 "kpummst global in the SGA" 1128 "ASM file " 19200 "Alert log " 520 "qmn tasks " 4128 "kwqmncal: allocate buffer" 4048 "call " 342536 "ksuxds ksuseclid memory " 0 "dictionary cache " 0 "threshold ale " 12192 "1:kngisga " 32088 "KEWS statistic metadata " 12032 "kelr other metrics table " 40 "User dump directory " 520 "knlu_txn_init_btree:init " 40 "groups_kfgbsg " 4096 "KSXR pending reply queue " 100280 "ksfv subheap descriptor " 184 "DISPATCHERS INFO " 240 "kglsim alloc latch area " 2720 "kgsk subheap descriptor " 136 "PCursor " 1227584 "FAL req blks " 13536 "fdhsh_kffsg " 16392 "fdrec_kffsg " 24 "work area tab " 270144 "kglsim main lru count " 76800 "kglsim free heap list " 408 "kebm run-once actions " 16 "plwpil:wa " 4264 "grplut_kfgsg " 512 "AW SGA " 40 "grptab_kfgsg " 2464 "KEWS sesstat seg tbl " 8 "kspd run-time context " 16 "enqueue resources " 168144 "processes " 1600 "Wait History " 108000 "kzekm heap descriptor " 304 "kglsim hash table bkts " 4194304 "KSXR global channels " 1288 "KSXR receive buffers " 1036000 "kelt translation table " 312 "kcbl seq io throughput " 16000 "kebm slave descriptors " 1456 "KCB Table Scan Bitmap " 248 "KCB Table Scan Buffer " 3981120 "trace buf hdr xtend " 210528 "incr ckpt write count arr" 168 "instance cnxn information" 10800 "trace events array " 68000 "PLS chunk " 352 "KEWS aggregation objs " 4032 "KSXR large reply queue " 168104 "event-class map " 3560 "KSQ event description " 5864 "kglsim main lru size " 151040 "kglsim alloc latches " 136 "kglsim recovery area " 2904 "kglsim free obj list " 408 "KESTB existence bitvec " 16384 "ksb cic process list " 584 "kso req alloc heapds " 280 "FileOpenBlock " 1899248 "alert threshol " 4136 "qmtb_init_data " 1712 "Core dump directory " 520 "sort segment handle " 7480 "latchnum to latch map " 3152 "latch hashvalue table " 1576 "PX msg pool " 827368 "LISTEN ADDRESS TABLE " 2048 "sim kghx free lists " 8 "LISTEN ADDRESS ENTRY " 56 "qesbl old rows " 1120 "procs_kfgbsg " 616 "service names array " 24 "PQ/ResSched " 1040 "SERVICE NAME ENTRY " 104 "log_checkpoint_timeout " 12360 "PQ/BizCard " 1536 "block_sizes_array " 48 "qtree_kwqbspse " 64 "PX subheap " 673024 "latch descriptor table " 1576 "State object pools " 3104 "parameters " 0 "SHARED SERVERS INFO " 240 "qtree_kwqbsgn " 64 "post agent " 0 "post stats " 1120 "SERVICE NAMES TABLE " 2048 "pspool_kfsg " 80 "active checkp " 8192 "plis struct " 136 "memory transfer history " 19208 "PL/SQL DIANA " 525216 "plwsppwp:wa " 0 "channel sga anchor " 280 "plwspv:value-1 " 0 "plwshs:temphdl " 56 "segmented arrays " 12768 "Checkpoint queue " 821248 "sim lru segments " 5120 "sim segment hits " 5120 "sim state object " 40 "partitioning d " 0 "ASH buffers " 6710888 "devs " 312 "latch recovery alignment " 56 "stat hash values " 1520 "message pool freequeue " 954768 "dups " 208 "PL/SQL MPCODE " 896392 "procs: ksunfy " 404800 "PLS non-lib hp " 16024 "sga listelement " 2048 "SYSTEM PARAMETERS " 288616 "agent name " 0 "primem_kfmdsg " 1032 "prirec_kfmdsg " 24 "sched job queue " 3616 "object queue hash buckets" 525312 "object queue hash table d" 15104 "object level stats hash t" 512 "object stat dummy statprv" 144 "PG latch table " 640 "sim cache sizes " 640 "sim cache nbufs " 640 "MTTR advisory context " 1648 "LGWR-network Server info " 27648 "LGWR debug module memory " 8192 "logout storm management " 1600 "log_simultaneous_copies " 3200 "sys event stats " 199136 "parameter handle " 48032 "Parameter Handle " 1656 "parameter blocks " 11960 "channel handle " 62080 "SWRF Alerted " 4160 "PARAMETER TABLE " 2048 "ASM map operations " 3616 "PARAMETER ENTRY " 24 "PLS cca hp desc " 352 "LGWR post requested array" 8 "post/wait queues " 6144 "bloom filter " 3104 "param hash values " 5984 "Auto tune undo info " 96 "sql area:PLSQL " 20592 "PX subheap desc " 256 "PX QC msg stats " 2288 "PX QC deq stats " 1480 "repository " 178760 "sql area:KOKA " 40480 "UNDO INFO " 16 "Log Archive Config Contex" 360 "ArchLog Dest Array " 7656 "Parameter Table " 35880 "parallel kcbibr " 32 "name-service request " 2592 "archive_lag_target " 9624 "latch nowait fails or sle" 116832 "latch recovery structures" 976 "Nettimeout Histogram " 48800 "log file size history arr" 168 "Label Cache Heap descrptr" 160 "state objects " 5680 "sched job slv " 5952 "plwppwp:value-1 " 0 "Saved job ids " 8000 "object level stat table " 864 "pso tbs: ksunfy " 104000 "private strands " 3170304 "dummy " 20992 "qm_init_sga:qmdpsg " 32 "analytic workspace " 3616 "sim trace buf " 5144 "Sort Segment " 41488 "PRESENTATION TABLE " 2048 "recov_kgqbtctx " 4392 "PX msg pool struct " 1088 "Cursor Stats " 696224 "Banner Storage " 2048 "qmps connections " 65280 "quiescing session " 3872 "SHRINK STAT " 3000 "enqueue " 493272 "rule set evalu " 0 "buffer handles " 280008 "process group array " 33808 "property service SO " 3104 "object stat dummy elem " 48 "object stat dummy stat " 144 "broker globals " 160 "DML lock " 258312 "sga dev dict " 56 "sga node map " 16 "prmtzdini tz region " 408320 "Monitor Modification Hash" 512 "Managed Standby Proc Arra" 24576 "max allowable # log files" 337600 "sim_knlasg " 1280 "OS proc request holder " 33072 "message pool context area" 11760 "media recovery state obje" 8256 "db_files " 215832 "constraints " 58120 "PX server msg stats " 2288 "PX server deq stats " 1480 "cinfo_kfnsg " 4104 "KQR M PO " 469696 "KQR L PO " 145488 "parameter table block " 346896 "KQR M SO " 215272 "KQR L SO " 51200 "KQR S SO " 27192 "KQR X PO " 2040176 "KQR X SO " 0 "kks stats " 40 "KRSF SGA " 56 "KSFV SGA " 824 "KTI-UNDO " 1690176 "KSXR SGA " 27848 "KSIR SGA " 128 "kks stbkt " 1572864 "ASM rollback operations " 2592 "plugin datafile array " 3616 "plwda:PLW_STR_NEW_RVAL " 24 "plwspv:PLW_STR_NEW_VAL " 32 "plwppwp:garbage handle " 16 "KGLS SGA " 24 "BRANCH TABLE SEGMENTED AR" 251808 "KGSK sga " 2480 "mvobj part des " 792 "KGKP sga " 32 "lckhsh_kffsg " 4104 "parameter value memory " 616 "RVWR post requested array" 8 "RTA Boundary Info thread " 12672 "lckhsr_kffsg " 24 "lcktab_kffsg " 2592 "krvxmctx " 40 "krvxlctx " 248 "PARALLEL T RECO LATCH " 25600 "JSX SGA " 112 "block media rcv state obj" 2592 "multiblock re " 16448 "parameter text value " 4616 "parallel_max_servers " 20480 "Background process state " 48 "KGLS heap " 500016 "KGSKI sga " 80 "resize request state obje" 368000 "reserved entries for all " 4096 "redo allocation latch(es)" 4160 "replication session stats" 158400 "modification " 151808 "monitoring co " 20800 "buffers waiting for write" 24 "rules engine aggregate st" 1416 "krbmror " 4659200 "ksfqpar " 479512 "krvxdka " 592 "joxs heap " 4272 "krbmrsr " 616 "quiesce system context " 384 "network connections " 62880 "SGA Obsolete Param Source" 16 "SGA param ownership table" 192 "SGA structure for SWRF (K" 240 "SGA struct - SWRF Metrics" 2096 "kga sga " 8 "SGA - SWRF RawMet Runtime" 3280 "osp pool handles " 8 "SGA - SWRF DrvMet Runtime" 4960 "SGA - SWRF Metrics WCTime" 1216 "SGA - SWRF Metrics ksuTim" 1216 "SGA - SWRF Time Model Bas" 64 "SGA - AWR Metric RBSM str" 904 "SQL Memory Manager Base W" 13400 "kks sga " 48 "change tracking state cha" 3744 "simulator latch/bucket st" 11264 "Prefetch history buffer " 11328 "pso child tracebuf ptrs " 1600 "client/application info l" 1280 "KSK SGA " 76592 "change tracking recovery " 262144 "kksss " 12528 "change notification regis" 16416 "change notification obj m" 16416 "MS alert log " 72704 "knlsg " 120 "kohsg " 8 "kponfy " 672 "kfmsg " 3608 "KFK SGA " 1144 "KGLS SD " 2592 "KGLS SP " 4704 "sys event stats for Other" 199136 "latch classes " 352 "system default language h" 568 "name-service table " 15856 "name-service entry " 2592 "cross-platform compliance" 2120 "kkzias " 144 "library cache " 10244392 "kzull " 1024 "kokcd " 0 "ksfqpa " 60960 "ksfqpn " 524328 "Array of cached attr " 400 "spfile callback table: ks" 448 "KKJ SGA " 848 "knstsg " 48 "kcrrny " 33760 "spfile cleanup structure " 16760 "kfasga " 1048 "kfdsga " 120 "kfgsga " 104 "kfgbsg " 40 "kfmdsg " 144 "kffsga " 120 "Client ID trace setting h" 536 "Service-level trace setti" 536 "buffer_pool_desc_array " 3384 "KGX " 122984 "Service-level ID trace se" 3744 "row cache child latch " 6560 "KQR ENQ " 90816 "kzulu " 1568 "CGS system incarn array " 24864 "LRMPD SGA Table " 167440 "SCHEDULING POLICY TABLE " 160 "namhsh_kfdsg " 4104 "namrec_kfdsg " 24 "namhsh_kfgsg " 288 "Closed Thread SCN Bitvec " 8448 "msg Q child latches " 896 "Client ID trace settings " 3872 "osp allocation " 99480 "os statistics " 48 "policy hash table descrpt" 280 "Policy Cache Heap descrpt" 160 "plwda:PLW_STR_NEW_VAL_VEC" 24 "plwda:PLW_STR_NEW_LEN_VEC" 8 "plwppwp: kglpql warnings " 0 "plwppwp:PLW_STR_NEW_VAL_V" 40 "plwppwp:PLW_STR_NEW_LEN_V" 16 "plwgc: plwgc_garbage_clea" 0 "plwiiw: kglpql warnings " 0 "obj stat memo " 529416 "obj htab chun " 504168 "object queue " 240352 "object level " 99456 "SCHEDULING POLICY VECTOR " 104 "SGA - SWRF Metric Eidbuf " 106440 "process count for each CI" 296 "Pre-Warm Initialized Seti" 512 "Processor group descripto" 256 "Prefetch history buffer a" 320 "Prefetch client count per" 32 "rules engine context " 200 "ptr to sessions under idl" 64 "channel context areas " 31304 "sim trace buf context " 200 "Cleanup state objects " 384 "heap_kfsg " 136 "slave class sga anchor " 88 "simulator hash buckets " 66560 "State object subpools " 3840 "returns from metrics req " 763904 "resize operation history " 28808 "reservation state object " 2744 "AQ Propagation Scheduling" 16000 "AWR Table Info (KEW layer" 872 "character set memory " 37296 "simulator hash latch " 20480 "sim segment num bufs " 2560 "character set object " 408152 "alter system errs: kspnfy" 114688 "Active Session History - " 1528 "OS file lock " 4416 "session idle latches " 1280 "sess Q child latches " 896 "set_descriptor_array " 43776 "SQL Workarea Histogram " 1056 "qesmmaInitialize: ia_qesm" 264 "qesmmaInitialize: ta_qesm" 264 "returns from remote ops " 49152 "qesmmaInitialize: oa_qesm" 112 "qesmmaInitialize: " 112 "qesmmaInitialize: pa_qesm" 11088 "SGA - SWRF Metric CHBs " 433552 "SGA Param Source Table " 192 "SGA structure for kelr " 2336 "listener addresses " 8 "db_block_hash_buckets " 1474560 "java static objs " 32128 "KSI resource types " 2704 "temporary foreign ref " 2848 "kglsim object batch " 2658432 "kglsim pin list arr " 1224 "trigger condition node " 72 "downed inst bit vector " 40 "ktlbk state objects " 171912 "ksb process so list " 584 "ksws service object " 2064 "ksws service events " 27840 "x$rule_set " 17608 "Heap0: KGL " 766256 "time manager context " 40 "fixed allocation callback" 1128 "kqlpWrntoStr:string " 208 "file # to first dba, exte" 2416 "error message file name " 48 "flashback_marker_cache_si" 9200 "done Q child latches " 896 "kscdnfyglobalflags " 8 "kqlpWrntoStr:value " 0 "kqlpPlsClnup:string " 0 "KEWS statistic name " 1760 "KEWS statistic maps " 2728 "KCB private handles " 2400 "temporary table lock " 3744 "KEWS sysstat values " 256 "KEWS sesstat values " 115200 "kebm slave message " 152 "kcbl state objects " 12800 "KTI latch structure " 3840 "DBWR event stats array " 192 "list " 4096 "kcrfa structures " 9152 "KCB undo bitvec " 4096 "kebm slave reply " 88 "kgllk hash table " 798720 "X$KSFQP ANCHOR " 80 "ksfm state object " 32 "event descriptor table " 49976 "ksir State Object " 3360 "kpssnfy: kpsssgct " 32 "kpscad: kpscscon " 138952 "dbwriter coalesce buffer " 1049088 "ksmd unit test 1 " 5184 "ksim client list " 168 "kscdnfyinitflags " 8 "ksws RLB SGA ctx " 40 "dbwriter coalesce bitmap " 64 "KTC cch latches " 1760 "KTI pool states " 24 "kglsim latch area " 2720 "kglsim hash table " 8208 "hssk hofciac/1 " 30272 "hssk hofcidc/1 " 0 "kebm test replies " 28672 "kghx free lists " 41216 "kcbl statistics " 6144 "Global Context Heap descr" 400 "kks stats latch " 640 "KTC latch cleanup " 288 "generic process shared st" 456 "KTU latch cleanup " 1248 "KUPP subheap desc " 232 "Detached dump directory " 520 "KSFQ buffer pool " 3872 "kspload:comment " 24 "x$ksmfs table " 24 "ksv slave class " 14512 "kscdnfyinithead " 16 "kscdnfyinitnext " 16 "kscdnfyinitprev " 16 "writes stopped lock state" 24 "writes stopped lock conte" 24 "X$KSVII table " 512 "kxfpdp pointers " 28800 "X$KSVIS table " 128 "X$KSVIT table " 512 "idtab_kfksg " 44296 "KEWS External IDs " 768 "kodosgi kopfdo " 416 "kqlpaac:value-1 " 360 "KSPD key heap " 4136 "kglsim latches " 136 "kgas nsintrctx " 0 "kcrrorlerr.alo " 48 "TXN TABLE SEGMENTED ARRAY" 208864 "KFG state obj " 4128 "FileIdentificatonBlock " 449664 "kzsrs filename " 536 "KFM state obj " 3360 "KKJ SHRD WRQS " 288 "kso req alloc " 4136 "distributed_transactions-" 20984 "kwqmncini-slv " 240 "kwqmncini-tbl " 272 "KKKI consumer " 4136 "dbwr message active flag " 8 "dbwr outstanding ios per " 64 "dbwr suspend/resume ptr a" 16 "database creation languag" 568 "database NCHAR language h" 568 "dbwr working sets kcbdbws" 16 "dbwr suspend/resume array" 16 "dbwr actual working sets " 64 "dbwriter coalesce struct " 48 "KCB Table Scan " 40 "KCK type array " 936 "Temporary storage for RTA" 16 "temp lob duration state o" 3296 "messages " 41600 "joxs struct " 144 "Temporary Tables State Ob" 56424 "trace buffer header array" 35088 "Transportable DB Converte" 4632 "KTU lat struct " 1760 "KGSK scheduler " 161320 "KTUR HIST INFO " 4840 "kks stats mem " 64 "kks stats hds " 1024 "KRBMROS ANCHOR " 96 "kodosgi kodos " 32 "HTTP fixed headers " 72 "KEWS fixed SGA " 4600 "jsksncb: 2 " 7648 "jsksncb: 7 " 489472 "UNDO INFO SEGMENTED ARRAY" 45832 "jsksncb: 9 " 28992 "jsksncb: 8 " 1024 "KSFD SGA I/O b " 3977064 "KGSKI schedule " 56976 "KTC latches " 1760 "ksleid alloc " 112 "KTU latches " 1320 "KSI Indexes " 288 "KTI latches " 768 "kwqicaqe2kc1 " 8208 "kkj jobq wor " 4128 "jsksncb: 6 " 3480 "jsksncb: 3 " 4048 "jsksncb: 4 " 4080 "where to latch num map " 7304 "KKJ WRK LAT " 480 "kkj jobq slav " 1280 "koh dur heap " 352 "KSN WaitID " 520 "file # translation table " 33656 "KGX rowlist " 1344 "nods " 208 "kwrsnfy: kwrs " 1624 "kfkhsh_kfdsg " 4104 "kfkrec_kfdsg " 24 "jsksncb-latch " 2584 "kfkid hash " 4104 "kglsim sga " 30456 "enqueue_hash_chain_latche" 1280 "kfkid hrec " 24 "KTPR HIST TB " 2808 "KTPR SUBHEAP " 168 "KTF MAPPINGS " 12288 "kksss-heap " 21304 "KTCCC OBJECT " 0 "ksv reaper " 4128 "kglsim heap " 1568448 "event statistics per sess" 2088000 "event statistics ptr arra" 1800 "eventlist to post commits" 336 "kzulsg SGA " 2080 "KFG SO child " 5056 "KGKP randnum " 40000 LIBRARY CACHE STATISTICS: namespace gets hit ratio pins hit ratio reloads invalids -------------- --------- --------- --------- --------- ---------- ---------- CRSR 16280166 0.803 156349384 0.958 728622 120019 TABL 8328267 0.956 37705062 0.937 1021308 0 BODY 322675 0.977 1969677 0.990 11494 0 TRGR 7450 0.706 2974559 0.999 1482 0 INDX 16923 0.376 33543 0.611 1802 0 CLST 53422 0.985 114510 0.970 2586 0 KGLT 0 0.000 0 0.000 0 0 PIPE 0 0.000 0 0.000 0 0 LOB 0 0.000 0 0.000 0 0 DIR 31 0.000 62 0.000 0 0 QUEU 628 0.997 4743908 1.000 707 0 OBJG 0 0.000 0 0.000 0 0 PROP 0 0.000 0 0.000 0 0 JVSC 0 0.000 0 0.000 0 0 JVRE 0 0.000 0 0.000 0 0 ROBJ 0 0.000 0 0.000 0 0 REIP 0 0.000 0 0.000 0 0 CPOB 0 0.000 0 0.000 0 0 EVNT 405448 0.995 946098 0.991 6025 0 SUMM 0 0.000 0 0.000 0 0 DIMN 0 0.000 0 0.000 0 0 CTX 6 0.167 11 0.545 0 0 OUTL 0 0.000 0 0.000 0 0 RULS 1 0.000 2430 0.849 366 0 RMGR 188 0.824 99700 0.988 1165 0 XDBS 0 0.000 0 0.000 0 0 PPLN 0 0.000 0 0.000 0 0 PCLS 0 0.000 0 0.000 0 0 SUBS 1668 0.748 7185 0.838 740 0 LOCS 0 0.000 0 0.000 0 0 RMOB 0 0.000 0 0.000 0 0 RSMD 0 0.000 0 0.000 0 0 JVSD 0 0.000 0 0.000 0 0 STFG 0 0.000 0 0.000 0 0 TRANS 0 0.000 0 0.000 0 0 RELC 0 0.000 0 0.000 0 0 RULE 0 0.000 0 0.000 0 0 STRM 0 0.000 0 0.000 0 0 REVC 367 0.482 0 0.000 0 0 STAP 0 0.000 0 0.000 0 0 RELS 0 0.000 0 0.000 0 0 RELD 0 0.000 0 0.000 0 0 IFSD 0 0.000 0 0.000 0 0 XDBC 0 0.000 0 0.000 0 0 USAG 29 0.655 29 0.483 5 0 MVOBTBL 24826 0.705 24434 0.696 0 0 JSQI 0 0.000 0 0.000 0 0 CDC 0 0.000 0 0.000 0 0 MVOBIND 26171 0.700 25882 0.692 0 0 STBO 0 0.000 0 0.000 0 0 HTSO 0 0.000 0 0.000 0 0 JSGA 78837 0.997 973787 0.998 1452 0 JSET 6 0.000 6 0.000 0 0 TABL_T 1871 0.000 1871 0.000 0 0 CLST_T 0 0.000 0 0.000 0 0 INDX_T 636 0.000 636 0.000 0 0 NSCPD 0 0.000 0 0.000 0 0 JSLV 0 0.000 0 0.000 0 0 MODL 0 0.000 0 0.000 0 0 CUMULATIVE 25549616 0.859 205972774 0.956 1777754 120019 Permanent space allocated for Load Locks LATCH:0 TOTAL SPACE: 4104 FREELIST CHUNK COUNT:56 OBJECT SIZE:72 Permanent space allocated for KGL pins LATCH:0 TOTAL SPACE: 53040 FREELIST CHUNK COUNT:246 OBJECT SIZE:136 LATCH:1 TOTAL SPACE: 53040 FREELIST CHUNK COUNT:262 OBJECT SIZE:136 LATCH:2 TOTAL SPACE: 53040 FREELIST CHUNK COUNT:270 OBJECT SIZE:136 LATCH:3 TOTAL SPACE: 61200 FREELIST CHUNK COUNT:250 OBJECT SIZE:136 LATCH:4 TOTAL SPACE: 48960 FREELIST CHUNK COUNT:208 OBJECT SIZE:136 LATCH:5 TOTAL SPACE: 65280 FREELIST CHUNK COUNT:320 OBJECT SIZE:136 LATCH:6 TOTAL SPACE: 36720 FREELIST CHUNK COUNT:126 OBJECT SIZE:136 LATCH:7 TOTAL SPACE: 53040 FREELIST CHUNK COUNT:246 OBJECT SIZE:136 LATCH:8 TOTAL SPACE: 53040 FREELIST CHUNK COUNT:254 OBJECT SIZE:136 LATCH:9 TOTAL SPACE: 81600 FREELIST CHUNK COUNT:432 OBJECT SIZE:136 LATCH:10 TOTAL SPACE: 53040 FREELIST CHUNK COUNT:254 OBJECT SIZE:136 Permanent space allocated for KGL locks LATCH:0 TOTAL SPACE: 242880 FREELIST CHUNK COUNT:744 OBJECT SIZE:184 LATCH:1 TOTAL SPACE: 157872 FREELIST CHUNK COUNT:522 OBJECT SIZE:184 LATCH:2 TOTAL SPACE: 238832 FREELIST CHUNK COUNT:890 OBJECT SIZE:184 LATCH:3 TOTAL SPACE: 315744 FREELIST CHUNK COUNT:1012 OBJECT SIZE:184 LATCH:4 TOTAL SPACE: 206448 FREELIST CHUNK COUNT:594 OBJECT SIZE:184 LATCH:5 TOTAL SPACE: 388608 FREELIST CHUNK COUNT:1400 OBJECT SIZE:184 LATCH:6 TOTAL SPACE: 190256 FREELIST CHUNK COUNT:626 OBJECT SIZE:184 LATCH:7 TOTAL SPACE: 255024 FREELIST CHUNK COUNT:866 OBJECT SIZE:184 LATCH:8 TOTAL SPACE: 255024 FREELIST CHUNK COUNT:890 OBJECT SIZE:184 LATCH:9 TOTAL SPACE: 356224 FREELIST CHUNK COUNT:1264 OBJECT SIZE:184 LATCH:10 TOTAL SPACE: 242880 FREELIST CHUNK COUNT:840 OBJECT SIZE:184 Permanent space allocated for KGL S handles LATCH:0 TOTAL SPACE: 76800 FREELIST CHUNK COUNT:55 OBJECT SIZE:480 LATCH:1 TOTAL SPACE: 69600 FREELIST CHUNK COUNT:50 OBJECT SIZE:480 LATCH:2 TOTAL SPACE: 87840 FREELIST CHUNK COUNT:55 OBJECT SIZE:480 LATCH:3 TOTAL SPACE: 84960 FREELIST CHUNK COUNT:55 OBJECT SIZE:480 LATCH:4 TOTAL SPACE: 86400 FREELIST CHUNK COUNT:59 OBJECT SIZE:480 LATCH:5 TOTAL SPACE: 77280 FREELIST CHUNK COUNT:56 OBJECT SIZE:480 LATCH:6 TOTAL SPACE: 83040 FREELIST CHUNK COUNT:51 OBJECT SIZE:480 LATCH:7 TOTAL SPACE: 82560 FREELIST CHUNK COUNT:60 OBJECT SIZE:480 LATCH:8 TOTAL SPACE: 82080 FREELIST CHUNK COUNT:63 OBJECT SIZE:480 LATCH:9 TOTAL SPACE: 80640 FREELIST CHUNK COUNT:52 OBJECT SIZE:480 LATCH:10 TOTAL SPACE: 83040 FREELIST CHUNK COUNT:57 OBJECT SIZE:480 Permanent space allocated for KGL M handles LATCH:0 TOTAL SPACE: 77280 FREELIST CHUNK COUNT:16 OBJECT SIZE:672 LATCH:1 TOTAL SPACE: 79296 FREELIST CHUNK COUNT:47 OBJECT SIZE:672 LATCH:2 TOTAL SPACE: 79296 FREELIST CHUNK COUNT:36 OBJECT SIZE:672 LATCH:3 TOTAL SPACE: 85344 FREELIST CHUNK COUNT:54 OBJECT SIZE:672 LATCH:4 TOTAL SPACE: 90720 FREELIST CHUNK COUNT:53 OBJECT SIZE:672 LATCH:5 TOTAL SPACE: 84000 FREELIST CHUNK COUNT:51 OBJECT SIZE:672 LATCH:6 TOTAL SPACE: 81312 FREELIST CHUNK COUNT:37 OBJECT SIZE:672 LATCH:7 TOTAL SPACE: 88032 FREELIST CHUNK COUNT:54 OBJECT SIZE:672 LATCH:8 TOTAL SPACE: 90720 FREELIST CHUNK COUNT:42 OBJECT SIZE:672 LATCH:9 TOTAL SPACE: 86688 FREELIST CHUNK COUNT:53 OBJECT SIZE:672 LATCH:10 TOTAL SPACE: 92736 FREELIST CHUNK COUNT:46 OBJECT SIZE:672 Permanent space allocated for KGL L handles LATCH:0 TOTAL SPACE: 63104 FREELIST CHUNK COUNT:59 OBJECT SIZE:928 LATCH:1 TOTAL SPACE: 64032 FREELIST CHUNK COUNT:49 OBJECT SIZE:928 LATCH:2 TOTAL SPACE: 55680 FREELIST CHUNK COUNT:44 OBJECT SIZE:928 LATCH:3 TOTAL SPACE: 64032 FREELIST CHUNK COUNT:59 OBJECT SIZE:928 LATCH:4 TOTAL SPACE: 64032 FREELIST CHUNK COUNT:55 OBJECT SIZE:928 LATCH:5 TOTAL SPACE: 65888 FREELIST CHUNK COUNT:56 OBJECT SIZE:928 LATCH:6 TOTAL SPACE: 75168 FREELIST CHUNK COUNT:56 OBJECT SIZE:928 LATCH:7 TOTAL SPACE: 61248 FREELIST CHUNK COUNT:56 OBJECT SIZE:928 LATCH:8 TOTAL SPACE: 68672 FREELIST CHUNK COUNT:61 OBJECT SIZE:928 LATCH:9 TOTAL SPACE: 67744 FREELIST CHUNK COUNT:54 OBJECT SIZE:928 LATCH:10 TOTAL SPACE: 70528 FREELIST CHUNK COUNT:60 OBJECT SIZE:928 Permanent space allocated for KGL A handles LATCH:0 TOTAL SPACE: 32928 FREELIST CHUNK COUNT:51 OBJECT SIZE:336 LATCH:1 TOTAL SPACE: 28896 FREELIST CHUNK COUNT:55 OBJECT SIZE:336 LATCH:2 TOTAL SPACE: 31248 FREELIST CHUNK COUNT:41 OBJECT SIZE:336 LATCH:3 TOTAL SPACE: 36288 FREELIST CHUNK COUNT:48 OBJECT SIZE:336 LATCH:4 TOTAL SPACE: 24864 FREELIST CHUNK COUNT:47 OBJECT SIZE:336 LATCH:5 TOTAL SPACE: 32592 FREELIST CHUNK COUNT:53 OBJECT SIZE:336 LATCH:6 TOTAL SPACE: 38640 FREELIST CHUNK COUNT:56 OBJECT SIZE:336 LATCH:7 TOTAL SPACE: 26880 FREELIST CHUNK COUNT:51 OBJECT SIZE:336 LATCH:8 TOTAL SPACE: 45024 FREELIST CHUNK COUNT:54 OBJECT SIZE:336 LATCH:9 TOTAL SPACE: 31248 FREELIST CHUNK COUNT:49 OBJECT SIZE:336 LATCH:10 TOTAL SPACE: 28560 FREELIST CHUNK COUNT:45 OBJECT SIZE:336 Permanent space allocated for KGL objects LATCH:0 TOTAL SPACE: 13248 FREELIST CHUNK COUNT:35 OBJECT SIZE:144 LATCH:1 TOTAL SPACE: 11232 FREELIST CHUNK COUNT:35 OBJECT SIZE:144 LATCH:2 TOTAL SPACE: 14832 FREELIST CHUNK COUNT:31 OBJECT SIZE:144 LATCH:3 TOTAL SPACE: 15264 FREELIST CHUNK COUNT:47 OBJECT SIZE:144 LATCH:4 TOTAL SPACE: 11376 FREELIST CHUNK COUNT:27 OBJECT SIZE:144 LATCH:5 TOTAL SPACE: 14976 FREELIST CHUNK COUNT:40 OBJECT SIZE:144 LATCH:6 TOTAL SPACE: 15120 FREELIST CHUNK COUNT:33 OBJECT SIZE:144 LATCH:7 TOTAL SPACE: 13536 FREELIST CHUNK COUNT:53 OBJECT SIZE:144 LATCH:8 TOTAL SPACE: 17136 FREELIST CHUNK COUNT:36 OBJECT SIZE:144 LATCH:9 TOTAL SPACE: 13104 FREELIST CHUNK COUNT:37 OBJECT SIZE:144 LATCH:10 TOTAL SPACE: 14112 FREELIST CHUNK COUNT:38 OBJECT SIZE:144 Permanent space allocated for KGL handle dependents LATCH:0 TOTAL SPACE: 52800 FREELIST CHUNK COUNT:32 OBJECT SIZE:264 LATCH:1 TOTAL SPACE: 49896 FREELIST CHUNK COUNT:37 OBJECT SIZE:264 LATCH:2 TOTAL SPACE: 58872 FREELIST CHUNK COUNT:34 OBJECT SIZE:264 LATCH:3 TOTAL SPACE: 58872 FREELIST CHUNK COUNT:48 OBJECT SIZE:264 LATCH:4 TOTAL SPACE: 62568 FREELIST CHUNK COUNT:56 OBJECT SIZE:264 LATCH:5 TOTAL SPACE: 54120 FREELIST CHUNK COUNT:53 OBJECT SIZE:264 LATCH:6 TOTAL SPACE: 57288 FREELIST CHUNK COUNT:29 OBJECT SIZE:264 LATCH:7 TOTAL SPACE: 56496 FREELIST CHUNK COUNT:55 OBJECT SIZE:264 LATCH:8 TOTAL SPACE: 55968 FREELIST CHUNK COUNT:50 OBJECT SIZE:264 LATCH:9 TOTAL SPACE: 60456 FREELIST CHUNK COUNT:59 OBJECT SIZE:264 LATCH:10 TOTAL SPACE: 57024 FREELIST CHUNK COUNT:36 OBJECT SIZE:264 Did Not dump SGA Heap desc=0x60000058. Current time: 07/10/2010 06:00:06 Last SGA heap dump at 06/22/2010 22:00:03 SGA Heap Dump Count = 10 =============================== End 4031 Diagnostic Information =============================== Warning: out of shared memory loading library cache object [handle=75b90280] SYS.DBMS_STATS *** 2010-07-10 06:00:06.587 ORA-12012: error on auto execute of job 9009 ORA-04031: unable to allocate ORA-04031: unable to allocate 63080 bytes of shared memory ("shared pool","DBMS_STATS","PL/SQL MPCODE","BAMIMA: Bam Buffer") bytes of shared memory ("","","","") ###################################################### When i run the AWR report i am getting below error. ##################################################### Specify the Report Name ~~~~~~~~~~~~~~~~~~~~~~~ The default report file name is awrrpt_1_18618_18620.txt. To use this name, press to continue, otherwise enter an alternative. Enter value for report_name: /tmp/awr_database_name.txt Using the report name /tmp/awr_database_name.txt select output from table(dbms_workload_repository.awr_report_text( :dbid, * ERROR at line 1: ORA-04031: unable to allocate 95784 bytes of shared memory ("shared pool","DBMS_SWRF_REPORT_INTERNAL","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_SWRF_REPORT_INTERNAL" ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 283 ORA-06512: at line 1 ###########