오라클 점검 스크립트

SET ECHO OFF SET FEEDBACK OFF CLEAR COLUMNS; ALTER SESSION SET OPTIMIZER_GOAL = RULE; set lines 100 SPOOL ora_report.out prompt PROMPT ******************************************************* PROMPT * * PROMPT * System/Instance Information * PROMPT * * PROMPT ******************************************************* PROMPT col "Host Name" format a20 select a.host_name "Host Name", a.instance_name "..

원문링크 : 오라클 점검 스크립트