|
副标题[/!--empirenews.page--]
--脚本用法
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
（编辑：ASP站长）
【免责声明】本站内容转载自互联网，其相关言论仅代表作者个人观点绝非权威，不代表本站立场。如您发现内容存在版权问题，请提交相关链接至邮箱：bqsm@foxmail.com，我们将及时予以处理。
|
