oracle8.1.6 performance tunning
From: jiang <jiangcl_at_yahoo.com>
Date: 4 Sep 2001 06:49:59 -0700
Message-ID: <89ab2777.0109040549.1515a947_at_posting.google.com>
Date: 4 Sep 2001 06:49:59 -0700
Message-ID: <89ab2777.0109040549.1515a947_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 Tue Sep 04 2001 - 15:49:59 CEST