Re: How handle Oracle memory on WinNT

I see some perfectly sensible suggestions have been made. Just remember too that the java pool size defaults to 20Mb in 8.1.5, and if you're not using java stuff right now, you can safely reduce this to 1Mb (time to edit your init.ora!). You can't, unfortunately, make it smaller than 1Mb.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



<qiangye_at_my-deja.com> wrote in message news:8ps5m6$it4$1_at_nnrp1.deja.com...


> The application runs on WinNT with Oracle 8.1.5. From the NT system

> tool "TaskManager", we can see ORACLE.EXE occupies too much memory.

>

> Just after ORACLE starts up, everything fine, and the memory ORACLE

> uses is around 60M. But after our application runs, which means about

> 30 connections happen concurrently, the memory used increases to more

> than 400 M. It's too too high, because our system only have 500 M

> system memory.

>

> I hope some ORACLE experts could tell me how reduce the occupied memory

> of ORACLE.

>

> Thanks

>

> George

>

> SQL> select * from v$sgastat;

>

> POOL        NAME                           BYTES

> ----------- -------------------------- ---------

>             fixed_sga                      65484

>             db_block_buffers           291930112

>             log_buffer                     65536

> shared pool free memory                 28291084

> shared pool miscellaneous                 632344

> shared pool PL/SQL MPCODE                 138908

> shared pool State objects                 354892

> shared pool PLS non-lib hp                  2096

> shared pool db_block_hash_buckets         701368

> shared pool KGK heap                       17556

> shared pool DML locks                     148480

> shared pool PL/SQL DIANA                  332452

> shared pool character set object          108228

> shared pool table columns                  15736

> shared pool transactions                  281600

> shared pool ktlbk state objects           136960

> shared pool enqueue_resources             167328

> shared pool long op statistics array      110000

> shared pool db_files                      426280

> shared pool fixed allocation callback        640

> shared pool trigger inform                   420

>

> POOL        NAME                           BYTES

> ----------- -------------------------- ---------

> shared pool state objects                  60760

> shared pool branches                       77040

> shared pool db_handles                    189280

> shared pool SYSTEM PARAMETERS              56748

> shared pool dictionary cache              380692

> shared pool Checkpoint queue               73764

> shared pool KGFF heap                       8508

> shared pool table definiti                  2320

> shared pool message pool freequeue        124552

> shared pool library cache               32180136

> shared pool dlo fib struct                 40980

> shared pool sql area                    35865920

> shared pool processes                     195520

> shared pool sessions                      577344

> shared pool messages                       37440

> shared pool KQLS heap                     542196

> shared pool event statistics per sess     917232

> shared pool db_block_buffers             4846496

> shared pool file # translation table       65572

> large pool  free memory                 86507520

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.