最近一直遇到一个棘手的问题，数据库用一段 时间后就会出现Shared_pool不足，不管我设置多大都会有这个问题。
所有的SQL语句无法运行
SQL> show parameter sga;
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-04031: 无法分配 3896 字节的共享内存 ("shared pool","select NUM , NAME ,
TYPE , ...","sga heap(2,0)","kglsim object batch")复制代码
Oracle 版本信息
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
SQL>复制代码出错的trace文件信息，有哪位大神能帮忙分析下原因吗，下面标红的地方是我个人觉得有问题的地方。
Trace file E:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_5636.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 8 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:8816M/16383M, Ph+PgF:11449M/19905M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 85
Windows thread id: 5636, image: ORACLE.EXE (SHAD)
*** 2014-06-13 11:37:10.248
*** CLIENT ID:() 2014-06-13 11:37:10.248
*** SERVICE NAME:() 2014-06-13 11:37:10.248
*** MODULE NAME:() 2014-06-13 11:37:10.248
*** ACTION NAME:() 2014-06-13 11:37:10.248
AUTO MEM: PGA getfail 43 for 53, 31, 1, 16777216, 5553258496, 889192448, 53, 6442450944, 7
AUTO MEM: backup fail a, 0, 16777216, 331, 330, 0, 15
*** 2014-06-13 11:37:10.248
=================================
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=06/13/2014 11:37:09
Dump Count=1
Allocation request for: call
Heap: 000000000BC55D68, size: 3000
******************************************************
HEAP DUMP heap name="sga heap(2,0)" desc=000000000BC55D68
extent sz=0xfe0 alt=248 het=32767 rec=9 flg=-126 opc=0
parent=0000000000000000 owner=0000000000000000 nex=0000000000000000 xsz=0x1000000 heap=0000000000000000
fl2=0x20, nex=0000000000000000
latch set 2 of 2
durations enabled for this heap
reserved granules for root 0 (granule size 16777216)
====================
Process State Object
====================
----------------------------------------
SO: 0x00000002C668BCD0, type: 2, owner: 0x0000000000000000, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x00000002C668BCD0, name=process, file=ksu.h LINE:12451, pg=0
(process) Oracle pid:85, ser:201, calls cur/top: 0x0000000000000000/0x0000000000000000
flags : (0x0) -
flags2: (0x0), flags3: (0x0)
intr error: 0, call error: 0, sess error: 0, txn error 0
intr queue: empty
ksudlp FALSE at location: 0
(post info) last post received: 2824 0 2
last post received-location: ksl2.h LINE:2293 ID:kslpsr
last process to post me: c66642b0 1 6
last post sent: 0 0 26
last post sent-location: ksa2.h LINE:282 ID:ksasnd
last process posted by me: c66642b0 1 6
(latch info) wait_event=0 bits=20
holding (efd=3) 49013300 call allocation level=5
Location from where latch is held: ksu.h LINE:13432 ID:ksucrp: top call:
Context saved from call: 0
state=busy [holder orAPId=85] wlstate=free [value=0]
waiters [orapid (seconds since: put on list, posted, alive check)]:
89 (52, 1402630629, 52)
58 (46, 1402630629, 46)
122 (39, 1402630629, 39)
115 (32, 1402630629, 32)
83 (29, 1402630629, 29)
245 (26, 1402630629, 26)
253 (26, 1402630629, 26)
26 (26, 1402630629, 26)
254 (18, 1402630629, 18)
70 (16, 1402630629, 16)
281 (12, 1402630629, 12)
40 (12, 1402630629, 12)
248 (12, 1402630629, 12)
13 (5, 1402630629, 5)
waiter count=14
O/S info: user: SYSTEM, term: ZICHAN, ospid: 5636
OSD pid info: Windows thread id: 5636, image: ORACLE.EXE (SHAD)
PSO child state object changes :
Dump of memory from 0x00000002C6645970 to 0x00000002C6645B78
2C6645970 00000000 00000000 00000000 00000000 [................]
Repeat 31 times
2C6645B70 00000000 00000000 [........]
...No session state object
...No current library cache object being loaded
===========================
Current Instatiation Object
===========================
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
*** 2014-06-13 11:37:10.420
ksedst1()+129 CALL??? skdstdst() 000023558 01D340190 0840EE180
14900A100
ksedst()+69 CALL??? ksedst1() 000000000 000000000 000000000
000000000
ksm_4031_dump()+109 CALL??? ksedst() 000000000 000000001 000000001
2 01D340750
ksmasg()+368 CALL??? ksm_4031_dump() 030ADF501 000000BB8 000000BB8
100000000
kghnospc()+2001 CALL??? ksmasg() 00000003C 01D340190 030ADF580
000C8C837
kghalo()+1978 CALL??? kghnospc() 01D340750 00BC55D68 200000BB8
00BC55DB4
ksmdacnk()+329 CALL??? kghalo() 00000000A 000000000 000000008
000000000
ksmdget()+1025 CALL??? ksmdacnk() 000000000 2ABB92A18 000005630
01D340190
kssadpm()+388 CALL??? ksmdget() 2C95BB9B8 867327C7138B
000000000 01D340190
ksucrp()+1253 CALL??? kssadpm() 019C23578 000000000 0840EE1E0
0FFFFFFFF
opiino()+1905 CALL??? ksucrp() 000000000 000000000 100000000
0007BCBDD
opiodr()+1607 CALL??? opiino() 00000003C 000000004 0840EFAB0
000000000
opidrv()+862 CALL??? opiodr() 00000003C 000000004 0840EFAB0
415C3A4500000000
sou2o()+98 CALL??? opidrv()+150 00000003C 000000004 0840EFAB0
000000000
opimai_real()+158 CALL??? sou2o() 1CF86B89A89E12F 000000000
B000D000607DE 500BA00040024
opimai()+191 CALL??? opimai_real() 000000000 0840EFC68 030ADF580
0840EFC68
OracleThreadStart() CALL??? opimai() 000000000 147472270 0000000E8
+724 000002424
00000000772759ED CALL??? OracleThreadStart() 0414FFF18 000000000 000000000
000000000
00000000773AC541 CALL??? 00000000772759E0 000000000 000000000 000000000
000000000
call stack performance statistics:
total : 0.184000 sec
setup : 0.000000 sec
stack unwind : 0.159000 sec
symbol translation : 0.024000 sec
printing the call stack: 0.001000 sec
printing frame data : 0.000000 sec
printing argument data : 0.000000 sec
----- End of Call Stack Trace -----
----- Process Map Dump -----
------------------- Memory Map of process ----------------
Start Address -End Address Type Size ModuleName
0x0000000140000000-0x0000000149060FFF Image 00000151392256 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORACLE.EXE
0x0000000077380000-0x0000000077528FFF Image 00000001740800 C:\WINDOWS\SYSTEM32\NTDLL.DLL
0x0000000077260000-0x000000007737EFFF Image 00000001175552 C:\WINDOWS\SYSTEM32\KERNEL32.DLL
0x000007FEFD4A0000-0x000007FEFD50BFFF Image 00000000442368 C:\WINDOWS\SYSTEM32\KERNELBASE.DLL
0x0000000180000000-0x0000000180520FFF Image 00000005378048 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORACLIENT11.DLL
0x00000000005B0000-0x0000000000712FFF Image 00000001454080 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORACORE11.DLL
0x0000000000720000-0x000000000081FFFF Image 00000001048576 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANLS11.DLL
0x00000000003F0000-0x000000000040FFFF Image 00000000131072 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAUNLS11.DLL
0x0000000074CE0000-0x0000000074DA8FFF Image 00000000823296 C:\WINDOWS\WINSXS\AMD64_MICROSOFT.VC80.CRT_1FC8B3B9A1E18E3B_8.0.50727.4940_NONE_88DF89932FAF0BF6\MSVCR80.DLL
0x000007FEFD790000-0x000007FEFD82EFFF Image 00000000651264 C:\WINDOWS\SYSTEM32\MSVCRT.DLL
0x0000000000420000-0x0000000000426FFF Image 00000000028672 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAUTS.DLL
0x000007FEFF3C0000-0x000007FEFF5C2FFF Image 00000002109440 C:\WINDOWS\SYSTEM32\OLE32.DLL
0x000007FEFF5D0000-0x000007FEFF636FFF Image 00000000421888 C:\WINDOWS\SYSTEM32\GDI32.DLL
0x0000000077160000-0x0000000077259FFF Image 00000001024000 C:\WINDOWS\SYSTEM32\USER32.DLL
0x000007FEFDC70000-0x000007FEFDC7DFFF Image 00000000057344 C:\WINDOWS\SYSTEM32\LPK.DLL
0x000007FEFD6A0000-0x000007FEFD768FFF Image 00000000823296 C:\WINDOWS\SYSTEM32\USP10.DLL
0x000007FEFD830000-0x000007FEFD95CFFF Image 00000001232896 C:\WINDOWS\SYSTEM32\RPCRT4.DLL
0x0000000077550000-0x0000000077556FFF Image 00000000028672 C:\WINDOWS\SYSTEM32\PSAPI.DLL
0x000007FEFF640000-0x000007FEFF68CFFF Image 00000000315392 C:\WINDOWS\SYSTEM32\WS2_32.DLL
0x000007FEFEDB0000-0x000007FEFEDB7FFF Image 00000000032768 C:\WINDOWS\SYSTEM32\NSI.DLL
0x000007FEFD960000-0x000007FEFDA3AFFF Image 00000000897024 C:\WINDOWS\SYSTEM32\ADVAPI32.DLL
0x000007FEFF220000-0x000007FEFF23EFFF Image 00000000126976 C:\WINDOWS\SYSTEM32\SECHOST.DLL
0x000007FEF9830000-0x000007FEF986AFFF Image 00000000241664 C:\WINDOWS\SYSTEM32\WINMM.DLL
0x0000000000820000-0x0000000000B0FFFF Image 00000003080192 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORACOMMON11.DLL
0x0000000000450000-0x000000000048DFFF Image 00000000253952 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORASNLS11.DLL
0x0000000000B10000-0x0000000001B39FFF Image 00000016949248 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAGENERIC11.DLL
0x0000000001B40000-0x00000000020FAFFF Image 00000006008832 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAXML11.DLL
0x0000000074A20000-0x0000000074B28FFF Image 00000001085440 C:\WINDOWS\WINSXS\AMD64_MICROSOFT.VC80.CRT_1FC8B3B9A1E18E3B_8.0.50727.4940_NONE_88DF89932FAF0BF6\MSVCP80.DLL
0x0000000002110000-0x0000000002568FFF Image 00000004558848 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAN11.DLL
0x0000000002580000-0x00000000025EEFFF Image 00000000454656 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANL11.DLL
0x0000000002600000-0x0000000002634FFF Image 00000000217088 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANTCP11.DLL
0x0000000002650000-0x000000000269AFFF Image 00000000307200 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANLDAP11.DLL
0x00000000026B0000-0x0000000002833FFF Image 00000001589248 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANNZSBB11.DLL
0x000007FEF9AE0000-0x000007FEF9AE8FFF Image 00000000036864 C:\WINDOWS\SYSTEM32\WSOCK32.DLL
0x0000000002850000-0x0000000002A41FFF Image 00000002039808 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORALDAPCLNT11.DLL
0x0000000002A60000-0x0000000002A83FFF Image 00000000147456 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANCRYPT11.DLL
0x000007FEFAB60000-0x000007FEFAB86FFF Image 00000000159744 C:\WINDOWS\SYSTEM32\IPHLPAPI.DLL
0x000007FEFAB30000-0x000007FEFAB3AFFF Image 00000000045056 C:\WINDOWS\SYSTEM32\WINNSI.DLL
0x0000000002AA0000-0x0000000002C8FFFF Image 00000002031616 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAZT11.DLL
0x000007FEFF2E0000-0x000007FEFF3B6FFF Image 00000000880640 C:\WINDOWS\SYSTEM32\OLEAUT32.DLL
0x0000000002CA0000-0x0000000002CFAFFF Image 00000000372736 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANRO11.DLL
0x0000000002D10000-0x0000000002D19FFF Image 00000000040960 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANHOST11.DLL
0x0000000002D30000-0x0000000002D36FFF Image 00000000028672 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANCDS11.DLL
0x0000000002D50000-0x0000000002D60FFF Image 00000000069632 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANTNS11.DLL
0x0000000002D80000-0x0000000002E32FFF Image 00000000733184 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAZTKG11.DLL
0x000007FEFCEE0000-0x000007FEFCEEAFFF Image 00000000045056 C:\WINDOWS\SYSTEM32\SECUR32.DLL
0x000007FEFD170000-0x000007FEFD194FFF Image 00000000151552 C:\WINDOWS\SYSTEM32\SSPICLI.DLL
0x0000000002E50000-0x000000000339EFFF Image 00000005566464 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAPLS11.DLL
0x00000000033B0000-0x00000000033BEFFF Image 00000000061440 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORASLAX11.DLL
0x00000000033D0000-0x00000000033D6FFF Image 00000000028672 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAVSN11.DLL
0x00000000033F0000-0x00000000037E5FFF Image 00000004153344 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAPLP11.DLL
0x0000000003800000-0x0000000003B0FFFF Image 00000003211264 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAHASGEN11.DLL
0x000007FEFA790000-0x000007FEFA7A5FFF Image 00000000090112 C:\WINDOWS\SYSTEM32\NETAPI32.DLL
0x000007FEFC790000-0x000007FEFC79BFFF Image 00000000049152 C:\WINDOWS\SYSTEM32\NETUTILS.DLL
0x000007FEFCE40000-0x000007FEFCE62FFF Image 00000000143360 C:\WINDOWS\SYSTEM32\SRVCLI.DLL
0x000007FEFA690000-0x000007FEFA6A4FFF Image 00000000086016 C:\WINDOWS\SYSTEM32\WKSCLI.DLL
0x000007FEFA040000-0x000007FEFA053FFF Image 00000000081920 C:\WINDOWS\SYSTEM32\SAMCLI.DLL
0x000007FEFC950000-0x000007FEFC97FFFF Image 00000000196608 C:\WINDOWS\SYSTEM32\LOGONCLI.DLL
0x0000000003B20000-0x0000000003BF1FFF Image 00000000860160 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAOCR11.DLL
0x0000000003C10000-0x0000000003CBEFFF Image 00000000716800 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAOCRB11.DLL
0x0000000003CD0000-0x0000000003D41FFF Image 00000000466944 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAASMCLNT11.DLL
0x0000000003D60000-0x0000000003DB4FFF Image 00000000348160 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORACELL11.DLL
0x0000000003DD0000-0x0000000003DE0FFF Image 00000000069632 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAOCRUTL11.DLL
0x000007FEFD770000-0x000007FEFD788FFF Image 00000000102400 C:\WINDOWS\SYSTEM32\IMAGEHLP.DLL
0x000007FEFE020000-0x000007FEFEDA7FFF Image 00000014188544 C:\WINDOWS\SYSTEM32\SHELL32.DLL
0x000007FEFDAC0000-0x000007FEFDB30FFF Image 00000000462848 C:\WINDOWS\SYSTEM32\SHLWAPI.DLL
0x0000000003E00000-0x0000000003E5DFFF Image 00000000385024 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORASQL11.DLL
0x0000000003E70000-0x0000000003F20FFF Image 00000000724992 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\OCI.DLL
0x0000000010000000-0x0000000010319FFF Image 00000003252224 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\LIBMMD.DLL
0x0000000003F40000-0x0000000003F6AFFF Image 00000000176128 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANSGR11.DLL
0x0000000003F80000-0x0000000003FA9FFF Image 00000000172032 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORACLSRA11.DLL
0x0000000003FC0000-0x0000000003FE9FFF Image 00000000172032 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORADBCFG11.DLL
0x0000000004000000-0x0000000004037FFF Image 00000000229376 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAWWG.DLL
0x000007FEFDC80000-0x000007FEFDCADFFF Image 00000000188416 C:\WINDOWS\SYSTEM32\IMM32.DLL
0x000007FEFDF10000-0x000007FEFE018FFF Image 00000001085440 C:\WINDOWS\SYSTEM32\MSCTF.DLL
0x000007FEFB990000-0x000007FEFBAB4FFF Image 00000001200128 C:\WINDOWS\SYSTEM32\DBGHELP.DLL
0x0000000005B20000-0x0000000005B3EFFF Image 00000000126976 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORAIMR11.DLL
0x000007FEFD1A0000-0x000007FEFD1F6FFF Image 00000000356352 C:\WINDOWS\SYSTEM32\APPHELP.DLL
0x000007FEFCB00000-0x000007FEFCB54FFF Image 00000000348160 C:\WINDOWS\SYSTEM32\MSWSOCK.DLL
0x000007FEFCAF0000-0x000007FEFCAF6FFF Image 00000000028672 C:\WINDOWS\SYSTEM32\WSHIP6.DLL
0x0000000005FC0000-0x0000000005FDEFFF Image 00000000126976 E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\BIN\ORANBEQ11.DLL
0x0000000074950000-0x0000000074952FFF Image 00000000012288 C:\WINDOWS\SYSTEM32\SECURITY.DLL
0x000007FEFBBA0000-0x000007FEFBBABFFF Image 00000000049152 C:\WINDOWS\SYSTEM32\DSROLE.DLL
0x000007FEF8F40000-0x000007FEF8F85FFF Image 00000000286720 C:\WINDOWS\SYSTEM32\ACTIVEDS.DLL
0x000007FEF8ED0000-0x000007FEF8F0CFFF Image 00000000249856 C:\WINDOWS\SYSTEM32\ADSLDPC.DLL
0x000007FEFEE60000-0x000007FEFEEB1FFF Image 00000000335872 C:\WINDOWS\SYSTEM32\WLDAP32.DLL
0x000007FEFBC00000-0x000007FEFBC18FFF Image 00000000102400 C:\WINDOWS\SYSTEM32\ATL.DLL
0x000007FEFC750000-0x000007FEFC759FFF Image 00000000040960 C:\WINDOWS\SYSTEM32\CREDSSP.DLL
0x000007FEFCB80000-0x000007FEFCC37FFF Image 00000000753664 C:\WINDOWS\SYSTEM32\KERBEROS.DLL
0x000007FEFCE20000-0x000007FEFCE33FFF Image 00000000081920 C:\WINDOWS\SYSTEM32\CRYPTDLL.DLL
0x000007FEFD370000-0x000007FEFD37EFFF Image 00000000061440 C:\WINDOWS\SYSTEM32\MSASN1.DLL
0x000007FEF8C30000-0x000007FEF8C3EFFF Image 00000000061440 C:\WINDOWS\SYSTEM32\CSCAPI.DLL
0x000007FEFCA90000-0x000007FEFCAE1FFF Image 00000000335872 C:\WINDOWS\SYSTEM32\MSV1_0.DLL
0x000007FEF9ED0000-0x000007FEF9EECFFF Image 00000000118784 C:\WINDOWS\SYSTEM32\SAMLIB.DLL
0x000007FEFC980000-0x000007FEFC9DAFFF Image 00000000372736 C:\WINDOWS\SYSTEM32\DNSAPI.DLL
0x000007FEFBC60000-0x000007FEFBC74FFF Image 00000000086016 C:\WINDOWS\SYSTEM32\NLAAPI.DLL
0x000007FEF9BB0000-0x000007FEF9BC4FFF Image 00000000086016 C:\WINDOWS\SYSTEM32\NAPINSP.DLL
0x000007FEF9D00000-0x000007FEF9D0AFFF Image 00000000045056 C:\WINDOWS\SYSTEM32\WINRNR.DLL
0x000007FEFC4E0000-0x000007FEFC4E6FFF Image 00000000028672 C:\WINDOWS\SYSTEM32\WSHTCPIP.DLL
0x000007FEFA440000-0x000007FEFA447FFF Image 00000000032768 C:\WINDOWS\SYSTEM32\RASADHLP.DLL
0x000007FEFAA30000-0x000007FEFAA82FFF Image 00000000339968 C:\WINDOWS\SYSTEM32\FWPUCLNT.DLL
0x000007FEFD200000-0x000007FEFD20EFFF Image 00000000061440 C:\WINDOWS\SYSTEM32\CRYPTBASE.DLL
------------------- End of memory map --------------------
------------------- SGA Memory Regions -------------------
Address 0x000000000BBF0000 Size 2265088
Address 0x0000000181000000 Size 1224736768
Address 0x000000000BE20000 Size 6635520
Address 0x000000000B640000 Size 8192
Address 0x000000000C480000 Size 24645632
------------------- end of SGA Memory Regions ------------
------------------- Other Addresses of interest ----------
An address on the stack: 0x00000000840ED3BC
First heap block address: 0x000000000EEF0000
------------------- end Other Addresses of interest -------
==============================
Memory Utilization of Subpool 1
================================
Allocation Name Size
___________________________ ____________
"free memory " 134829368
"miscellaneous " 0
"Undo Meta Data " 680
"vem_user_actlog1 " 664
"SWEEPERR " 944
"File Space Usage " 11344
"trace_knlasg " 504
"dsktab_kfgsg " 55080
"Wait event pointers " 384
"file state object " 8563056
"vips_package_size " 664
"SEQ S.O. " 180032
"RULST " 61032
"ENQUEUE STATS " 21600
"dgtab_kfmdsg " 24
"sql area " 0
"UNDO STAT INFO " 59904
"FAST SPACEUSAGE " 312328
"event classes " 144
"EM_TARGET_INFO " 1224
"txncallback " 180928
"write state object " 144
"dbkea msgq " 32
"VIRTUAL CIRCUITS " 2601152
"transaction " 264
"branch " 24
"vinc_meter_info " 1696
"ufgtab_kfmdsg " 24
"vproblem_bucket " 848
"dlo fib struct " 12832
"vnot_exist_incident " 3200
"row cache " 7575296
"KCB where statistics arra" 27960
"KCB buffer wait statistic" 3200
"KCB tablespace encryption" 912
"invalid low rba queue " 2048
"KGSKI scheduler heap 1 de" 232
"dbkea msg body " 25600
"dbgefgHtInit-2 " 8
"temporary tabl " 26504
"resumable " 24
"dbgefgHtInit-1 " 512
"KXFR Psuedo Hash Array fo" 3072
"KSFD Cache Hints for IO R" 72
"KQF runtime defined table" 1488
"KWQDL SGA Dtc gen cleanup" 48
"KTCN: Row Change Segmente" 24
"KTCN: Obj Invalidation Se" 24
"KTCN: Hash Table Segmente" 24
"kkslLoadParentOnLock:lite" 464
"KTCN: query inv Segmented" 24
"bt_qentry " 28632
"kolbsgi: KOLB's SGA initi" 8
"kmgsb circular statistics" 162304
"kglsim size of pinned mem" 22848
"kewr MMON Remote Flush Re" 30720
"kzctxgjsi ksuseclid memor" 6720
"kea advisor definition ca" 480
"ksb ci process list (each" 296
"ksunfy: is parent statist" 7800
"ksunfy: system-global sta" 5200
"ksunfy : array of SSO fre" 8
"ksunfy : array of session" 6208
"ksuloi: long op free list" 128
"ksuloi: child latches for" 1280
"ksim cached group entry s" 128
"ksim cached group entry l" 5120
"ksgm sga instance configu" 8584
"ksb rolling migration sta" 96
"ksbtnfy: infrequent actio" 2776
"kso: sched delay history " 28896
"ksir PrivOp State Object " 24
"ksfd shared pool recovery" 24
"ksfd: consumer group i/o " 13824
"dictionary cache " 0
"call " 24
"ksfd: file i/o stats poin" 3464
"ktgCircBuf:MinActScn Trc " 40032
"KTCN global clauses ht " 128
"PLDIA " 272704
"PLMCD " 4400960
"ktfa dynamic SGA allocati" 632
"kqf runtime defined table" 66872
"kpummst global in the SGA" 3160
"DDE_USER_ACTION " 1128
"alert_ext " 3480
"KEWS statistic metadata " 16320
"v_incfcount " 664
"kelr other metrics table " 48
"vshowcatview " 848
"v_ipsprbcnt " 664
"dbktb: trace pool " 44000
"vproblem_int " 2448
"kwqmncal: allocate buffer" 3984
"v_inccount " 664
"fencing reid " 17952
"threshold ale " 4032
"groups_kfgbsg " 11264
"execution ID memory " 272
"ktsj_init_sga task stat " 24
"KSRPC I/O Stat array ptr " 16
"dbgefgHtAddSK-1 " 163176
"ksdhng: els blkrs cache " 558720
"PRTDS " 0
"PRTMV " 43928
"ksfv subheap descriptor " 184
"ksacm service obj array " 768
"ksuxds ksuseecx memory " 0
"KYWM RPLY CROSS INSTANCE " 53248
"DISPATCHERS INFO " 24
"hash bucket array allocat" 49152
"ksuxds ksuseclid memory " 0
"dispatcher rate " 1312
"SQLA " 47656432
"SQLP " 13507168
"SQLK " 97152
"work area tab " 149872
"kglsim main lru count " 107520
"kglsim free heap list " 408
"kebm run-once actions " 64
"plwpil:wa " 0
"grptab_kfgsg " 24
"AW SGA " 40
"dbktb: trace buffer " 4276224
"v_swperrcount " 664
"ksunfy : SSO free list " 4730496
"kspd run-time context " 24
"ksdhng: cache history " 160
"DFW_CONFIG_CAPTURE " 752
"enqueue resources " 24
"processes " 4000
"kzekm heap descriptor " 304
"kxfpSO qref freelists " 368
"kglsim hash table bkts " 2097152
"kebm slave descriptors " 7200
"qksbgsg " 104
"IPS_PACKAGE_UNPACK_HISTOR" 1040
"trace buf hdr xtend " 624
"KCB Table Scan Bitmap " 256
"pubentry " 128
"knlu_init_btree:init " 96
"dskm rac entity id " 96
"DDE_USER_ACTION_DEF " 1320
"keswxNotify:tabPlans " 8192
"EM_USER_ACTIVITY " 1224
"kglsim recovery area " 3168
"KSQ event description " 4336
"KTCN global operators " 32
"KESTB existence bitvec " 131072
"KFD extent enqueue obj " 42792
"ksdhng: el wtr cache " 68288
"ksb cic process list " 896
"kso req alloc heapds " 280
"ksdhng: blkers cache " 12416
"ksdhng: fblkrs cache " 37248
"FileOpenBlock " 15936824
"qmtb_init_data " 736
"sort segment handle " 9016
"LISTEN ADDRESS TABLE " 2048
"LISTEN ADDRESS ENTRY " 96
"vips_pkg_file " 1600
"alert threshol " 4056
"PLS SGA hp " 46240
"Security Class heap " 136
"lock state hash table " 647680
"SERVICE NAME ENTRY " 48
"log_checkpoint_timeout " 12360
"Role related heap " 160
"block_sizes_array " 48
"PQ/BizCard " 1536
"standby event stats " 1216
"PX subheap " 614376
"latch wait-event table " 2208
"vhm_run " 2072
"State object pools " 4576
"subbtree_kwqspqctx " 48
"SHARED SERVERS INFO " 24
"locator state object " 120144
"Role graph heap " 160
"post stats " 1544
"post agent " 0
"plwsppwp:wa " 0
"memory transfer history " 19208
"channel sga anchor " 384
"segmented arrays " 10696
"Checkpoint queue " 821248
"sim segment hits " 5120
"sim lru segments " 5120
"sim state object " 96
"pesom.c:Global " 16640
"pesom.c:Object " 4056
"statement queuing " 24
"ASM KFFD SO " 2624
"ASH buffers " 8388608
"latch recovery alignment " 72
"v_actinc " 752
"paralltp txn r " 20584
"message pool freequeue " 597904
"ADR_CONTROL " 1504
"vshowincb " 752
"vproblem2 " 2632
"PMON blockers " 3200
"procs: ksunfy " 1068000
"sga listelement " 2048
"prirec_kfmdsg " 24
"SYSTEM PARAMETERS " 279024
"Online Datafile Move sess" 24
"sched job queue " 5728
"vproblem " 2728
"agent name " 0
"object queue hash buckets" 589824
"obj stats allocation chun" 1290240
"object queue hash table d" 16128
"sim cache nbufs " 640
"LGWR debug module memory " 8192
"peshm.c:latch " 160
"log_simultaneous_copies " 3200
"parameter handle " 359040
"parameter blocks " 21192
"name-service recovery " 3008
"channel handle " 24
"PARAMETER TABLE " 2048
"ASM map operations " 24
"PLS cca hp desc " 352
"bloom filter " 2752
"Auto tune undo info " 96
"cp pool array " 24
"cp cmon array " 24
"UNDO INFO " 8
"Log Archive Trace PID Lis" 40
"log file size history arr" 168
"state objects " 6120
"cp connection " 2616
"poisoned memory " 32768
"name-service request " 24
"latch nowait fails or sle" 175456
"latches for protecting fs" 960
"Nettimeout Histogram " 151280
"Label Cache Heap descrptr" 160
"bt_subentry " 272
"sched job slv " 24
"Saved job ids " 8000
"obj hash table pointers " 168
"pso tbs: ksunfy " 130000
"private strands " 3038208
"dummy " 121072
"analytic workspace " 24
"Sort Segment " 16512
"PRESENTATION TABLE " 2048
"PRESENTATION ENTRY " 32
"cp srv array " 24
"recov_kgqbtctx " 8784
"dbkea sga " 24
"Banner Storage " 2048
"qmps connections " 65280
"quiescing session " 24
"enqueue " 24
"buffer handles " 560008
"bt_subentry_nm " 24
"process group array " 69776
"property service SO " 24
"DML lock " 264
"sga node map " 16
"prmtzdini tz region " 801416
"VIEW " 1040
"Monitor Modification Hash" 512
"savepoints " 0
"RESUMABLE NAME " 72
"obj stats hash table " 320
"Managed Standby Proc Arra" 40960
"message pool context area" 22120
"OS proc request holder " 26896
"media recovery state obje" 10456
"db_files " 316288
"constraints " 24
"ASM scan context " 3520
"PX server msg stats " 2904
"PX server deq stats " 1696
"cco_subnode " 0
"cco_subname " 0
"KQR L PO " 12677408
"KRSF SGA " 40
"parameter table block " 2835576
"KQR M PO " 3826656
"KQR M SO " 645256
"KQR L SO " 1441112
"KQR S SO " 68720
"KSFV SGA " 832
"KTI-UNDO " 3028576
"KSVR SGA " 2384
"ASM rollback operations " 2624
"KYWM SGA " 296
"plugin datafile array " 3616
"plwda:PLW_STR_NEW_RVAL " 0
"plwspv:PLW_STR_NEW_VAL " 16
"KGSK sga " 8072
"BRANCH TABLE SEGMENTED AR" 105288
"ksv slave " 24
"RVWR post requested array" 8
"parameter value memory " 384
"krvxmctx " 40
"PX list of chunk lists " 1088
"JSX SGA " 3776
"block iostats dynamic seg" 24
"block media rcv state obj" 24
"multiblock re " 41024
"parameter text value " 3320
"parallel_max_servers " 21760
"bcast ack latency base ar" 72
"Background process state " 48
"resize request state obje" 491200
"kglhdusr " 56
"monitoring co " 12480
"rules engine aggregate st" 1416
"krvxdka " 840
"KGLHD " 16102544
"KGLDA " 4034128
"KGLH0 " 81226728
"KGLSG " 2636792
"KKSSP " 7927600
"KGLNA " 219264
"joxs heap " 136
"KTRSGA " 8
"KOKTD " 139200
"KKBTD " 7296
"KKTDF " 3536
"KKTSR " 7544
"KKTIN " 3680
"quiesce system context " 440
"SAGE commit cache Allocat" 176
"SAGE commit cache node Al" 10240
"SGA structure for KPON kp" 3192
"SGA structure for KPON ks" 400
"SGA structure for AWR (KE" 248
"kfnvsga " 8
"SGA - SWRF RawMet Runtime" 2672
"SGA - SWRF Metrics WCTime" 1536
"osp pool handles " 8
"SGA - SWRF Time Model Bas" 96
"pesom.c:subheap ds array " 2024
"SGA - SWRF Metrics ksuTim" 528
"SGA - SWRF DrvMet Runtime" 2752
"SGA - AWR Metric RBSM str" 3104
"SGA structure for ADR lay" 8
"ASM kfk state object " 2752
"kks sga " 40
"change tracking state cha" 2560
"change notification regis" 8192
"Prefetch history buffer " 5664
"KSK SGA " 164016
"client/application info l" 1280
"change notification obj m" 8224
"Client ID trace setting h" 536
"MS alert log " 72704
"knlsg " 144
"kokcd " 1296
"kohsg " 8
"Service-level ID trace se" 24
"knstsg " 48
"sys event stats for Other" 36480
"latch classes " 352
"system default language h" 568
"name-service entry " 3520
"parameter string values " 191080
"kdlwss " 46120
"kfdsga " 144
"library cache " 0
"kfgsga " 104
"kfgbsg " 40
"Storage for kcrr state ob" 104
"kfmdsg " 216
"spfile cleanup structure " 16760
"xssinfo " 24
"L2 file map array " 4896
"KGX " 128104
"HM_RUN " 1976
"LRMPD SGA Table " 296688
"SCHEDULING POLICY TABLE " 64
"namhsh_kfgsg " 24
"Closed Thread SCN Bitvec " 33792
"Client ID trace settings " 3904
"INCIDENT " 3008
"osp allocation " 82368
"os statistics " 13072
"policy hash table descrpt" 280
"Policy Cache Heap descrpt" 160
"plwda:PLW_STR_NEW_LEN_VEC" 0
"plwppwp:PLW_STR_NEW_LEN_V" 16
"plwgc: plwgc_garbage_clea" 0
"plwiiw: kglpql warnings " 0
"parallel kcbibr dbwr bitv" 8
"KGLS " 6079680
"KGLA " 186560
"object queue " 1281280
"per_pg_set_descriptor_arr" 114688
"pesom.c: Global_Sub_Heap " 232
"peshm.c: Global_Sub_Heap " 232
"xscalc " 24
"SGA structure for ktslgt " 47200
"Pre-Warm Initialized Seti" 1024
"Prefetch history buffer a" 64
"Prefetch client count per" 32
"SGA - SWRF Metric Eidbuf " 6400
"HM_INFO " 944
"rules engine context " 200
"sim trace buf context " 200
"heap_kfsg " 136
"slave class sga anchor " 360
"simulator hash buckets " 2048
"State object subpools " 3136
"Rec Ping Per Thread Info " 21128
"reservation state object " 3032
"Result Cache: State Objs " 2872
"xslongops " 24
"ASM generic network state" 24
"character set memory " 121328
"sim segment num bufs " 2560
"character set object " 32528
"Active Session History - " 1016
"NETWORK BUFFER " 196728
"OS file lock " 8608
"session idle latches " 1280
"set_descriptor_array " 512
"SQL Workarea Histogram " 1056
"qesmmaInitialize: ia_qesm" 264
"qesmmaInitialize: oa_qesm" 112
"qesmmaInitialize: pa_qesm" 11088
"Result Cache: Cache Mgr " 208
"array 1 for shared redo b" 384
"INCCKEY " 848
"SGA - SWRF Metric CHBs " 851184
"SGA Param Source Table " 336
"db_block_hash_buckets " 6557696
"java static objs " 34952
"KSI resource types " 2704
"temporary foreign ref " 3712
"kglsim object batch " 7078848
"ktlbk state objects " 921240
"ksuseplsrctx memory " 16
"ksu:ksusg_emptyinfo " 160
"ksws service events " 52224
"kqlpWrntoStr:string " 104
"time manager context " 40
"fixed allocation callback" 184
"file # to first dba, exte" 2416
"file iostats dynamic seg " 22912
"kqlpWrntoStr:value " 0
"ksb action records " 4152
"done Q child latches " 896
"vips_package_incident_det" 2544
"KEWS statistic name " 1112
"KEWS statistic maps " 1208
"KCB private handles " 2000
"temporary table lock " 2752
"KEWS sysstat values " 256
"KEWS sesstat values " 490432
"kebm slave message " 232
"kcbl state objects " 25600
"DDE_USER_INCIDENT_TYPE " 664
"KWQDL child latches " 2880
"KTI latch structure " 6720
"KTCNC inv hashtable " 128
"DBWR event stats array " 216
"kcrfa structures " 28536
"kebm slave reply " 680
"kgnfs htab array " 8040
"ksfm state object " 88
"event descriptor table " 208
"ksir State Object " 3008
"ksdhng: cache ctx " 208
"ksdhng: wtr cache " 6208
"IPS_PACKAGE " 1880
"kpscad: kpscscon " 272
"dbwriter coalesce bitmap " 256
"ksmd unit test 1 " 5248
"ksim client list " 168
"kscdnfyinitflags " 8
"krsv_notifier_cb " 8440
"KTU avail cache " 2016
"KTI pool states " 88
"ktg hash buckets " 5216
"ktcnqrow columns " 4328
"kglsim latch area " 2720
"kglsim hash table " 8208
"DISPATCHER CONFIG ENTRY " 88
"kgqbt_alloc_block " 1024
"Global Context Heap descr" 400
"KFK idtab_kfksga " 64808
"KSKQ SGA NODEINFO " 1261568
"KTC latch cleanup " 480
"generic process shared st" 16
"KTCNQROW colnames " 1296
"KSFQ buffer pool " 3008
"KTSL reco struct " 24576
"KTC variable sga " 24
"kspload:comment " 40
"x$ksmfs table " 32
"kscdnfyinitnext " 40
"writes stopped lock state" 24
"KTCTSNL subheaps " 1496
"X$KSVII table " 512
"X$KSVIT table " 512
"KGI Session State " 5976
"kqlpaac:value-1 " 0
"dia* process descriptor " 16
"kodosgi kopfdo " 208
"KWQDL deq log " 9216
"kkslBind_value " 112
"DBWR array of pointers to" 8
"kglsim latches " 136
"vips_package_main_int " 664
"kcrrorlerr.alo " 24
"TXN TABLE SEGMENTED ARRAY" 115528
"KFG state obj " 7008
"FileIdentificatonBlock " 24
"KFM state obj " 2880
"INC_METER_PK_IMPTS " 1040
"ksvr msg cache " 2368
"kss unit test " 3904
"ksdhng: cbufs " 32
"dirty object counts array" 2097152
"ksfv instance " 4992
"kwqmncini-tbl " 4136
"vips_package_history " 1416
"KKKI consumer " 4056
"dbwr message active flag " 8
"dbwr suspend/resume ptr a" 16
"dbwr suspend/resume array" 8
"database NCHAR language h" 568
"tablespace encryption key" 192
"dbwriter coalesce struct " 48
"dbgdInitEventGrp: eventGr" 216
"temp lob duration state o" 3632
"Temporary Tables State Ob" 239400
"KGSK scheduler " 172336
"dispatcher service names " 16
"kwrsnfy: kwrs " 8120
"messages " 120000
"jsksncb: 7 " 3840
"trace buffer header array" 208
"ts encryption key afn rev" 3208
"Transportable DB Converte" 4696
"KTU lat struct " 960
"KTC latch subh " 74048
"jsksncb: 9 " 640
"kodosgi kodos " 16
"HM_RECOMMENDATION " 2072
"KSFD SGA I/O b " 4190328
"kkj jobq wor " 4128
"jsksncb: 6 " 4176
"jsksncb: 3 " 4000
"UNDO INFO SEGMENTED ARRAY" 174864
"kkj jobq slav " 1280
"jsksncb: 4 " 4032
"KTU latches " 1320
"ksleid alloc " 144
"ksdhng: cbuf " 16384
"KSI Indexes " 256
"KSK VT POOL " 24
"kwqicaqe2kc1 " 11216
"KKJ WRK LAT " 320
"KSN WaitID " 32
"file # translation table " 25632
"KGX rowlist " 5504
"kfkhsh_kfdsg " 4104
"kfkrec_kfdsg " 24
"kfklsodtab " 49672
"kfkid hash " 4104
"enqueue_hash_chain_latche" 1280
"kzxslnfy: 0 " 304
"Wait History Segment " 807040
"IPS_FILE_COPY_LOG " 1040
"KSK OSS PLAN " 3360
"KTPR HIST TB " 2808
"IPS_CONFIGURATION " 1320
"INC_METER_CONFIG " 1224
"kupvj alloc " 1720
"IPS_PACKAGE_FILE " 848
"kupva alloc " 1000
"KUPP subheap " 1048536
"kjxgrvr SGA " 40
"INC_METER_SUMMARY " 1416
"ksbxic obj " 95544
"ksv reaper " 12960
"kglsim heap " 3919104
"kgnfs authp " 16464
"ksz parent " 27736
"event statistics per sess" 5065728
"event list to post commit" 80
"KFG SO child " 24
"KGKP randnum " 40000
==============================
Memory Utilization of Subpool 2
================================
Allocation Name Size
___________________________ ____________
"free memory " 153616520
"miscellaneous " 0
"dpslut_kfdsg " 512
"dsktab_kfgsg " 24
"hot latch diagnostics " 160
"sga blobs " 32768
"vproblem_lastinc " 2352
"vproblem_bucket1 " 848
"file state object " 144
"vips_package_file " 1320
"RULST " 21792
"RULEC " 0
"RULCI " 0
"dev2node map " 4096
"dgtab_kfmdsg " 25120
"sql area " 0
"UNDO INFO HASH " 27296
"vem_user_actlog " 664
"txncallback " 264
"write state object " 15348672
"dbkea msgs " 1200
"VIRTUAL CIRCUITS " 1088
"transaction " 2192608
"branch " 332528
"ufgtab_kfmdsg " 25120
"Wait History Array " 8
"row cache " 13960
"diag fixed SGA " 136
"diagv_incident " 3296
"KCB where statistics arra" 9320
"KCB buffer wait statistic" 152
"KCB incremental ckpt entr" 720
"invalid low rba queue " 2048
"KGSKI scheduler heap 2 de" 232
"dbkea msg body " 25600
"dbgefgHtInit-1 " 16
"resumable " 3648
"KESTB existence bitvec se" 2048
"KXFR Hash Array latches a" 2944
"dbktb: sga ctx " 48
"dbgefgHtInit-2 " 16
"KCB tablespace encryption" 760
"enqueue_hash " 76176
"relmd_ext " 1224
"branch so " 360
"KSZ sga subheap descripto" 136
"KSXP test table columns d" 1320
"KQF optimizer stats table" 1864
"KQF runtime defined table" 7440
"KWQDL SGA Ddtc gen cleanu" 48
"KTCN: Row Change Segmente" 34528
"KTCN: Obj Invalidation Se" 24608
"KTCN: Hash Table Segmente" 5216
"kkslLoadParentOnLock:lite" 0
"temporary tabl " 30888
"KTCN: query inv Segmented" 3904
"IPS_PACKAGE_INCIDENT " 944
"EM_DIAG_JOB " 1320
"kolfsgi: KOLF's SGA initi" 8
"bt_qentry " 9544
"kcbbl2df L2 disabling fla" 8
"kglsim count of pinned he" 11424
"kelr system metrics table" 296
"kzctxgjsi ksuseclid memor" 6464
"krdrsb read violation arr" 560000
"ksb ci process list (each" 576
"ksunfy: nodes of hierarch" 480
"ksunfy : array of SSO fre" 1344
"ksuloi: long op statistic" 184000
"ksuloi: long op used list" 128
"ksuloi: garbage collectio" 32
"ksim cached group entry l" 512
"ksfd: components i/o stat" 177408
"ksfd: block i/o stats poi" 3200
"KTCN global operands ht " 128
"ksir PrivOp State Object " 2368
"KTCN queries hash table " 128
"kqf runtime defined table" 24
"DFW_CONFIG_ITEM " 944
"vips_file_metadata " 944
"vips_file_copy_log " 1696
"call " 586336
"dictionary cache " 0
"qmn tasks " 4160
"vtest_exists " 1040
"kwqmncal: allocate buffer" 3984
"PLDIA " 903840
"PLMCD " 3278120
"PRTDS " 0
"PRTMV " 7496
"1:kngisga " 32104
"threshold ale " 8160
"ksuxds ksuseclid memory " 0
"execution ID memory " 128
"fencing reid " 24
"ktsj_init_sga proc desc " 176
"dbgefgHtAddSK-1 " 318872
"ksdhng: els blkrs cache " 558720
"PROBLEM " 1600
"v_ipsprbcnt1 " 664
"ksuxds ksuseecx memory " 0
"DISPATCHERS INFO " 2472
"vshowincb_i " 752
"diag descriptor " 16
"kglsim alloc latch area " 2720
"kgsk subheap descriptor " 136
"SQLA " 38462104
"SQLP " 7211368
"SQLK " 101200
"work area tab " 114376
"kkae edition name cache " 408
"vincident_file " 1040
"grplut_kfgsg " 512
"grptab_kfgsg " 3392
"dbktb: trace buffer " 4276224
"KEWS sesstat seg tbl " 8
"ksunfy : SSO free list " 4730496
"ksu: ksusg_emptypxsta " 5200
"ksdhng: cache history " 160
"enqueue resources " 501752
"kelt translation table " 360
"kglsim hash table bkts " 2097152
"KSRPC I/O Stat array " 144
"trace buf hdr xtend " 1040
"kcbl seq io throughput " 12000
"VM OSD context " 96
"KCB Table Scan Buffer " 4194816
"PICKLEERR " 1128
"incr ckpt write count arr" 168
"instance cnxn information" 37248
"trace events array " 72000
"PLS chunk " 352
"KEWS aggregation objs " 4032
"kglsim main lru size " 215040
"kglsim alloc latches " 136
"event-class map " 4560
"KSQ event description " 4336
"kglsim free obj list " 408
"KTCNQROW colname ptrs " 344
"KTCN global operators " 32
"KESTB existence bitvec " 131072
"KFD extent enqueue obj " 24
"ksdhng: el wtr cache " 68288
"ksdhng: blkers cache " 12416
"FileOpenBlock " 24
"qmtb_init_data " 992
"sort segment handle " 11576
"latchnum to latch map " 4408
"LISTEN ADDRESS ENTRY " 64
"sim kghx free lists " 8
"qesbl old rows " 1120
"procs_kfgbsg " 2200
"service names array " 16
"PQ/ResSched " 1040
"SERVICE NAME ENTRY " 48
"qtree_kwqbspse " 48
"latch hash-value table " 2208
"subbtree_kwqspqctx " 176
"SHARED SERVERS INFO " 3648
"locator state object " 72
"qtree_kwqbsgn " 48
"SERVICE NAMES TABLE " 2048
"post agent " 0
"pspool_kfsg " 80
"active checkp " 5040
"plis struct " 136
"VIEWCOL " 752
"plwspv:value-1 " 0
"plwshs:temphdl " 0
"vincident " 3296
"segmented arrays " 4200
"Checkpoint queue " 821248
"sim lru segments " 5120
"sim segment hits " 5120
"sht bkt arr allo " 11264
"pesom.c:Global " 20696
"peshm.c:Global " 4056
"statement queuing " 2880
"ASM KFFD SO " 24
"ASH buffers " 8388608
"v_nfcinc " 848
"stat hash values " 2448
"message pool freequeue " 736664
"vproblem1 " 2544
"PMON blockers " 3200
"procs: ksunfy " 1068000
"primem_kfmdsg " 1032
"SYSTEM PARAMETERS " 224400
"Online Datafile Move sess" 2368
"sched job queue " 24
"agent name " 0
"object queue hash buckets" 589824
"obj stats allocation chun" 1290240
"object queue hash table d" 16128
"PG latch table " 640
"sim cache sizes " 640
"ams_xaction " 568
"v_actprob " 664
"MTTR advisory context " 1648
"LGWR-network Server info " 34032
"logout storm management " 4000
"sys event stats " 547200
"parameter handle " 407968
"Parameter Handle " 2872
"name-service recovery " 24
"channel handle " 199936
"copy latch aux " 128
"SWRF Alerted " 4160
"PARAMETER ENTRY " 56
"ASM map operations " 2880
"LGWR post requested array" 8
"post/wait queues " 8064
"bloom filter " 24
"param hash values " 10600
"PX subheap desc " 256
"pesldT03_Instance " 33080
"PX QC msg stats " 2904
"PX QC deq stats " 1696
"cp pool array " 2584
"cp cmon array " 3608
"UNDO INFO " 8
"Log Archive Config Contex" 1096
"ArchLog Dest Array " 22784
"Parameter Table " 63576
"parallel kcbibr " 32
"name-service request " 2368
"archive_lag_target " 9624
"latch recovery structures" 3928
"latches for protecting ws" 960
"latches for protecting ls" 480
"cp connection " 24
"state objects " 4400
"plwppwp:value-1 " 0
"sched job slv " 15776
"dir_ext " 1320
"bt_subentry " 816
"object level stat table " 1008
"pso tbs: ksunfy " 130000
"private strands " 2967552
"dummy " 24
"qm_init_sga:qmdpsg " 1064
"analytic workspace " 2880
"sim trace buf " 5144
"Sort Segment " 12480
"PRESENTATION ENTRY " 40
"cp srv array " 3000
"recov_kgqbtctx " 4392
"pesom.c:latch array " 1920
"PX msg pool struct " 56
"quiescing session " 3904
"TBS STAT " 16000
"SHRINK STAT " 3000
"enqueue " 2177800
"buffer handles " 580000
"bt_subentry_nm " 40
"property service SO " 4288
"DML lock " 1225312
"broker globals " 232
"sga dev dict " 56
"ADR_INVALIDATION " 664
"obj stats hash table " 352
"max allowable # log files" 506400
"sim_knlasg " 1280
"OS proc request holder " 33360
"media recovery state obje" 24
"constraints " 250352
"db_files " 140912
"qtree_kwqspqctx " 48
"ASM scan context " 24
"cinfo_kfnsg " 4104
"cco_subnode " 0
"cco_subname " 0
"cco_pubnode " 0
"KQR M PO " 958320
"KQR L PO " 146600
"parameter table block " 2824704
"KSKQ SGA " 8632
"KTI-UNDO " 2958144
"KQR S SO " 9248
"KSIR SGA " 144
"ASM rollback operations " 24
"kccsgehtt " 360
"KQR M SO " 5120
"plwppwp:garbage handle " 48
"KGKP sga " 40
"BRANCH TABLE SEGMENTED AR" 115008
"ksv slave " 13536
"parameter value memory " 464
"RTA Boundary Info thread " 71808
"RTA read control file ind" 4224
"krvxlctx " 248
"PARALLEL T RECO LATCH " 51200
"block iostats dynamic seg" 9632
"block media rcv state obj" 2496
"parameter text value " 3768
"parallel_max_servers " 21760
"KCFIS SGA " 8
"KGSKI sga " 72
"reserved entries for all " 5760
"redo allocation latch(es)" 13920
"replication session stats" 6208
"kglhdusr " 0
"modification " 364896
"monitoring co " 24960
"buffers waiting for write" 24
"krvxdta " 1520
"KGLHD " 9382200
"KGLDA " 2580328
"KGLH0 " 55114528
"KGLSG " 2629216
"KKSSP " 9152888
"KGLNA " 149784
"joxs heap " 4056
"SAGE commit cache node Al" 12288
"KOKTD " 165040
"KKBTD " 11648
"KKTDF " 0
"KKTIN " 8656
"KKTSR " 0
"network connections " 68160
"SGA Obsolete Param Source" 24
"SGA structure for KWQDL h" 280
"SGA structure for KWQDL s" 24
"SGA struct - SWRF Metrics" 2960
"kga sga " 8
"SGA - SWRF DrvMet Runtime" 3584
"SGA - SWRF Metrics ksuTim" 1536
"SGA - SWRF Metrics WCTime" 528
"SGA - SWRF RawMet Runtime" 1952
"SGA - SWRF Time Model Bas" 16
"SQL Memory Manager Base W" 13400
"ASM kfk state object " 24
"change tracking state cha" 24
"simulator latch/bucket st" 59392
"Prefetch history buffer " 5664
"pso child tracebuf ptrs " 4000
"change tracking recovery " 262144
"KTU SGA " 24
"change notification regis" 8224
"change notification obj m" 8192
"kfmsg " 3608
"kponfy " 856
"kokcd " 2160
"Service-level trace setti" 536
"KFK SGA " 4224
"Service-level ID trace se" 4576
"pending bcast scn array " 72
"name-service table " 16144
"name-service entry " 24
"kkzias " 144
"kdlwss " 52408
"cross-platform compliance" 2232
"Array of cached attr " 400
"library cache " 0
"Space Background Task Des" 72000
"KKJ SGA " 720
"kfasga " 1048
"kfiosg " 8
"xssinfo " 5984
"buffer_pool_desc_array " 3456
"row cache child latch " 8160
"CGS system incarn array " 24864
"L2 enabled array " 16
"namhsh_kfdsg " 4104
"namrec_kfdsg " 24
"namhsh_kfgsg " 264
"Client ID trace settings " 24
"msg Q child latches " 896
"osp allocation " 71560
"plwda:PLW_STR_NEW_VAL_VEC" 0
"plwppwp: kglpql warnings " 0
"plwppwp:PLW_STR_NEW_VAL_V" 32
"plwiiw: kglpql warnings " 0
"KGLS " 4596376
"KGLA " 60344
"object queue " 1343680
"pesom.c: Pesom_Global_Hea" 232
"xscalc " 4032
"SCHEDULING POLICY VECTOR " 104
"XCT XGA " 0
"SGA - SWRF Metric Eidbuf " 271312
"process count for each CI" 448
"Processor group descripto" 256
"Prefetch history buffer a" 256
"ptr to sessions under idl" 64
"channel context areas " 82216
"Cleanup state objects " 1760
"simulator hash buckets " 1048576
"State object subpools " 3328
"resize operation history " 28808
"reservation state object " 24
"Result Cache: Memory Mgr " 200
"Result Cache: Bloom Fltr " 2048
"Result Cache: State Objs " 24
"AQ Propagation Scheduling" 16000
"xslongops " 14752
"ASM generic network state" 2560
"AWR Table Info (KEW layer" 1216
"character set memory " 54360
"sim segment num bufs " 2560
"character set object " 544896
"alter system errs: kspnfy" 116736
"L2 file global fob " 72
"Active Session History - " 512
"NETWORK BUFFER " 131152
"OS file lock " 24
"sess Q child latches " 896
"MinActScn Array " 320
"qesmmaInitialize: ta_qesm" 264
"qesmmaInitialize: " 112
"array 2 for shared redo b" 384
"SGA - SWRF Metric CHBs " 253888
"SGA structure for kelr " 2368
"listener addresses " 8
"db_block_hash_buckets " 16777216
"dbke_incid_cache_init " 40000
"temporary foreign ref " 24
"kglsim object batch " 7067256
"kglsim pin list arr " 1224
"HM_FINDING " 2632
"HM_FDG_SET " 848
"HM_MESSAGE " 1416
"downed inst bit vector " 40
"ktcnc child latches " 5888
"ktud-usd hash table " 264
"INCIDENT_FILE " 848
"ksuseplsrctx memory " 16
"ksbsa pointer array " 2776
"ksb process so list " 896
"ksws service object " 3168
"ksdhng: blkrs cache " 12416
"x$rule_set " 17608
"kqlpWrntoStr:string " 0
"file iostats dynamic seg " 24
"error message file name " 72
"kqlpWrntoStr:value " 0
"flashback_marker_cache_si" 9200
"kscdnfyglobalflags " 8
"ksacm service root " 80
"ksfd I/O slave ctx " 256
"kqlpPlsClnup:string " 0
"KEWS statistic name " 1136
"KEWS statistic maps " 1960
"kxfpSO q freelists " 368
"KCB private handles " 4000
"temporary table lock " 24
"INC_METER_INFO " 1320
"kebm slave message " 72
"fixed allocation callback" 248
"ket (AutoTask) SGA " 832
"vips_package_incident_det" 2448
"vips_package_main_problem" 752
"vips_pkg_incident_candida" 3296
"KYWM CROSS INSTANCE " 384
"KTI latch structure " 6880
"list " 4096
"kxfpsga snapshots " 4096
"kebm slave reply " 192
"KCB undo bitvec " 4096
"kgnfs ctab array " 4040
"X$KSFQP ANCHOR " 80
"ksir State Object " 24
"event descriptor table " 54720
"ksdhng: wtr cache " 6208
"kpssnfy: kpsssgct " 72
"kpscad: kpscscon " 488
"KTSL lat struct " 40960
"dbwriter coalesce buffer " 4194816
"ksmd unit test 1 " 48
"krsv_notifier_cb " 25320
"KTU avail cache " 2016
"ktg hash buckets " 8360
"iosts_kfmdsg " 392000
"kgnfs stats array " 52040
"kdlwl_sga_subheap " 232
"DISPATCHER CONFIG TABLE " 2048
"kebm test replies " 30720
"kghx free lists " 50624
"kgqbt_alloc_block " 3072
"kcbl statistics " 6144
"KFK idtab_kfksga " 24
"KTCTSNL freelists " 88
"KTU latch cleanup " 1248
"KUPP subheap desc " 232
"KSFQ buffer pool " 24
"KTC txn rsrc cnt " 88
"kspload:comment " 24
"ksv slave class " 209952
"kscdnfyinithead " 16
"kscdnfyinitprev " 40
"writes stopped lock conte" 32
"X$KSVIS table " 128
"kqlpaac:value-1 " 0
"KGI Session State " 5352
"kxfpdp pointers " 28800
"KEWS External IDs " 1536
"KSPD key heap " 4056
"kodosgi kopfdo " 208
"KQFUTTAB COLS " 472
"IPS_REMOTE_PACKAGE " 944
"KTI freelists " 88
"kkslBind_value " 0
"KWQDL ht cco " 7216
"kgnfs gid list " 104
"DDE_USER_ACTION_PARAMETER" 2080
"kcrrorlerr.alo " 24
"DDE_USER_INCIDENT_ACTION_" 664
"TXN TABLE SEGMENTED ARRAY" 126208
"vproblem_bucket_count " 944
"KFG state obj " 24
"FileIdentificatonBlock " 745512
"kzsrs filename " 536
"KFM state obj " 24
"KKJ SHRD WRQS " 240
"INC_METER_IMPT_DEF " 1040
"kwqmncini-stat " 120
"ksvr msg cache " 24
"kss unit test " 24
"ksdhng: cbufs " 32
"dirty object counts array" 2097152
"ksfv instance " 4992
"distributed_transactions-" 23048
"kwqmncini-slv " 19200
"kso req alloc " 4056
"dbwr outstanding ios per " 72
"dbwr working sets kcbdbws" 16
"dbwr suspend/resume array" 8
"database creation languag" 568
"KGNFS scontext " 524472
"tablespace encryption mas" 16
"dbwr actual working sets " 128
"KCB Table Scan " 40
"Temporary storage for RTA" 72
"temp lob duration state o" 3904
"joxs struct " 160
"Temporary Tables State Ob" 24
"KEWS fixed SGA " 5704
"ksu:ksunf_fre " 44352
"ksu:stats_fre " 9808
"jsksncb: 2 " 7832
"KGSKI schedule " 108056
"Transportable DB Converte" 24
"KTU lat struct " 800
"KTC latch subh " 56816
"KTUR HIST INFO " 4840
"jsksncb: 9 " 4336
"kodosgi kodos " 16
"KRBMROS ANCHOR " 96
"IPS_PACKAGE_HISTORY " 1320
"keswx:plan en " 32336
"HTTP fixed headers " 72
"kwqmn:tskdata " 0
"keswx:batch o " 52040
"UNDO INFO SEGMENTED ARRAY" 24
"ksv direct ms " 14144
"KTA latches " 2024
"ksdhng: cbuf " 16384
"KTC latches " 1760
"KSI Indexes " 32
"KSK VT POOL " 962960
"KTI latches " 2720
"I/O stat latches " 4960
"ksfv subheap " 16536
"where to latch num map " 10968
"KKJ WRK LAT " 160
"koh dur heap " 352
"KSN WaitID " 16
"file # translation table " 14432
"KGX rowlist " 736
"kfklsod list " 2912
"kfkid hrec " 24
"kfklsodtab " 15120
"kglsim sga " 30472
"IPS_FILE_METADATA " 944
"KTPR SUBHEAP " 168
"KTF MAPPINGS " 12288
"KTSJ subheap " 4056
"v_inc_meter_info_problem " 664
"IPS_PROGRESS_LOG " 1320
"kjxgrrr SGA " 56
"IO_SHARES_KGSKCAP " 8
"ksbxic obj " 24
"ksbxic sga " 40
"kglsim heap " 3753792
"ksv reaper " 24
"ksz parent " 18720
"event statistics per sess" 5065728
"event statistics ptr arra" 6208
"event list array to post " 72
"event list to post commit" 64
"KFG SO child " 8160
Library Cache Dump
LIBRARY CACHE STATISTICS:
namespace gets hit ratio pins hit ratio reloads invalids
-------------- --------- --------- --------- --------- ---------- ----------
SQL AREA 659346 0.694 3751230 0.836 7560 25265
TABLE/PROCEDURE 350831 0.965 1449418 0.965 14493 0
BODY 136624 0.998 323197 0.999 114 0
TRIGGER 100704 0.998 104083 0.998 21 0
INDEX 41858 0.838 44363 0.700 42 0
CLUSTER 1807 0.989 1842 0.990 0 0
KGL TESTING 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
DIRECTORY 2 0.000 4 0.000 0 0
QUEUE 1002 0.989 234077 1.000 8 0
REPLICATION OBJECT GROUP 0 0.000 0 0.000 0 0
REPLICATION PROPAGATOR 0 0.000 0 0.000 0 0
JAVA SOURCE 2 0.000 2 0.000 0 0
JAVA RESOURCE 2 0.000 2 0.000 0 0
REPLICATED TABLE OBJECT 0 0.000 0 0.000 0 0
REPLICATION INTERNAL PACKAGE 0 0.000 0 0.000 0 0
CONTEXT POLICY 0 0.000 0 0.000 0 0
PUB SUB INTERNAL INFORMATION 36907 0.999 87719 0.999 55 0
SUMMARY 0 0.000 0 0.000 0 0
DIMENSION 0 0.000 0 0.000 0 0
APP CONTEXT 20 0.950 3108 0.999 2 0
STORED OUTLINE 0 0.000 0 0.000 0 0
RULESET 47 0.660 9250 0.998 0 0
RESOURCE MANAGER 549 0.982 553 0.980 0 0
XML SCHEMA 0 0.000 0 0.000 0 0
PENDING RESOURCE MANAGER PLAN 0 0.000 0 0.000 0 0
PENDING RESOURCE MANAGER CONSUMER GROUP 0 0.000 0 0.000 0 0
SUBSCRIPTION 124 0.903 124 0.895 1 0
LOCATION 0 0.000 0 0.000 0 0
REMOTE OBJECT INFORMATION 0 0.000 0 0.000 0 0
SNAPSHOT META DATA 0 0.000 0 0.000 0 0
JAVA DATA 2 0.000 2 0.000 0 0
SECURITY PROFILE 0 0.000 0 0.000 0 0
TRANSFORMATION 0 0.000 0 0.000 0 0
REPLICATION - LOG BASED CHILD 0 0.000 0 0.000 0 0
RULE 12 0.417 12 0.417 0 0
STREAM 0 0.000 0 0.000 0 0
RULE EVALUATION CONTEXT 14 0.857 20 0.900 0 0
STREAMS APPLY PROCESS 0 0.000 0 0.000 0 0
REPLICATION SOURCE 0 0.000 0 0.000 0 0
REPLICATION DESTINATION 0 0.000 0 0.000 0 0
IFS SCHEMA 0 0.000 0 0.000 0 0
XDB CONFIG 0 0.000 0 0.000 0 0
USER AGENT 2 0.500 1 0.000 0 0
MULTI-VERSION OBJECT FOR TABLE 332 0.777 292 0.678 0 0
SCHEDULER EVENT QUEUE INFORMATION 0 0.000 0 0.000 0 0
CHANGE SET 0 0.000 0 0.000 0 0
MULTI-VERSION OBJECT FOR INDEX 270 0.711 228 0.566 0 0
SQL TUNING BASE OBJECT 0 0.000 0 0.000 0 0
HINTSET OBJECT 0 0.000 0 0.000 0 0
SCHEDULER GLOBAL ATTRIBUTE 6386 0.995 6386 0.995 1 0
SCHEDULER EARLIEST START TIME 2121 0.989 2121 0.760 486 0
TEMPORARY TABLE 81 0.753 81 0.000 61 0
TEMPORARY CLUSTER 0 0.000 0 0.000 0 0
TEMPORARY INDEX 21 0.000 21 0.000 0 0
SCRATCH PAD 0 0.000 0 0.000 0 0
SCHEDULER JOB SLAVE 0 0.000 0 0.000 0 0
MINING MODELS 0 0.000 0 0.000 0 0
SYNC STREAMS CAPTURE 0 0.000 0 0.000 0 0
LIGHT WEIGHT SESSION 0 0.000 0 0.000 0 0
DATA SECURITY DOCUMENT 0 0.000 0 0.000 0 0
SECURITY CLASS 0 0.000 0 0.000 0 0
XDB ACL 0 0.000 0 0.000 0 0
EDITION 11885 1.000 23638 1.000 0 0
SCHEDULER LIGHTWEIGHT JOB 0 0.000 0 0.000 0 0
REMOTE OBJECT LOCAL SUMMARY REFERENCE 0 0.000 0 0.000 0 0
STREAMS PROPOGATION 0 0.000 0 0.000 0 0
FUSION XS PARAMETERS 0 0.000 0 0.000 0 0
DBLINK 25453 1.000 0 0.000 0 0
XDB REPOSITORY 0 0.000 0 0.000 0 0
EV BASE TABLE 0 0.000 0 0.000 0 0
OBJECT ID 7111 0.000 0 0.000 0 0
SCHEMA 27131 0.999 0 0.000 0 0
DBINSTANCE 1 0.000 0 0.000 0 0
SQL AREA STATS 205743 0.019 205743 0.019 1 0
CONTEXT MVDATA 0 0.000 0 0.000 0 0
CONTEXT MTABLE 0 0.000 0 0.000 0 0
CONTEXT FTABLE 0 0.000 0 0.000 0 0
ACCOUNT_STATUS 22383 0.998 0 0.000 0 0
PCTABL 0 0.000 0 0.000 0 0
PCINDX 0 0.000 0 0.000 0 0
SQL AREA BUILD 207031 0.037 0 0.000 0 0
KGLNEDSYNC 0 0.000 0 0.000 0 0
CUMULATIVE 1845804 0.659 6247517 0.859 22845 25265
SGA:0x00000002BFF76030 Flags=ac3
DebugContext: DebugNameSpace=0 DebugType=0 DebugLevel=0x0 Did Not dump SGA Heap desc=000000014900A1C0. Process holds latch.
Current time: 06/13/2014 11:37:10
Last SGA heap dump at 06/13/2014 02:18:57
SGA Heap Dump Count = 0
===============================
End 4031 Diagnostic Information
===============================
DDE: Problem Key 'ORA 4031' was flood controlled (0x6) (incident: 39506)
ORA-04031: unable to allocate 3000 bytes of shared memory ("shared pool","unknown object","sga heap(2,0)","call")
Trace file E:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_5636.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 8 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:8827M/16383M, Ph+PgF:11536M/19905M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 40
Windows thread id: 5636, image: ORACLE.EXE (SHAD)
*** 2014-06-13 11:40:10.933
*** CLIENT ID:() 2014-06-13 11:40:10.933
*** SERVICE NAME:() 2014-06-13 11:40:10.933
*** MODULE NAME:() 2014-06-13 11:40:10.933
*** ACTION NAME:() 2014-06-13 11:40:10.933
opiino: Attach failed due to ORA-12537
Trace file E:\APP\ADMINISTRATOR\diag\rdbms\orcl\orcl\trace\orcl_ora_5636.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 8 - type 8664, 8 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:14141M/16383M, Ph+PgF:12091M/19905M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 19
Windows thread id: 5636, image: ORACLE.EXE (SHAD)
*** 2014-06-17 11:56:01.225
*** SESSION ID:(292.3) 2014-06-17 11:56:01.225
*** CLIENT ID:() 2014-06-17 11:56:01.225
*** SERVICE NAME:(SYS$USERS) 2014-06-17 11:56:01.225
*** MODULE NAME:(oradim.exe) 2014-06-17 11:56:01.225
*** ACTION NAME:() 2014-06-17 11:56:01.225
kwqmnich: current time:: 3: 56: 0: 0
kwqmnich: instance no 0 repartition flag 1
kwqmnich: initialized job cache structure
kwqinfy: Call kwqrNondurSubInstTsk
扫一扫
1768
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
