Re: Insert Performance question

On 07/27/2004 04:12:02 PM, Harvinder Singh wrote:
> Mladen,
>
> I can't use the append hint as it do table excusive lock and other
> session=20
> Are just waiting and decrease throughput.
> SQL Server database is in full mode that is doing full logging.
> Redo log files are 2G currently, what should be the recommended size?

2G redo logs are good. For multiuser insert performance test, you should, first of all, either use ASS managed tablespaces (thanks, Pete) or increase number of FREELISTS for both index and table. Being a gentleman of an old school, I'd do freelists, because I've never done benchmarks with ASS managed tablespaces. Also, to speed up index read, put it in the keep buffer pool. Also, enable either several DBWR processes or async I/O (after all, it's Winduhs that we're talking about) and direct I/O, if available. Make sure that you don't have checkpoints taking place. If you want, you can play with _bump_highwater_mark_count (32 is a nice number) and you can set _log_io_size to 524288

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------