Re: How handle Oracle memory on WinNT

Your db_block_buffer value is to high 285MB. Remember that the oracle block is 8K.
To rectify this you can decrease the number of db bolcks in oracle.ini. See DB_BLOCK_BUFFER parameter.
I guess it is set to 35 363.

Regards

Alex

<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.
Received on Fri Sep 15 2000 - 01:17:54 CDT