Oracle实例中的内存分配管理
SQL> select * from v$sgastat where rownum < 50;POOL NAME BYTES
------------ -------------------------- ----------
fixed_sga 2213976
buffer_cache 2952790016
log_buffer 34623488
shared pooldpslut_kfdsg 512
shared poolENQUEUE STATS 20952
shared pooltransaction 681560
shared poolWait History Array 8
shared poolvproblem_bucket 848
shared poolvnot_exist_incident 3200
shared poolKCB buffer wait statistic 3352
shared poolKCB tablespace encryption 1088
shared poolinvalid low rba queue 4096
shared poolbt_qentry 28512
shared poolv_ipsprbcnt 664
shared poolvproblem_int 2448
shared poolPLDIA 3704360
shared poolPRTDS 572264
shared poolDISPATCHERS INFO 2496
shared poolCCUR 9454816
shared poolSQLA 35923048
shared poolplwpil:wa 4264
shared poolkelt translation table 336
shared poolkglsim recovery area 3168
shared poolksdhng: blkers cache 7936
shared poolprocs_kfgbsg 1936
shared poolservice names array 16
shared poolSHARED SERVERS INFO 3672
shared poolASH buffers 16252928
shared poolPMON blockers 1984
shared poolsga listelement 2048
shared poolvproblem 2728
shared poolpeshm.c:latch 160
shared poolcp srv array 3024
shared poolobj stats hash table 672
shared poolManaged Standby Proc Arra 28672
shared poolKSIR SGA 144
shared poolKGKP sga 40
shared poolBRANCH TABLE SEGMENTED AR 211720
shared poolSAGE commit cache node Al 22528
shared poolosp pool handles 8
shared poolpesom.c:subheap ds array 2024
shared poolSGA - SWRF Time Model Bas 112
shared poolService-level trace setti 536
shared poolsys event stats for Other 35776
shared poolLRMPD SGA Table 268688
shared poolnamhsh_kfgsg 288
shared poolmsg Q child latches 896
SQL> select sum(bytes) from v$sgastat where pool='shared pool';
SUM(BYTES)
----------
939528904
SQL> select * from v$sgainfo;
NAME BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size 2213976 No
Redo Buffers 34623488 No
Buffer Cache Size 2952790016 Yes
Shared Pool Size 939524096 Yes
Large Pool Size 67108864 Yes
Java Pool Size 67108864 Yes
Streams Pool Size 0 Yes
Shared IO Pool Size 0 Yes
Granule Size 67108864 No
Maximum SGA Size 6747725824 No
Startup overhead in Shared Pool 134217728 No
Free SGA Memory Available 2684354560
页:
[1]