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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: