Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help me tuning this wait event:log file sync

Re: Help me tuning this wait event:log file sync

From: zhuchao <chao_ping_at_163.com>
Date: 15 Jul 2002 19:51:57 -0700
Message-ID: <d8e45edf.0207151851.5d6d2b06@posting.google.com>


"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<agm1g5$hsj$1_at_lust.ihug.co.nz>...
> How big are your redo logs and how big is your log buffer?
>
> Regards
> HJR
>

hi, Howard:
  Currently my log_buffer is 2M and redo log file is 256M, it switches every 30-60 minutes during normal busy time(9:00 am - 11:00 pm).   The application is making too frequent commits(now about 40 commits/second), it is hard for me, as the dba to tune the system. Now log file sync is 70% of total wait event. sigh.   Thanks for your suggestions. Received on Mon Jul 15 2002 - 21:51:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US