--实例状态、参数监控
set wrap off
set linesize 1000
spool e:\qin_daily\实例状态_参数监控_script001
col instance_name for a13
col host_name for a9
col version for a9
col startup_time for a12
col status for a10
col parallel for a8
col archiver for a8
col log_switch_wait for a15
col archiver for a8
select INSTANCE_NAME,
STARTUP_TIME,
STATUS,
DATABASE_STATUS,
LOG_SWITCH_WAIT,
SHUTDOWN_PENDING,
HOST_NAME,
VERSION,
PARALLEL,
THREAD#,
ARCHIVER,
LOGINS,
INSTANCE_ROLE,
ACTIVE_STATE
from v$instance;
spool off
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12330444/viewspace-434587/ ，如需转载，请注明出处，否则将追究法律责任。
