最近老报4031的错,看一下v$sgastat ,有点不明白,:
shared pool library cache 420623920
shared pool sql area 345759432
shared pool miscellaneous 111920424
shared pool gcs resources 111231072
library cache 里面存放的是sql 的执行计划什么的,那sql area里面存放的又是什么?
miscellaneous 是碎片吗?
gcs resources 又是什么?
9205有这方面的bug 吗?
我1G的share pool都不够用.
dbms ver: 9205
SQL> select * from v$sgastat order by bytes desc;
POOL NAME BYTES
----------- -------------------------- ----------
buffer_cache 6073352192
shared pool library cache 420623920
shared pool sql area 345759432
shared pool miscellaneous 111920424
shared pool gcs resources 111231072
shared pool free memory 97761744
large pool free memory 83886080
shared pool gcs shadows 73898376
shared pool ges enqueues 37401640
shared pool event statistics per sess 24819480
shared pool db_block_hash_buckets 23569296
POOL NAME BYTES
----------- -------------------------- ----------
shared pool ges resources 22701272
shared pool FileOpenBlock 14960384
shared pool session param values 9912448
shared pool ges big msg buffers 8866088
shared pool KGLS heap 8173976
shared pool sessions 5962320
shared pool sim memory hea 5773056
shared pool ges resource hash table 4980736
shared pool KCL name table 4155288
shared pool enqueue 3629864
shared pool KQR M PO 3254536
POOL NAME BYTES
----------- -------------------------- ----------
shared pool KQR L PO 3237880
shared pool dictionary cache 3229952
shared pool ges process array 2641320
shared pool processes 2576000
log_buffer 2361344
shared pool db_handles 2320000
shared pool ges reserved msg buffers 2096008
shared pool transaction 2089728
shared pool ges regular msg buffers 2064248
shared pool Checkpoint queue 2053120
shared pool DML lock 1885064
POOL NAME BYTES
----------- -------------------------- ----------
shared pool KCL extra lock elements 1728000
shared pool KQR X PO 1436696
shared pool enqueue resources 1290552
shared pool PL/SQL DIANA 1209768
shared pool 1M buffer 1049600
shared pool gcs resource hash table 1048576
fixed_sga 747792
shared pool PL/SQL MPCODE 679344
shared pool replication session stats 670320
shared pool constraints 550048
shared pool channel handle 520536
POOL NAME BYTES
----------- -------------------------- ----------
shared pool Temporary Tables State Ob 517080
shared pool KCL lock context 484392
shared pool KCL bast context freelist 448000
shared pool MTTR advisory 405120
shared pool PX subheap 33336
shared pool table definiti 29792
shared pool PL/SQL PPCODE 26384
shared pool partitioning d 17624
shared pool KQR S SO 7680
shared pool KGK heap 7000
shared pool temporary tabl 5584
POOL NAME BYTES
----------- -------------------------- ----------
shared pool PL/SQL SOURCE 4856
shared pool parameters 4264
shared pool PLS non-lib hp 3408
shared pool joxs heap init 1992
shared pool fixed allocation callback 1312
shared pool trigger defini 896
shared pool trigger inform 712
shared pool trigger source 168
已选择63行。