health.sql

来自「oracle dba 常用的管理脚本, 覆盖日常的系统管理.」· SQL 代码 · 共 15 行

--* File Name    : Health.sql
--* Author       : DR Timothy S Hall
--* Description  : Lots of information about the database so you can asses the general health of the system.
--* Requirements : Access to the V$ & DBA views and several other monitoring scripts.
--* Call Syntax  : @Health (username/password@service)
--* Last Modified: 15/07/2000
SPOOL Health_Checks.txt

conn &1
@db_info
@sessions
@ts_full
@max_extents

SPOOL OFF