log_buffer parameter size

From: <tonteldoos_at_my-deja.com>
Date: Thu, 01 Jul 1999 00:45:11 GMT
Message-ID: <7ledmk$v10$1@nnrp1.deja.com>

Current database size of 250 GB.

Solaris 2.5/ Oracle 7.3.4 - 20 CPU (E10K) - 20 GB main memory;

We are using four 50 MB on-line red-log files.

Database are very high on-line transaction intensive.

Current setting for log_buffer = 2MB.

If I select from v$sysstat where 'redo log space request';

I get a value back of 6 450! Can anybody recommend the size of the log_buffer? Is it dangerous to increase it to 5MB for example? We got more than anouth physical memory availible!

Thanks Tontel.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 30 1999 - 19:45:11 CDT