文档介绍：-- +----------------------------------------------------------------------------+
-- | Jeffrey M. Hunter |
-- | ******@ |
-- | o |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2009 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : |
-- | CLASS : Database Administration |
-- | 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 10g Release 2. |
-- | Although this script will also work with Oracle Database 10g |
-- | Release 1, several sections will error out from missing tables |
-- | or columns. |
-- | USAGE : |
-- | |
-- | sqlplus -s <dba>/<password>@<TNS string> ***@ |
-- | |
-- | TESTING : This script has been essfully tested on the following |
-- | platforms: |
-- | |
-- | Linux : Oracle Database |
-- | Linux : Oracle RAC |
-- | Solaris : Oracle Database |
-- | Solaris : Oracle Database |
-- | Windows XP : Oracle Database |
-- | |
-- | NOTE : As with any code, ensure to test this script in a development |
-- | environment before attempting to run it in production. |
-- +----------------------------------------------------------------------------+
prompt
prompt +-----------------------------------------------------------------------------------------+
prompt | Snapshot Database 10g Release 2 |
prompt |-----------------------------------------------------------------------------------------+
prompt | Copyright (c) 1998-2009 Jeffrey M. Hunter. All rights reserved. (o) |
prompt +-----------------------------------------------------------------------