Re: oracle8.1.6 performance tunning

any chance that this "server" is actually a desktop, and the 40 GB is on a single IDE hard drive?
just guessing.
set timed_statistics=true and look at v$system_event. I'll bet that you're just stalling on disk I/O. in 8.1.6 - you tell the oracle instance how to allocate memory - in the init.ora file.
You'll want to include memory parameter info here. select * from v$sga; is a start.

Paul

jiang wrote:
>
> 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 Wed Sep 05 2001 - 22:10:40 CDT