Re: the problem of Oracle.exe

Hi John,

1. Did you install Oracle files on both physical disks ? Oracle needs split up reads/writes to more disks...
2. You could have better performance if Oracle did not generate online archiving hash these lines in init*.ora: # Uncommenting the line below will cause automatic archiving if archiving has # been enabled using ALTER DATABASE ARCHIVELOG. # log_archive_start = true # log_archive_dest_1 = "location=F:\oracle\oradata\POH1\archive" # log_archive_format = %%ORACLE_SID%%T%TS%S.ARC

You must do a backup Oracle files on shutting down database and restore it by Operating System !

3. Try
SQL> select * from v$sga;

NAME                         VALUE
-------------------- -------------
Fixed Size                   75804
Variable Size             85901312
Database Buffers          73728000
Redo Buffers                 77824

if Database Buffers is too high edit DB_BLOCK_BUFFERS in init*.ora file:

Database Buffers [bytes]=DB_BLOCK_BUFFERS * DB_BLOCK_SIZE (also init*.ora parameter)
73728000=9000*8192

How many clients are connected to Oracle 8i under Windows2000 ? Normal is 15.
Look at Oracle8i Designing and Tuning for Performance ...

Good luck

Robert

"IT" <john_cheng_at_impiric.com.hk> pí¹e v diskusním pøíspìvku news:aa7vlg$mfs$1_at_news.hk.linkage.net...
> Hi all,
>
> My client is using Oracle 8i under Windows2000 server SP2. The hardware
> configuration is Compaq ProLiant ML370, PIII/866, 512MB RAM, 9GB HD * 2.
>
> The problem is that after running a period of time (about 4-5 hours), the
> oracle.exe will use about 400MB of RAM. This makes the system very slow.
My
> client needs to restart the server to release the RAM.
>
> Does anyone know how to solve the problem?
>
> Thanks!
>
>
Received on Fri Apr 26 2002 - 13:34:42 CEST