Re: Insert performance Tuning

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 8 Jun 2004 13:07:26 +1000
Message-ID: <40c52d59$0$13783$afc38c87@news.optusnet.com.au>

"Fusheng Wang" <wangfsh_at_cs.ucla.edu> wrote in message news:ca3799$9jp$1_at_daisy.noc.ucla.edu...
> HI,
>
> I have a database with intensive updates, but the updates tend to be slow.
>
> Any suggestions on database tuning on better insertion performance?
>
> Thanks a lot!
>
> Frank

It's a bit vague, Frank! No O/S, no Oracle version, no hardware specs, no configuration information... no-one can offer anything meaningful in the absence of such information.

Actually, that's not quite true: the best advice I think you can be given is to learn (if you don't already know) how to take a Statspack report, and then upload that to www.oraperf.com, which will come up with a stack of sensible tuning suggestions in a matter of a few seconds, for free.

Regards
HJR Received on Mon Jun 07 2004 - 22:07:26 CDT