Re: Insert Performance question
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 27 Jul 2004 16:28:12 -0400
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
