How to increase or calcul the "sql area" appropriate with the shared_poo
870361Sep 13 2011 — edited Sep 13 2011Hi,
How to increase or calcul the "sql area" appropriate with the shared_pool_size
I have the following information
Total System Global Area 9463903136 bytes
Fixed Size 742304 bytes
Variable Size 7868514304 bytes
Database Buffers 1593835520 bytes
Redo Buffers 811008 bytes
Database mounted.
Database opened.
SQL> show parameter shared_pool_size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
shared_pool_size big integer 4211081216
SQL> select * from v$sgastat;
POOL NAME BYTES
----------- --------------------------------------------- ----------
fixed_sga 742304
buffer_cache 1593835520
log_buffer 787456
shared pool errors 15384
shared pool krvxrr 253056
shared pool enqueue 443976
shared pool KGK heap 7000
shared pool KQR L PO 395272
shared pool KQR M PO 89600
shared pool sessions 608400
shared pool sql area 2292336
shared pool 1M buffer 2098176
shared pool KGLS heap 749376
shared pool processes 275200
shared pool parameters 1064
shared pool free memory 4213747000
shared pool transaction 405504
shared pool PL/SQL DIANA 495880
shared pool FileOpenBlock 1563248
shared pool PL/SQL MPCODE 172864
shared pool library cache 3585688
shared pool miscellaneous 9582688
shared pool MTTR advisory 368384
shared pool PLS non-lib hp 2088
shared pool joxs heap init 4240
shared pool sim memory hea 1517960
shared pool trigger defini 1560
shared pool trigger inform 1768
shared pool trigger source 96
shared pool Checkpoint queue 1026560
shared pool VIRTUAL CIRCUITS 460800
shared pool dictionary cache 4274432
shared pool ksm_file2sga region 370496
shared pool KSXR receive buffers 1034000
shared pool character set object 279728
shared pool db_block_hash_buckets 10753328
shared pool FileIdentificatonBlock 349824
shared pool message pool freequeue 771984
shared pool KSXR pending messages que 853952
shared pool event statistics per sess 2557800
shared pool fixed allocation callback 2152
large pool free memory 67108864
java pool free memory 83886080
Regards