Re: oracle8.1.6 performance tunning

From: A.Liggins <A.Liggins_at_hotmail.com>
Date: Sat, 8 Sep 2001 12:23:11 +0100
Message-ID: <9ncv6j$5uf$1@plutonium.btinternet.com>

Look at task manager to see if you are paging/swapping out and the amount of free memory.

What else is the server running? Switch the other apps off if you can.

Check the Oracle alert logs and the eventvwr.exe for other clues. Look for exessive log switches, if so increase the size of the redologs by adding large ones
and then dropping the smaller ones (full backups first etc).

Look at v$session_wait to see what the waits are on.

Liggs

"jiang" <jiangcl_at_yahoo.com> wrote in message news:89ab2777.0109040550.22da0ac0_at_posting.google.com...
> Hi,
> When I using oracle8.1.6 enterprise edition on DELL
Server(PIII800,512M,40G)
> I do the performance test,
> after about 100 thousand operation of DB(operation means
insert/delete/query),
> Oracle's memory usage is about 300M, the whole machine is very slow,
> from now on,every operation to DB is very slow.
> I do not know how to optimize my oracle server,
> By the way, I use MTS & ADO to connect to oracle DB.
>
> Thanks in advance!
>
> J.C.L
> 9/4/2001
Received on Sat Sep 08 2001 - 06:23:11 CDT