查寻Oracle的后台进程和SGA的大小

2012-07-26

查找Oracle的后台进程和SGA的大小格式化SQL set line 120SQL col PROGRAM for a20SQL SET PAGESIZE 251

查找Oracle的后台进程和SGA的大小
格式化

SQL> set line 120SQL> col PROGRAM for a20SQL> SET PAGESIZE 25

1.查找ORACLE的后台进程

SQL> select spid,username,program,background  2  from v$process  3  where background='1';SPID         USERNAME        PROGRAM              B------------ --------------- -------------------- -652          SYSTEM          ORACLE.EXE (PMON)    12188         SYSTEM          ORACLE.EXE (PSP0)    12196         SYSTEM          ORACLE.EXE (MMAN)    12200         SYSTEM          ORACLE.EXE (DBW0)    12204         SYSTEM          ORACLE.EXE (LGWR)    12208         SYSTEM          ORACLE.EXE (CKPT)    1876          SYSTEM          ORACLE.EXE (SMON)    12184         SYSTEM          ORACLE.EXE (RECO)    11708         SYSTEM          ORACLE.EXE (CJQ0)    12180         SYSTEM          ORACLE.EXE (MMON)    12164         SYSTEM          ORACLE.EXE (MMNL)    12332         SYSTEM          ORACLE.EXE (QMNC)    12280         SYSTEM          ORACLE.EXE (q000)    1904          SYSTEM          ORACLE.EXE (q001)    1已选择14行。

2.显示SGA

SQL> show sgaTotal System Global Area  167772160 bytesFixed Size                  1247900 bytesVariable Size              67110244 bytesDatabase Buffers           96468992 bytesRedo Buffers                2945024 bytes

3.显示SGA的总和

SQL> select sum(value)/1024/1024 "Total SGA MB" from v$sga;Total SGA MB------------        160

热点排行

其他数据库

查寻Oracle的后台进程和SGA的大小