oracle 11gamp;12c系统巡检

--脚本用法

sh performance_check.sh

--脚本生成

vi performance_check.sh --添加如下

Ip=``
sqlplus -S "/ as sysdba" << EOF

-- |--------------------------------------------------------------------------------------|
-- | Copyright (c) 1991-2013 oracle. All rights reserved. |
-- | PURPOSE : This SQL script provides a detailed report (in HTML format) on |
-- | all database metrics including installed options,storage,|
-- | performance data,and security. |
-- | VERSION : This script was designed for Oracle Database 11g and 12c. |
-- | USAGE : |
-- | sqlplus -s <dba>/<password>@<TNS string> @performance_report_for_oracle.sql |
-- | TESTING : This script has been successfully tested on the following |
-- | platforms: |
-- | Linux : Oracle Database 11.2.0.1.0 12.1.0.1.0 |
-- | Windows server2008 sp1 : Oracle Database 10.2.0.4.0 |
-- | NOTE : As with any code,ensure to test this script in a development |
-- | environment before attempting to run it in production. |
-- +--------------------------------------------------------------------------------------+

prompt Creating database report.
prompt This script must be run as a user with SYSDBA privileges.
prompt This process can take several minutes to complete.

COLUMN version NEW_VALUE _version NOPRINT
SELECT case when substr(t.VERSION,1,2)<=11 then substr(t.VERSION,2)||‘g‘ else substr(t.VERSION,2)||‘c‘ end
version FROM v$instance t;
define reportHeader="<center><font size=+3 color=darkgreen><b>Performance Report for Database &_version<i></i>($Ip)</b></font><hr>Copyright (c) 1991-2013 oracle. All rights reserved.<p></center>"

-- +----------------------------------------------------------------------------+
-- | SCRIPT SETTINGS |
-- +----------------------------------------------------------------------------+

set termout off
set echo off
set feedback off
set heading off
set verify off
set wrap on
set trimspool on
set serveroutput on
set escape on
set pagesize 50000
set linesize 175
set long 2000000000

clear buffer computes columns breaks

define FileName=PERRORMANCE_CHECK
define versionNumber=6.0.0

-- +----------------------------------------------------------------------------+
-- | GATHER DATABASE REPORT INFORMATION |
-- +----------------------------------------------------------------------------+
COLUMN dbname NEW_VALUE _dbname NOPRINT
COLUMN spool_time NEW_VALUE _spool_time NOPRINT
SELECT name dbname FROM v$database;
SELECT TO_CHAR(SYSDATE,‘YYYYMMDD‘) spool_time FROM dual;
-- +----------------------------------------------------------------------------+
-- | GATHER DATABASE REPORT INFORMATION |
-- +----------------------------------------------------------------------------+

set heading on

set markup html on spool on preformat off entmap on -
head ‘ -
<title>Database Report</title> -
<style type="text/css"> -
body {font:9pt Arial,Helvetica,sans-serif; color:black; background:White;} -
p {font:9pt Arial,sans-serif; color:black; background:White;} -
table,tr,td {font:9pt Arial,sans-serif; color:Black; background:#C0C0C0; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} -
th {font:bold 9pt Arial,sans-serif; color:#336699; background:#cccc99; padding:0px 0px 0px 0px;} -
h1 {font:bold 12pt Arial,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:0pt; margin-bottom:0pt; padding:0px 0px 0px 0px;} -
h2 {font:bold 10pt Arial,sans-serif; color:#336699; background-color:White; margin-top:4pt; margin-bottom:0pt;} -
a {font:9pt Arial,sans-serif; color:#663300; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} -
a.link {font:9pt Arial,sans-serif; color:#663300; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} -
a.noLink {font:9pt Arial,sans-serif; color:#663300; text-decoration: none; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} -
a.noLinkBlue {font:9pt Arial,sans-serif; color:#0000ff; text-decoration: none; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} -
a.noLinkDarkBlue {font:9pt Arial,sans-serif; color:#000099; text-decoration: none; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} -
a.noLinkRed {font:9pt Arial,sans-serif; color:#ff0000; text-decoration: none; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} -
a.noLinkDarkRed {font:9pt Arial,sans-serif; color:#990000; text-decoration: none; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} -
a.noLinkGreen {font:9pt Arial,sans-serif; color:#00ff00; text-decoration: none; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} -
a.noLinkDarkGreen {font:9pt Arial,sans-serif; color:#009900; text-decoration: none; margin-top:0pt; margin-bottom:0pt; vertical-align:top;} -
</style>‘ -
body ‘BGCOLOR="#C0C0C0"‘ -
table ‘WIDTH="90%" BORDER="1"‘

spool &FileName._&_version._&_dbname._&_spool_time..html

set markup html on entmap off

（编辑：PHP编程网 - 黄冈站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!