SQL>select name,description from v$bgprocess where PADDR !='00';

显示LMON,LMDn,LMSn,LCK,RBAL,ASMB进程．

SQL>show parameter spfile

NAME TYPE VALUE

--------------------------------------------------

spfile string +DGDATA/orcl/spfileorcl.ora

spfile存在于ASM磁盘组，不能直接查看．所以首先创建文件型参数文件

SQL> create pfile='/db/oracle/iniorcl1.ora' from spfile;

SQL>host cat /db/oracle/initorcl1.ora | grep sga_max_size

orcl1.sga_max_size=419430400

orcl2.sga_max_size=367001600

[@more@]

ITPub博客

管理集群环境