Oracle Database 内存管理
SGASQL> show parameter sga_target
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
sga_target big integer 2G
SQL> show parameter sga_max_size
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
sga_max_size big integer 2G
SQL> select name,value/1024/1024 as "SIZE (MB)" from v$sga;
NAME SIZE (MB)
------------------------------ ----------
Fixed Size 2.11244965
Variable Size 320.000832
Database Buffers 1712
Redo Buffers 4.734375
SQL> col component for a30
SQL> col oper_type for a20
SQL> col oper_mode for a20
SQL> select component,oper_type,oper_mode,start_time,end_time,target_size,final_size from v$sga_resize_ops order by start_time desc;
COMPONENT OPER_TYPE OPER_MODE START_TIME END_TIME TARGET_SIZE FINAL_SIZE
------------------------------ -------------------- -------------------- ------------------- ------------------- ----------- ----------
shared pool STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 285212672285212672
large pool STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 16777216 16777216
java pool STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 16777216 16777216
streams pool STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 16777216 16777216
DEFAULT buffer cache INITIALIZING 2018-07-04 10:37:10 2018-07-04 10:37:101795162112 1795162112
ASM Buffer Cache STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 0 0
RECYCLE buffer cache STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 0 0
DEFAULT 2K buffer cache STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 0 0
DEFAULT 4K buffer cache STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 0 0
DEFAULT 8K buffer cache STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 0 0
DEFAULT 16K buffer cache STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 0 0
COMPONENT OPER_TYPE OPER_MODE START_TIME END_TIME TARGET_SIZE FINAL_SIZE
------------------------------ -------------------- -------------------- ------------------- ------------------- ----------- ----------
DEFAULT 32K buffer cache STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 0 0
KEEP buffer cache STATIC 2018-07-04 10:37:10 2018-07-04 10:37:10 0 0
DEFAULT buffer cache STATIC 2018-07-04 10:37:10 2018-07-04 10:37:101795162112 1795162112
页:
[1]