目录
一、硬件层面
1.1 cpu
show parameter cpu_count
1.2 内存
show parameter sga
二、OS & DB层面
2.1 IP地址
cat /etc/hosts
2.2 OS版本
cat /etc/redhat-release
2.3 DB版本
sqlplus -version
2.4 数据库名
dba
show parameter name
或
ps -ef|grep smon
三、数据量
3.1 REDO - 主备一致
》查看主库redo
select group#, bytes/1024/1024 M, sequence#, thread# from v$log;
select group#, bytes/1024/1024/1024 G, sequence#, thread# from v$log;
select member from v$logfile;
》Standby redo log 数量
select group#, bytes/1024/1024 M from v$standby_log;
Standby redo log 组数 >= (单个 instance 日志组个数+1)*instance 个数
》desc v$log
》desc v$logfile
3.2 ARCH * 天数
》查看最近几天归档量
select trunc(completion_time) as "Data",
(sum(blocks*block_size))/1024/1024 as "MB"
from v$archived_log
group by trunc(completion_time)
order by 1;
desc v$arachived_log
first_time:sequence#成为current redo log的时间
next_time:sequence#被切换为archivelog 的开始时间
(即:该sequence#+1号成为current redo log的时间)
(即:在归档路径下,arch进程开始写入该sequence#的时间)
completion_time:sequence#在归档路径下被arch进程写入完成的时间
trunc & round
trunc:向上取整
round:四舍五入
3.3 DATA * 1.5倍
》查看主库数据量
select sum(bytes)/1024/1024/1024 from dba_data_files;