Oracle Database Discussions

Respected Sir
Its very serious because log files in bump and udump are created frequently and they take too much space.
The problem is that i am not able to understand or solve these problem.I am pasting few log here.


BDUMP->
Dump file h:\oracle\product\10.2.0\admin\orcl2\bdump\orcl2_lgwr_1364.trc
Thu Jul 30 09:15:58 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 1
CPU : 4 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:3481M/4094M, Ph+PgF:5024M/5975M, VA:1290M/2047M
Instance name: orcl2

Redo thread mounted by this instance: 1

Oracle process number: 6

Windows thread id: 1364, image: ORACLE.EXE (LGWR)


*** 2009-07-30 09:15:58.687
*** SERVICE NAME:() 2009-07-30 09:15:58.671
*** SESSION ID:(166.1) 2009-07-30 09:15:58.671
Media recovery not enabled or manual archival only 0x10000
Maximum redo generation record size = 156160 bytes
Maximum redo generation change vector size = 150672 bytes
*** 2009-07-30 10:34:04.875
Media recovery not enabled or manual archival only 0x10000
*** 2009-07-30 10:34:28.312
Media recovery not enabled or manual archival only 0x10000
*** 2009-07-30 11:23:36.000
Media recovery not enabled or manual archival only 0x10000
*** 2009-07-30 18:06:53.718
Media recovery not enabled or manual archival only 0x10000
*** 2009-07-30 22:02:26.734
Media recovery not enabled or manual archival only 0x10000
*** 2009-07-31 04:55:48.312
Media recovery not enabled or manual archival only 0x10000

UDUMP
Dump file h:\oracle\product\10.2.0\admin\orcl2\udump\orcl2_ora_192.trc
Wed Jul 29 12:34:17 2009
ORACLE V10.2.0.1.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2 Service Pack 1
CPU : 4 - type 586, 1 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:3653M/4094M, Ph+PgF:5205M/5975M, VA:1325M/2047M
Instance name: orcl2

Redo thread mounted by this instance: 0 <none>

Oracle process number: 149

Windows thread id: 192, image: ORACLE.EXE (SHAD)


*** SERVICE NAME:() 2009-07-29 12:34:17.703
*** SESSION ID:(159.1) 2009-07-29 12:34:17.703
kccsga_update_ckpt: num_1 = 8, num_2 = 0, num_3 = 0, lbn_2 = 0, lbn_3 = 0
Successfully allocated 3 recovery slaves
Using 364 overflow buffers per recovery slave
Thread 1 checkpoint: logseq 317, block 2, scn 2070858
cache-low rba: logseq 317, block 3
on-disk rba: logseq 317, block 248, scn 2071389
start recovery at logseq 317, block 3, scn 0
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 122Kb in 0.35s => 0.34 Mb/sec
Total physical reads: 4096Kb
Longest record: 8Kb, moves: 0/201 (0%)
Longest LWN: 10Kb, moves: 0/63 (0%), moved: 0Mb
Last redo scn: 0x0000.001f9b5c (2071388)
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 92/92 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 598/690 = 0.9
----------------------------------------------
*** 2009-07-29 12:34:24.015
KCRA: start recovery claims for 92 data blocks
*** 2009-07-29 12:34:24.343
KCRA: blocks processed = 92/92, claimed = 92, eliminated = 0
*** 2009-07-29 12:34:24.390
Recovery of Online Redo Log: Thread 1 Group 1 Seq 317 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 92/92 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 690/690 = 1.0
----------------------------------------------


Thanks