REDO LOG Files Tuning (HPux 9)

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 Thu Aug 29 1996 - 00:00:00 CEST