怎么能够查看SGA里面的内容 比如shared pool

Question

rt

Answer 1

select * from v$sga;
select * from sys.v_$sgastat;

Answer 2

V$SGA displays summary information about the system global area (SGA).
SQL> select * from v$sga;NAME                      VALUE
-------------------- ----------
Fixed Size              1247948
Variable Size          83887412
Database Buffers       88080384
Redo Buffers            2945024V$SGASTAT displays detailed information on the system global area (SGA).
SQL> select * from v$sgastat;
POOL         NAME                            BYTES
------------ -------------------------- ----------
shared pool  ksunfy: nodes of hierarch         320
shared pool  dispatcher queue                  176
shared pool  fdhsh_kffsg                      8196
shared pool  fdrec_kffsg                        12
shared pool  work area tab                  242880
shared pool  AW SGA                             24
shared pool  kspd run-time context              12
shared pool  KSQ event description            5532
......(内容比较多 没显示完)

Answer 3

查share pool的什么，大侠的话，直接show parameter shared_pool_size就可以

Answer 4

他说比如SHARED POOL  估计SGA里的东西楼主都想看一看吧 呵呵