查看实例
show parameter instance
查看redo
select group#, bytes/1024/1024/1024 as GB,status,thread# from v$log order by thread#;
查看undo
show parameter undo
@tbs
参数文件
create pfile='/tmp/20211026pfile.ora' from spfile;
more /tmp/20211026pfile.ora
预警日志
cd /opt/oracle/diag/rdbms/bpxtest/bpxtest2/trace
cat -n alert_bpxtest2.log |grep instance_number
cat -n alert_bpxtest1.log |grep instance_number