Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tune for INSERT performance?
Gregg Sporar wrote:
> I’m not new to relational databases, but I am new to administering an
> Oracle server. I’m having problems getting decent INSERT performance
> using v7.3.3 (workgroup, not enterprise) on a 200MHz Pentium Pro system
> that is running NT4.
>
>
The problem may be with your transaction logs. The default transction logs are very small and the overhead of switching between logs as they fill up can slow things down considerably.
Try making your transaction logs bigger.
Email me if you need detail on how to do this Received on Tue Dec 23 1997 - 00:00:00 CST