Re: REDO LOG Files Tuning (HPux 9)
Date: 1996/08/30
Message-ID: <507et3$ljr_at_transfer.stratus.com>#1/1
Increate your log buffer for batch, I would suggest make it 5 times
more if you have enough RAM. You can reduce it back to normal during
daytime.
odaxys_at_aol.com (Odaxys) wrote:
>I've a Big transaction that work during night and I'm afraid the redo log
>files
>are not optimized.
>When I execute the script page 23-9 in the administrator guide, the 'redo
>log space requests'
>seems to be very high : 5000 ...
>Here is a description of my environment :
> CHECKPOINT_PROCESS = TRUE
> LOG_CHECK_POINT = 4000
> LOG_BUFFER = 327000
> DB_BLOCK_BUFFER = 10000
>My SGA is about 30M !!! isn't it too big ?
>How to correct these parameters and others to optimize my batch ?
>How many redo log files do I need and what size for each ?
>Thanks for help
>Olivier
>(odaxys_at_aol.com)
Received on Fri Aug 30 1996 - 00:00:00 CEST