体系结构
SGA:
$ sqlplus / as sysdba
SQL> show sga
SQL> show parameter sga_max_size 显示sga容量
SQL> select * from V$SGAINFO;
oem：浏览器中 服务器-->内存指导（https://192.168.0.1:1158/em）
shared pool:
SQL> show parameter shared_pool_size 参数
SQL> select component, current_size from V$SGA_DYNAMIC_COMPONENTS where component='shared pool';共享池详细信息
SQL> select * from v$SGAINFO;
db buffer cache:
SQL> show parameter db_block_size
SQL> show parameter db_cache_size
SQL> select * from v$SGAINFO;
SQL> select component, current_size from V$SGA_DYNAMIC_COMPONENTS where component='DEFAULT buffer cache'; 动态性能视图
redo log buffer:
SQL> show parameter log_buffer
SQL> select * from v$sgainfo;
PGA:
SQL> show parameter pga_aggregate_target
SQL> select * from V$PGASTAT where NAME='total PGA allocated';
后台进程：
SQL> select name from v$bgprocess where paddr<>'00';
SQL> ! ps -ef | grep ora_
SQL> show parameter db_writer_processes
数据文件：
$ ll /u01/app/oracle/oradata/orcl/*.dbf
SQL> select name from v$datafile;
SQL> select name from v$tempfile;
控制文件：
$ find /u01 -name 'control0[12].ctl'
SQL> select name from v$controlfile;
SQL> select TYPE, RECORD_SIZE, RECORDS_TOTAL, RECORDS_USED from v$controlfile_record_section;
重做日志：
$ ll /u01/app/oracle/oradata/orcl/*.log
SQL> select group#, member from v$logfile;
实例参数文件：
$ ll $ORACLE_HOME/dbs/spfile*.ora
$ strings $ORACLE_HOME/dbs/spfileorcl.ora 字符查看
SQL> show parameter spfile;
SQL> show parameter
密码文件：
$ ll $ORACLE_HOME/dbs/orapw*
归档日志：
SQL> select name from v$archived_log;
警告日志：
$ find /u01 -name 'alert_*.log'