Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to increase or calcul the "sql area" appropriate with the shared_poo

870361Sep 13 2011 — edited Sep 13 2011
Hi,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2011
Added on Sep 13 2011
3 comments
322 views