#了解实例的内存结构
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> desc v$sga_dynamic_components
Name Null? Type
----------------------------------------- -------- ----------------------------
COMPONENT VARCHAR2(64)
CURRENT_SIZE NUMBER
MIN_SIZE NUMBER
MAX_SIZE NUMBER
USER_SPECIFIED_SIZE NUMBER
OPER_COUNT NUMBER
LAST_OPER_TYPE VARCHAR2(13)
LAST_OPER_MODE VARCHAR2(9)
LAST_OPER_TIME DATE
GRANULE_SIZE NUMBER
SQL> select COMPONENT, CURRENT_SIZE , MIN_SIZE,MAX_SIZE from v$sga_dynamic_components ; 输出结果为可以动态重设大小的SGA组件的当前,最小和最大容量
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
---------- ------------ ---------- --------
shared pool 176160768 167772160 176160768
large pool 4194304 4194304 4194304
java pool 20971520 20971520 25165824
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
-------------- ------------ ---------- ----------
streams pool 4194304 4194304 4194304
DEFAULT buffer cache 71303168 67108864 79691776
KEEP buffer cache 0 0 0
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
--------- -------- ------- ----------
RECYCLE buffer cache 0 0 0
DEFAULT 2K buffer cache 0 0 0
DEFAULT 4K buffer cache 0 0 0
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
---------- ---------- --------- --------
DEFAULT 8K buffer cache 0 0 0
DEFAULT 16K buffer cache 0 0 0
DEFAULT 32K buffer cache 0 0 0
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
---------- ---------- ---------- ----------
Shared IO Pool 20971520 20971520 20971520
ASM Buffer Cache 0 0 0
14 rows selected.
#确定已经为PGA分配多少内存
SQL> select name,value from v$pgastat where name in ('maixmum pga allocated','total pga allocates');
no rows selected
#了解在实例中运行的进程
SQL> select program from v$process order by program;
PROGRAM
------------------------------------------------
PSEUDO
oracle@ENMOEDU (CJQ0)
oracle@ENMOEDU (CKPT)
oracle@ENMOEDU (D000)
oracle@ENMOEDU (DBRM)
oracle@ENMOEDU (DBW0)
oracle@ENMOEDU (DIA0)
oracle@ENMOEDU (DIAG)
oracle@ENMOEDU (GEN0)
oracle@ENMOEDU (J000)
oracle@ENMOEDU (J001)
PROGRAM
------------------------------------------------
oracle@ENMOEDU (J002)
oracle@ENMOEDU (J003)
oracle@ENMOEDU (J004)
oracle@ENMOEDU (J005)
oracle@ENMOEDU (J006)
oracle@ENMOEDU (LGWR)
oracle@ENMOEDU (MMAN)
oracle@ENMOEDU (MMNL)
oracle@ENMOEDU (MMON)
oracle@ENMOEDU (P000)
oracle@ENMOEDU (P001)
PROGRAM
------------------------------------------------
oracle@ENMOEDU (PMON)
oracle@ENMOEDU (PSP0)
oracle@ENMOEDU (Q000)
oracle@ENMOEDU (Q001)
oracle@ENMOEDU (QMNC)
oracle@ENMOEDU (RECO)
oracle@ENMOEDU (S000)
oracle@ENMOEDU (SMON)
oracle@ENMOEDU (TNS V1-V3)
oracle@ENMOEDU (VKRM)
oracle@ENMOEDU (VKTM)
33 rows selected.
SQL> select program from v$session order by program;
PROGRAM
------------------------------------------------
oracle@ENMOEDU (CJQ0)
oracle@ENMOEDU (CKPT)
oracle@ENMOEDU (DBRM)
oracle@ENMOEDU (DBW0)
oracle@ENMOEDU (DIA0)
oracle@ENMOEDU (DIAG)
oracle@ENMOEDU (GEN0)
oracle@ENMOEDU (J000)
oracle@ENMOEDU (J001)
oracle@ENMOEDU (LGWR)
oracle@ENMOEDU (MMAN)
PROGRAM
------------------------------------------------
oracle@ENMOEDU (MMNL)
oracle@ENMOEDU (MMON)
oracle@ENMOEDU (PMON)
oracle@ENMOEDU (PSP0)
oracle@ENMOEDU (Q000)
oracle@ENMOEDU (Q001)
oracle@ENMOEDU (QMNC)
oracle@ENMOEDU (RECO)
oracle@ENMOEDU (SMCO)
oracle@ENMOEDU (SMON)
oracle@ENMOEDU (VKRM)
PROGRAM
------------------------------------------------
oracle@ENMOEDU (VKTM)
oracle@ENMOEDU (W000)
sqlplus@ENMOEDU (TNS V1-V3)
25 rows selected.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> desc v$sga_dynamic_components
Name Null? Type
----------------------------------------- -------- ----------------------------
COMPONENT VARCHAR2(64)
CURRENT_SIZE NUMBER
MIN_SIZE NUMBER
MAX_SIZE NUMBER
USER_SPECIFIED_SIZE NUMBER
OPER_COUNT NUMBER
LAST_OPER_TYPE VARCHAR2(13)
LAST_OPER_MODE VARCHAR2(9)
LAST_OPER_TIME DATE
GRANULE_SIZE NUMBER
SQL> select COMPONENT, CURRENT_SIZE , MIN_SIZE,MAX_SIZE from v$sga_dynamic_components ; 输出结果为可以动态重设大小的SGA组件的当前,最小和最大容量
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
---------- ------------ ---------- --------
shared pool 176160768 167772160 176160768
large pool 4194304 4194304 4194304
java pool 20971520 20971520 25165824
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
-------------- ------------ ---------- ----------
streams pool 4194304 4194304 4194304
DEFAULT buffer cache 71303168 67108864 79691776
KEEP buffer cache 0 0 0
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
--------- -------- ------- ----------
RECYCLE buffer cache 0 0 0
DEFAULT 2K buffer cache 0 0 0
DEFAULT 4K buffer cache 0 0 0
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
---------- ---------- --------- --------
DEFAULT 8K buffer cache 0 0 0
DEFAULT 16K buffer cache 0 0 0
DEFAULT 32K buffer cache 0 0 0
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
---------- ---------- ---------- ----------
Shared IO Pool 20971520 20971520 20971520
ASM Buffer Cache 0 0 0
14 rows selected.
#确定已经为PGA分配多少内存
SQL> select name,value from v$pgastat where name in ('maixmum pga allocated','total pga allocates');
no rows selected
#了解在实例中运行的进程
SQL> select program from v$process order by program;
PROGRAM
------------------------------------------------
PSEUDO
oracle@ENMOEDU (CJQ0)
oracle@ENMOEDU (CKPT)
oracle@ENMOEDU (D000)
oracle@ENMOEDU (DBRM)
oracle@ENMOEDU (DBW0)
oracle@ENMOEDU (DIA0)
oracle@ENMOEDU (DIAG)
oracle@ENMOEDU (GEN0)
oracle@ENMOEDU (J000)
oracle@ENMOEDU (J001)
PROGRAM
------------------------------------------------
oracle@ENMOEDU (J002)
oracle@ENMOEDU (J003)
oracle@ENMOEDU (J004)
oracle@ENMOEDU (J005)
oracle@ENMOEDU (J006)
oracle@ENMOEDU (LGWR)
oracle@ENMOEDU (MMAN)
oracle@ENMOEDU (MMNL)
oracle@ENMOEDU (MMON)
oracle@ENMOEDU (P000)
oracle@ENMOEDU (P001)
PROGRAM
------------------------------------------------
oracle@ENMOEDU (PMON)
oracle@ENMOEDU (PSP0)
oracle@ENMOEDU (Q000)
oracle@ENMOEDU (Q001)
oracle@ENMOEDU (QMNC)
oracle@ENMOEDU (RECO)
oracle@ENMOEDU (S000)
oracle@ENMOEDU (SMON)
oracle@ENMOEDU (TNS V1-V3)
oracle@ENMOEDU (VKRM)
oracle@ENMOEDU (VKTM)
33 rows selected.
SQL> select program from v$session order by program;
PROGRAM
------------------------------------------------
oracle@ENMOEDU (CJQ0)
oracle@ENMOEDU (CKPT)
oracle@ENMOEDU (DBRM)
oracle@ENMOEDU (DBW0)
oracle@ENMOEDU (DIA0)
oracle@ENMOEDU (DIAG)
oracle@ENMOEDU (GEN0)
oracle@ENMOEDU (J000)
oracle@ENMOEDU (J001)
oracle@ENMOEDU (LGWR)
oracle@ENMOEDU (MMAN)
PROGRAM
------------------------------------------------
oracle@ENMOEDU (MMNL)
oracle@ENMOEDU (MMON)
oracle@ENMOEDU (PMON)
oracle@ENMOEDU (PSP0)
oracle@ENMOEDU (Q000)
oracle@ENMOEDU (Q001)
oracle@ENMOEDU (QMNC)
oracle@ENMOEDU (RECO)
oracle@ENMOEDU (SMCO)
oracle@ENMOEDU (SMON)
oracle@ENMOEDU (VKRM)
PROGRAM
------------------------------------------------
oracle@ENMOEDU (VKTM)
oracle@ENMOEDU (W000)
sqlplus@ENMOEDU (TNS V1-V3)
25 rows selected.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29438041/viewspace-1141350/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29438041/viewspace-1141350/