Hi

My development instance keeps on crashing periodically, i am adding new tablespaces and its been failing every hour or so with :

Errors in file /export/oradmin/DSSDVLP/bdump/dssdvlp_pmon_4162.trc:
ORA-00470: LGWR process terminated with error
Thu Feb 14 16:52:29 2008
PMON: terminating instance due to error 470
Instance terminated by PMON, pid = 4162
Thu Feb 14 16:54:51 2008



Here is the output of /var/log/messages

Feb 14 16:52:28 idisoradev kernel: cpu 0 hot: low 32, high 96, batch 16
Feb 14 16:52:28 idisoradev kernel: cpu 0 cold: low 0, high 32, batch 16
Feb 14 16:52:28 idisoradev kernel: cpu 1 hot: low 32, high 96, batch 16
Feb 14 16:52:28 idisoradev kernel: cpu 1 cold: low 0, high 32, batch 16
Feb 14 16:52:28 idisoradev kernel: HighMem per-cpu:
Feb 14 16:52:29 idisoradev kernel: cpu 0 hot: low 32, high 96, batch 16
Feb 14 16:52:31 idisoradev kernel: cpu 0 cold: low 0, high 32, batch 16
Feb 14 16:52:32 idisoradev kernel: cpu 1 hot: low 32, high 96, batch 16
Feb 14 16:52:32 idisoradev kernel: cpu 1 cold: low 0, high 32, batch 16
Feb 14 16:52:34 idisoradev kernel:
Feb 14 16:52:35 idisoradev kernel: Free pages: 15000kB (1600kB HighMem)
Feb 14 16:52:35 idisoradev kernel: Active:61127 inactive:1442545 dirty:136137 writeback:198311 unstable:0 free:3750 slab:44508 mapped:59619 pagetables:2118
Feb 14 16:52:37 idisoradev kernel: DMA free:12568kB min:16kB low:32kB high:48kB active:0kB inactive:0kB present:16384kB pages_scanned:10871 all_unreclaimable? yes
Feb 14 16:52:38 idisoradev kernel: protections[]: 0 0 0
Feb 14 16:52:38 idisoradev kernel: Normal free:832kB min:928kB low:1856kB high:2784kB active:5212kB inactive:653864kB present:901120kB pages_scanned:944493 all_unreclaimable? yes
Feb 14 16:52:39 idisoradev kernel: protections[]: 0 0 0
Feb 14 16:52:41 idisoradev kernel: HighMem free:1600kB min:512kB low:1024kB high:1536kB active:239296kB inactive:5116316kB present:6029312kB pages_scanned:0 all_unreclaimable? no
Feb 14 16:52:43 idisoradev kernel: protections[]: 0 0 0
Feb 14 16:52:48 idisoradev kernel: DMA: 4*4kB 3*8kB 3*16kB 4*32kB 3*64kB 1*128kB 1*256kB 1*512kB 1*1024kB 1*2048kB 2*4096kB = 12568kB
Feb 14 16:52:48 idisoradev kernel: Normal: 32*4kB 88*8kB 0*16kB 0*32kB 0*64kB 0*128kB 0*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 832kB
Feb 14 16:52:48 idisoradev kernel: HighMem: 4*4kB 4*8kB 29*16kB 10*32kB 6*64kB 1*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 1600kB
Feb 14 16:52:49 idisoradev kernel: Swap cache: add 70112, delete 67668, find 10724/12928, race 0+0
Feb 14 16:52:49 idisoradev kernel: 0 bounce buffer pages
Feb 14 16:52:49 idisoradev kernel: Free swap: 9921116kB
Feb 14 16:52:50 idisoradev kernel: 1736704 pages of RAM
Feb 14 16:52:51 idisoradev kernel: 1343436 pages of HIGHMEM
Feb 14 16:52:52 idisoradev kernel: 178948 reserved pages
Feb 14 16:52:53 idisoradev kernel: 1566187 pages shared
Feb 14 16:52:53 idisoradev kernel: 2444 pages swap cached
Feb 14 16:52:53 idisoradev kernel: Out of Memory: Killed process 4172 (oracle).