Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB WR PERFORMANCE ON I/O!!!!!!
You might consider increasing the size of the redologfiles in which case
fewer log-switches will occur. Each time a log switch occurs the dbwr is
triggered to flush data to database. Also you could set or increase the
value of 'log_checkpoint_timeout' in the init.ora file.
naveen_arora_at_my-deja.com wrote in message <7mn96f$e1v$1_at_nnrp1.deja.com>...
>Hi,
>I am using Oracle 7.3.3 on unix for a real time system.
>The application mostly involves lot of updates.
>The whole table is in memory and no physical read is there.
>But I/O is hogging resources as db wr always writes after 3 seconds.
>i want to increase this interval or have some get around.
>The platform i am using is fully fault-tolerant so the
>chance of going down is extreamly low.
>If dbwr writes less frequently the I/O will be better.
>Thanks for any help.
>Naveen
>naveen_at_cdotd.ernet.in
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Jul 16 1999 - 09:39:13 CDT