ITPub博客

vi  awr.sh#!/bin/sh ORACLE_SID=$1export ORACLE_SIDsource ~/.bash_profilemkdir -p /oracle/utils/statspack/$1WORKPATH=/oracle/utils/statspack/$1AWR_FORMAT=htmlNUM_DAYS=1MAX_SNAP_ID=`sqlplus -S / as sysdba

 select a.tablespace_name,a.bytes/1024/1024 "Sum MB",a.maxbytes/1024/1024 "Max MB",(a.bytes-b.bytes)/1024/1024 "used MB",b.bytes/1024/1024 "free MB",round(((a.bytes-b.bytes)/a.bytes)*100,2) "percent_used",round(((a.bytes-b.bytes)/a.maxbytes)...

vi /scripts/check/xunjian.sqlset heading offselect '一、数据库的基本情况' from dual;set heading offselect '1、数据库版本' from dual;set heading onselect * from v$version;set heading offselect '2、查看数据库基本信息' from dual;set heading onset linesize 500col host_name for a20sel...