見過最全的獲取資料庫資訊的指令碼--生成html的報告

我在ＴＰＵＢ上發現的，我感覺這個指令碼確實不錯，按一個連線以後能用得著．http://www.itpub.net/thread-1020404-1-2.html

具體做法演示：

[oracle@rac1 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jul 11 15:57:34 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn sys/oracle as sysdba
Connected.
SQL> @dba_snapshot_database_10g.sql

+------------------------------------------------------------------------------- ----------+
|                             Snapshot Database 10g Release 2  |
|------------------------------------------------------------------------------- ----------+
| Copyright (c) 1998-2008 Jeffrey M. Hunter. All rights reserved. (www.idevelopm ent.info) |
+------------------------------------------------------------------------------- ----------+

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

Output written to: dba_snapshot_database_10g_ORCL_20080711.html
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8334342/viewspace-376667/，如需轉載，請註明出處，否則將追究法律責任。