ORA-04030
swathi
Yesterday we have got this error in application console.Then i checked
database
but it was hanged.It did not allow me to open new sesion through
sysdba also to
check any parameters .
The error was like
java.sql.SQLException: ORA-04030: out of process memory when trying to
allocate
4012 bytes (callheap,bind var buf)
java.sql.SQLException: ORA-04030: out of process memory when trying to
allocate
16396 bytes (hash-join subh,QERHJ Bit vector)
As databse was hanged and could not do shutdown immediate , we have to
stop it
from Services.
Where was the problem? What should we do so thet this error does not
arise
again?
Regards
Swathi
Anand Buldeo
--
You received this message because you are subscribed to the Google Groups "Ask Oracle DBA" group.
To post to this group, send an email to ask-ora...@googlegroups.com.
To unsubscribe from this group, send email to ask-oracle-db...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/ask-oracle-dba?hl=en-GB.
--
Regards
Anand Buldeo
swathi
There is no error in alert log file.
I am copying and pasting text in ora trace file
================================
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 parameter _4031_dump_bitvec = 0
======================================
Allocation Request Summary Information
======================================
Current information setting: 00654fff
Dump Interval=300 seconds SGA Heap Dump Interval=3600 seconds
Last Dump Time=03/15/2010 11:27:19
Allocation request for: session param values
Heap: 03840400, size: 20836
******************************************************
HEAP DUMP heap name="sga heap(1,0)" desc=03840400
extent sz=0xfc4 alt=100 het=32767 rec=9 flg=-126 opc=0
parent=00000000 owner=00000000 nex=00000000 xsz=0x1
====================
Process State Object
====================
----------------------------------------
SO: 82921344, type: 2, owner: 00000000, flag: INIT/-/-/0x00
(process) Oracle pid=71, calls cur/top: 00000000/85CFA5C4, flag: (0)
-
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 0
last post received-location: No post
last process to post me: none
last post sent: 0 0 0
last post sent-location: No post
last process posted by me: none
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 82A670A0
O/S info: user: SYSTEM, term: SFMSDBSERVER, ospid: 4576
OSD pid info: Windows thread id: 4576, image: ORACLE.EXE
=========================
User Session State Object
=========================
----------------------------------------
SO: 82A91734, type: 4, owner: 82921344, flag: INIT/-/-/0x00
(session) trans: 00000000, creator: 82921344, flag: (1) USR/-
-/-/-/-/-/-
DID: 0001-0047-000000A0, short-term DID:
0000-0000-00000000
txn branch: 00000000
oct: 0, prv: 0, sql: 85DD3F60, psql: 85DD3F60, user: 0/SYS
O/S info: user: , term: , ospid: , machine:
program:
temporary object counter: 0
...No current library cache object being loaded
...No instantiation object
----- Call Stack Trace -----
calling call entry argument values in
hex
location type point (? means dubious
value)
-------------------- -------- --------------------
----------------------------
_ksm_4031_dump.110+ CALLrel _ksedst+0 0
1089
_ksmasg+356 CALLrel _ksm_4031_dump.110+ 654FFF 220A1B8
3840400
0 3002000 5164
2801FB8
_kghnospc.21+196 CALLreg 00000000 61B2C560 220A1B8
5164 5164
220A1DC 6123D774
3002000 0
2801FB8
_kghalo+992 CALLrel _kghnospc.21+0 61B2C560 3840400
5164 2801FB8
1002000
_kspcrec+203 CALLrel _kghalo+0
_ksucre+672 CALLrel _kspcrec+0
_ksucresg+69 CALLrel _ksucre+0 0
_kpolna+253 CALLrel _ksucresg+0 0 0 0
_kpolon+420 CALLrel _kpolna+0 52 6123DA5C
_opiodr+1398 CALLreg 00000000 52 1A 6123E334
_ttcpip+3024 CALLreg 00000000 52 1A 6123E334 0
_opitsk+1907 CALLrel _ttcpip+0
_opiino+1480 CALLrel _opitsk+0 0 0 61B32840
FBDFD80 37 0
_opiodr+1398 CALLreg 00000000 3C 4 6123FBD8
_opidrv+563 CALLrel _opiodr+0 3C 4 6123FBD8 0
_sou2o+25 CALLrel _opidrv+0
_opimai+266 CALLrel _sou2o+0
_OracleThreadStart@ CALLrel _opimai+0
4+961
77E64826 CALLreg 00000000
----- End of Call Stack Trace -----
===============================
Memory Utilization of Subpool 1
===============================
Allocation Name Size
_________________________ __________
"free memory " 3884636
"miscellaneous " 18590716
"DML lock " 960948
"db_handles " 1008000
"FileOpenBlock " 6129492
"table definiti " 0
"VIRTUAL CIRCUITS " 2400000
"errors " 0
"sim memory hea " 643856
"parameters " 0
"KGLS heap " 90376
"fixed allocation callback" 1308
"PLS non-lib hp " 2068
"joxs heap init " 4220
"trigger inform " 0
"KSXR pending messages que" 841036
"KGK heap " 3756
"KSXR receive buffers " 1033000
"trigger source " 0
"db_block_hash_buckets " 3901224
"1M buffer " 2098176
"KQR M PO " 478296
"dictionary cache " 2137216
"PL/SQL DIANA " 0
"trigger defini " 0
"KQR X PO " 4864
"KQR S SO " 2560
"library cache " 2678432
"PL/SQL MPCODE " 0
"sql area " 170940
"KQR S PO " 85256
"processes " 1400000
"transaction " 1754072
"Checkpoint queue " 2258432
"event statistics per sess" 17477040
"enqueue " 1565772
"sessions " 3732720
"MTTR advisory " 207548
LIBRARY CACHE STATISTICS:
namespace gets hit ratio pins hit ratio reloads
invalids
-------------- --------- --------- --------- --------- ----------
----------
CRSR 395202 0.944 1760972 0.964
17685 568
TABL/PRCD/TYPE 139165 0.945 172288 0.702
8734 0
BODY/TYBD 21 0.524 22 0.318
6 0
TRGR 3285 0.990 3285 0.990
0 0
INDX 441 0.399 410 0.354
0 0
CLST 20288 0.999 31203 0.999
0 0
OBJE 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 0 0.000 0 0.000
0 0
QUEU 1125 0.632 1125 0.632
0 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 3940 0.999 5251 0.995
22 0
SUMM 0 0.000 0 0.000
0 0
DIMN 0 0.000 0 0.000
0 0
CTX 0 0.000 0 0.000
0 0
OUTL 0 0.000 0 0.000
0 0
RULS 0 0.000 0 0.000
0 0
RMGR 0 0.000 0 0.000
0 0
IFSD 1 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 0 0.000 0 0.000
0 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
ENPR 0 0.000 0 0.000
0 0
RELC 0 0.000 0 0.000
0 0
STREAM 0 0.000 0 0.000
0 0
APPLY 0 0.000 0 0.000
0 0
APPLY SOURCE 0 0.000 0 0.000
0 0
APPLY DESTN 0 0.000 0 0.000
0 0
TEST 0 0.000 0 0.000
0 0
CUMULATIVE 563468 0.946 1974556 0.942
26447 568
Permanent space allocted for Load Locks
LATCH:0 TOTAL SPACE: 4212
FREELIST CHUNK COUNT:117 OBJECT SIZE:36
Permanent space allocted for KGL pins
LATCH:0 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:26 OBJECT SIZE:72
LATCH:1 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:78 OBJECT SIZE:72
LATCH:2 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:66 OBJECT SIZE:72
LATCH:3 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:34 OBJECT SIZE:72
LATCH:4 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:76 OBJECT SIZE:72
LATCH:5 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:82 OBJECT SIZE:72
LATCH:6 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:42 OBJECT SIZE:72
LATCH:7 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:44 OBJECT SIZE:72
LATCH:8 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:72 OBJECT SIZE:72
LATCH:9 TOTAL SPACE: 12528
FREELIST CHUNK COUNT:58 OBJECT SIZE:72
LATCH:10 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:34 OBJECT SIZE:72
LATCH:11 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:44 OBJECT SIZE:72
LATCH:12 TOTAL SPACE: 37584
FREELIST CHUNK COUNT:410 OBJECT SIZE:72
LATCH:13 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:68 OBJECT SIZE:72
LATCH:14 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:22 OBJECT SIZE:72
LATCH:15 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:46 OBJECT SIZE:72
LATCH:16 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:76 OBJECT SIZE:72
Permanent space allocted for KGL locks
LATCH:0 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:26 OBJECT SIZE:72
LATCH:1 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:78 OBJECT SIZE:72
LATCH:2 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:66 OBJECT SIZE:72
LATCH:3 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:34 OBJECT SIZE:72
LATCH:4 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:76 OBJECT SIZE:72
LATCH:5 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:82 OBJECT SIZE:72
LATCH:6 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:42 OBJECT SIZE:72
LATCH:7 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:44 OBJECT SIZE:72
LATCH:8 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:72 OBJECT SIZE:72
LATCH:9 TOTAL SPACE: 12528
FREELIST CHUNK COUNT:58 OBJECT SIZE:72
LATCH:10 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:34 OBJECT SIZE:72
LATCH:11 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:44 OBJECT SIZE:72
LATCH:12 TOTAL SPACE: 37584
FREELIST CHUNK COUNT:410 OBJECT SIZE:72
LATCH:13 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:68 OBJECT SIZE:72
LATCH:14 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:22 OBJECT SIZE:72
LATCH:15 TOTAL SPACE: 4176
FREELIST CHUNK COUNT:46 OBJECT SIZE:72
LATCH:16 TOTAL SPACE: 8352
FREELIST CHUNK COUNT:76 OBJECT SIZE:72
Permanent space allocted for KGL S handles
LATCH:0 TOTAL SPACE: 5880
FREELIST CHUNK COUNT:15 OBJECT SIZE:280
LATCH:1 TOTAL SPACE: 9240
FREELIST CHUNK COUNT:27 OBJECT SIZE:280
LATCH:2 TOTAL SPACE: 6160
FREELIST CHUNK COUNT:15 OBJECT SIZE:280
LATCH:3 TOTAL SPACE: 7840
FREELIST CHUNK COUNT:22 OBJECT SIZE:280
LATCH:4 TOTAL SPACE: 5600
FREELIST CHUNK COUNT:13 OBJECT SIZE:280
LATCH:5 TOTAL SPACE: 6160
FREELIST CHUNK COUNT:17 OBJECT SIZE:280
LATCH:6 TOTAL SPACE: 7280
FREELIST CHUNK COUNT:21 OBJECT SIZE:280
LATCH:7 TOTAL SPACE: 9520
FREELIST CHUNK COUNT:29 OBJECT SIZE:280
LATCH:8 TOTAL SPACE: 6440
FREELIST CHUNK COUNT:20 OBJECT SIZE:280
LATCH:9 TOTAL SPACE: 7560
FREELIST CHUNK COUNT:23 OBJECT SIZE:280
LATCH:10 TOTAL SPACE: 7560
FREELIST CHUNK COUNT:22 OBJECT SIZE:280
LATCH:11 TOTAL SPACE: 8400
FREELIST CHUNK COUNT:25 OBJECT SIZE:280
LATCH:12 TOTAL SPACE: 9240
FREELIST CHUNK COUNT:23 OBJECT SIZE:280
LATCH:13 TOTAL SPACE: 7280
FREELIST CHUNK COUNT:22 OBJECT SIZE:280
LATCH:14 TOTAL SPACE: 7000
FREELIST CHUNK COUNT:19 OBJECT SIZE:280
LATCH:15 TOTAL SPACE: 6440
FREELIST CHUNK COUNT:16 OBJECT SIZE:280
LATCH:16 TOTAL SPACE: 6440
FREELIST CHUNK COUNT:21 OBJECT SIZE:280
Permanent space allocted for KGL M handles
LATCH:0 TOTAL SPACE: 7616
FREELIST CHUNK COUNT:15 OBJECT SIZE:476
LATCH:1 TOTAL SPACE: 7140
FREELIST CHUNK COUNT:11 OBJECT SIZE:476
LATCH:2 TOTAL SPACE: 9996
FREELIST CHUNK COUNT:12 OBJECT SIZE:476
LATCH:3 TOTAL SPACE: 7616
FREELIST CHUNK COUNT:12 OBJECT SIZE:476
LATCH:4 TOTAL SPACE: 5712
FREELIST CHUNK COUNT:9 OBJECT SIZE:476
LATCH:5 TOTAL SPACE: 6188
FREELIST CHUNK COUNT:8 OBJECT SIZE:476
LATCH:6 TOTAL SPACE: 7616
FREELIST CHUNK COUNT:12 OBJECT SIZE:476
LATCH:7 TOTAL SPACE: 7616
FREELIST CHUNK COUNT:14 OBJECT SIZE:476
LATCH:8 TOTAL SPACE: 7140
FREELIST CHUNK COUNT:12 OBJECT SIZE:476
LATCH:9 TOTAL SPACE: 7140
FREELIST CHUNK COUNT:11 OBJECT SIZE:476
LATCH:10 TOTAL SPACE: 6664
FREELIST CHUNK COUNT:9 OBJECT SIZE:476
LATCH:11 TOTAL SPACE: 7616
FREELIST CHUNK COUNT:13 OBJECT SIZE:476
LATCH:12 TOTAL SPACE: 6664
FREELIST CHUNK COUNT:9 OBJECT SIZE:476
LATCH:13 TOTAL SPACE: 5236
FREELIST CHUNK COUNT:9 OBJECT SIZE:476
LATCH:14 TOTAL SPACE: 9044
FREELIST CHUNK COUNT:16 OBJECT SIZE:476
LATCH:15 TOTAL SPACE: 8092
FREELIST CHUNK COUNT:15 OBJECT SIZE:476
LATCH:16 TOTAL SPACE: 5236
FREELIST CHUNK COUNT:8 OBJECT SIZE:476
Permanent space allocted for KGL L handles
LATCH:0 TOTAL SPACE: 4392
FREELIST CHUNK COUNT:6 OBJECT SIZE:732
LATCH:1 TOTAL SPACE: 2928
FREELIST CHUNK COUNT:4 OBJECT SIZE:732
LATCH:2 TOTAL SPACE: 2928
FREELIST CHUNK COUNT:4 OBJECT SIZE:732
LATCH:3 TOTAL SPACE: 2928
FREELIST CHUNK COUNT:3 OBJECT SIZE:732
LATCH:4 TOTAL SPACE: 5124
FREELIST CHUNK COUNT:5 OBJECT SIZE:732
LATCH:5 TOTAL SPACE: 3660
FREELIST CHUNK COUNT:2 OBJECT SIZE:732
LATCH:6 TOTAL SPACE: 5124
FREELIST CHUNK COUNT:7 OBJECT SIZE:732
LATCH:7 TOTAL SPACE: 2928
FREELIST CHUNK COUNT:3 OBJECT SIZE:732
LATCH:8 TOTAL SPACE: 4392
FREELIST CHUNK COUNT:5 OBJECT SIZE:732
LATCH:9 TOTAL SPACE: 4392
FREELIST CHUNK COUNT:6 OBJECT SIZE:732
LATCH:10 TOTAL SPACE: 7320
FREELIST CHUNK COUNT:9 OBJECT SIZE:732
LATCH:11 TOTAL SPACE: 2928
FREELIST CHUNK COUNT:4 OBJECT SIZE:732
LATCH:12 TOTAL SPACE: 2196
FREELIST CHUNK COUNT:2 OBJECT SIZE:732
LATCH:13 TOTAL SPACE: 2196
FREELIST CHUNK COUNT:1 OBJECT SIZE:732
LATCH:14 TOTAL SPACE: 4392
FREELIST CHUNK COUNT:5 OBJECT SIZE:732
LATCH:15 TOTAL SPACE: 2196
FREELIST CHUNK COUNT:3 OBJECT SIZE:732
LATCH:16 TOTAL SPACE: 1464
FREELIST CHUNK COUNT:2 OBJECT SIZE:732
Permanent space allocted for KGL A handles
LATCH:0 TOTAL SPACE: 5740
FREELIST CHUNK COUNT:29 OBJECT SIZE:164
LATCH:1 TOTAL SPACE: 5248
FREELIST CHUNK COUNT:22 OBJECT SIZE:164
LATCH:2 TOTAL SPACE: 4920
FREELIST CHUNK COUNT:15 OBJECT SIZE:164
LATCH:3 TOTAL SPACE: 4756
FREELIST CHUNK COUNT:21 OBJECT SIZE:164
LATCH:4 TOTAL SPACE: 4756
FREELIST CHUNK COUNT:11 OBJECT SIZE:164
LATCH:5 TOTAL SPACE: 4264
FREELIST CHUNK COUNT:8 OBJECT SIZE:164
LATCH:6 TOTAL SPACE: 6068
FREELIST CHUNK COUNT:29 OBJECT SIZE:164
LATCH:7 TOTAL SPACE: 3444
FREELIST CHUNK COUNT:15 OBJECT SIZE:164
LATCH:8 TOTAL SPACE: 4428
FREELIST CHUNK COUNT:18 OBJECT SIZE:164
LATCH:9 TOTAL SPACE: 4756
FREELIST CHUNK COUNT:21 OBJECT SIZE:164
LATCH:10 TOTAL SPACE: 5412
FREELIST CHUNK COUNT:19 OBJECT SIZE:164
LATCH:11 TOTAL SPACE: 4264
FREELIST CHUNK COUNT:21 OBJECT SIZE:164
LATCH:12 TOTAL SPACE: 6068
FREELIST CHUNK COUNT:20 OBJECT SIZE:164
LATCH:13 TOTAL SPACE: 3608
FREELIST CHUNK COUNT:12 OBJECT SIZE:164
LATCH:14 TOTAL SPACE: 4920
FREELIST CHUNK COUNT:22 OBJECT SIZE:164
LATCH:15 TOTAL SPACE: 4756
FREELIST CHUNK COUNT:22 OBJECT SIZE:164
LATCH:16 TOTAL SPACE: 3444
FREELIST CHUNK COUNT:11 OBJECT SIZE:164
Permanent space allocted for KGL objects
LATCH:0 TOTAL SPACE: 5544
FREELIST CHUNK COUNT:54 OBJECT SIZE:84
LATCH:1 TOTAL SPACE: 5040
FREELIST CHUNK COUNT:47 OBJECT SIZE:84
LATCH:2 TOTAL SPACE: 4872
FREELIST CHUNK COUNT:37 OBJECT SIZE:84
LATCH:3 TOTAL SPACE: 5292
FREELIST CHUNK COUNT:49 OBJECT SIZE:84
LATCH:4 TOTAL SPACE: 4536
FREELIST CHUNK COUNT:30 OBJECT SIZE:84
LATCH:5 TOTAL SPACE: 4032
FREELIST CHUNK COUNT:28 OBJECT SIZE:84
LATCH:6 TOTAL SPACE: 5292
FREELIST CHUNK COUNT:51 OBJECT SIZE:84
LATCH:7 TOTAL SPACE: 4284
FREELIST CHUNK COUNT:39 OBJECT SIZE:84
LATCH:8 TOTAL SPACE: 3780
FREELIST CHUNK COUNT:33 OBJECT SIZE:84
LATCH:9 TOTAL SPACE: 4872
FREELIST CHUNK COUNT:46 OBJECT SIZE:84
LATCH:10 TOTAL SPACE: 5124
FREELIST CHUNK COUNT:43 OBJECT SIZE:84
LATCH:11 TOTAL SPACE: 4200
FREELIST CHUNK COUNT:40 OBJECT SIZE:84
LATCH:12 TOTAL SPACE: 4788
FREELIST CHUNK COUNT:36 OBJECT SIZE:84
LATCH:13 TOTAL SPACE: 3360
FREELIST CHUNK COUNT:30 OBJECT SIZE:84
LATCH:14 TOTAL SPACE: 4620
FREELIST CHUNK COUNT:42 OBJECT SIZE:84
LATCH:15 TOTAL SPACE: 4872
FREELIST CHUNK COUNT:47 OBJECT SIZE:84
LATCH:16 TOTAL SPACE: 3864
FREELIST CHUNK COUNT:34 OBJECT SIZE:84
Permanent space allocted for KGL handle dependents
LATCH:0 TOTAL SPACE: 4080
FREELIST CHUNK COUNT:16 OBJECT SIZE:204
LATCH:1 TOTAL SPACE: 8160
FREELIST CHUNK COUNT:36 OBJECT SIZE:204
LATCH:2 TOTAL SPACE: 4080
FREELIST CHUNK COUNT:13 OBJECT SIZE:204
LATCH:3 TOTAL SPACE: 4080
FREELIST CHUNK COUNT:15 OBJECT SIZE:204
LATCH:4 TOTAL SPACE: 4080
FREELIST CHUNK COUNT:17 OBJECT SIZE:204
LATCH:5 TOTAL SPACE: 4080
FREELIST CHUNK COUNT:16 OBJECT SIZE:204
LATCH:6 TOTAL SPACE: 4080
FREELIST CHUNK COUNT:17 OBJECT SIZE:204
LATCH:7 TOTAL SPACE: 8160
FREELIST CHUNK COUNT:38 OBJECT SIZE:204
LATCH:8 TOTAL SPACE: 8160
FREELIST CHUNK COUNT:38 OBJECT SIZE:204
LATCH:9 TOTAL SPACE: 8160
FREELIST CHUNK COUNT:38 OBJECT SIZE:204
LATCH:10 TOTAL SPACE: 8160
FREELIST CHUNK COUNT:36 OBJECT SIZE:204
LATCH:11 TOTAL SPACE: 8160
FREELIST CHUNK COUNT:37 OBJECT SIZE:204
LATCH:12 TOTAL SPACE: 8160
FREELIST CHUNK COUNT:36 OBJECT SIZE:204
LATCH:13 TOTAL SPACE: 8160
FREELIST CHUNK COUNT:37 OBJECT SIZE:204
LATCH:14 TOTAL SPACE: 8160
FREELIST CHUNK COUNT:34 OBJECT SIZE:204
LATCH:15 TOTAL SPACE: 4080
FREELIST CHUNK COUNT:15 OBJECT SIZE:204
LATCH:16 TOTAL SPACE: 4080
FREELIST CHUNK COUNT:18 OBJECT SIZE:204
Did Not dump SGA Heap desc=0220A1B8
Current time: 03/15/2010 11:27:19
Last heap dump at 03/15/2010 10:57:00
===============================
End 4031 Diagnostic Information
===============================
Dump file c:\oracle\admin\sfms\udump\sfms_ora_4576.trc
Mon Mar 22 18:19:09 2010
ORACLE V9.2.0.8.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Instance name: sfms
Redo thread mounted by this instance: 1
Oracle process number: 67
Windows thread id: 4576, image: ORACLE.EXE
*** SESSION ID:(16.3) 2010-03-22 18:19:09.203
Thread checkpoint rba:0x0084ca.00000002.0010 scn:0x0000.30c52425
On-disk rba:0x0084ca.0001dbb5.0000 scn:0x0000.30c57f9a
Use incremental checkpoint cache-low RBA
Thread 1 recovery from rba:0x0084ca.0001dabf.0000 scn:0x0000.00000000
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 123Kb in 0.28s => 0.00 Mb/sec
Longest record: 46Kb, moves: 0/125 (0%)
Change moves: 2/2 (100%), moved: 0Mb
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 6/6 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 243/6138 = 0.0
----------------------------------------------
*** 2010-03-22 18:19:10.015
KCRA: start recovery claims for 6 data blocks
*** 2010-03-22 18:19:10.031
KCRA: buffers claimed = 6/6, eliminated = 0
*** 2010-03-22 18:19:10.093
Recovery of Online Redo Log: Thread 1 Group 2 Seq 33994 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 6/6 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 245/245 = 1.0
----------------------------------------------