Differences

This shows you the differences between two versions of the page.

--- database_overview_-_from_idevelopment [2018/12/06 21:05] – created 91.177.234.129
+++ database_overview_-_from_idevelopment [2019/01/30 11:32] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Database_Overview_-_from_idevelopment ======
 <code>
 -- +----------------------------------------------------------------------------+
@@ Line 35: / Line 33: @@
  -- |            environment before attempting to run it in production.          |
  -- +----------------------------------------------------------------------------+
  prompt
  prompt +-----------------------------------------------------------------------------------------+
  prompt |                             Snapshot Database 10g Release 2                             |
@@ Line 46: / Line 44: @@
  prompt This script must be run as a user with SYSDBA privileges.
  prompt This process can take several minutes to complete.
  prompt
  define reportHeader="<font size=+3 color=darkgreen><b>Snapshot Database 10<i>g</i> Release 2</b></font><hr>Copyright (c) 1998-2011 Jeffrey M. Hunter. All rights reserved. (<a target=""_blank"" href=""http://www.idevelopment.info"">www.idevelopment.info</a>)<p>"
  -- +----------------------------------------------------------------------------+
  -- |                           SCRIPT SETTINGS                                  |
  -- +----------------------------------------------------------------------------+
  set termout       off
  set echo          off
@@ Line 64: / Line 62: @@
  set serveroutput  on
  set escape        on
  set pagesize 50000
  set linesize 175
  set long     2000000000
  clear buffer computes columns breaks
  define fileName=dba_snapshot_database_10g
  define versionNumber=5.3
  -- +----------------------------------------------------------------------------+
  -- |                   GATHER DATABASE REPORT INFORMATION                       |
  -- +----------------------------------------------------------------------------+
  COLUMN tdate NEW_VALUE _date NOPRINT
  SELECT TO_CHAR(SYSDATE,'MM/DD/YYYY') tdate FROM dual;
  COLUMN time NEW_VALUE _time NOPRINT
  SELECT TO_CHAR(SYSDATE,'HH24:MI:SS') time FROM dual;
  COLUMN date_time NEW_VALUE _date_time NOPRINT
  SELECT TO_CHAR(SYSDATE,'MM/DD/YYYY HH24:MI:SS') date_time FROM dual;
  COLUMN date_time_timezone NEW_VALUE _date_time_timezone NOPRINT
  SELECT TO_CHAR(systimestamp, 'Mon DD, YYYY (') || TRIM(TO_CHAR(systimestamp, 'Day')) || TO_CHAR(systimestamp, ') "at" HH:MI:SS AM') || TO_CHAR(systimestamp, ' "in Timezone" TZR') date_time_timezone
  FROM dual;
  COLUMN spool_time NEW_VALUE _spool_time NOPRINT
  SELECT TO_CHAR(SYSDATE,'YYYYMMDD') spool_time FROM dual;
  COLUMN dbname NEW_VALUE _dbname NOPRINT
  SELECT name dbname FROM v$database;
  COLUMN dbid NEW_VALUE _dbid NOPRINT
  SELECT dbid dbid FROM v$database;
  COLUMN platform_id NEW_VALUE _platform_id NOPRINT
  SELECT platform_id platform_id FROM v$database;
  COLUMN platform_name NEW_VALUE _platform_name NOPRINT
  SELECT platform_name platform_name FROM v$database;
  COLUMN global_name NEW_VALUE _global_name NOPRINT
  SELECT global_name global_name FROM global_name;
  COLUMN blocksize NEW_VALUE _blocksize NOPRINT
  SELECT value blocksize FROM v$parameter WHERE name='db_block_size';
  COLUMN startup_time NEW_VALUE _startup_time NOPRINT
  SELECT TO_CHAR(startup_time, 'MM/DD/YYYY HH24:MI:SS') startup_time FROM v$instance;
  COLUMN host_name NEW_VALUE _host_name NOPRINT
  SELECT host_name host_name FROM v$instance;
  COLUMN instance_name NEW_VALUE _instance_name NOPRINT
  SELECT instance_name instance_name FROM v$instance;
  COLUMN instance_number NEW_VALUE _instance_number NOPRINT
  SELECT instance_number instance_number FROM v$instance;
  COLUMN thread_number NEW_VALUE _thread_number NOPRINT
  SELECT thread# thread_number FROM v$instance;
  COLUMN cluster_database NEW_VALUE _cluster_database NOPRINT
  SELECT value cluster_database FROM v$parameter WHERE name='cluster_database';
  COLUMN cluster_database_instances NEW_VALUE _cluster_database_instances NOPRINT
  SELECT value cluster_database_instances FROM v$parameter WHERE name='cluster_database_instances';
  COLUMN reportRunUser NEW_VALUE _reportRunUser NOPRINT
  SELECT user reportRunUser FROM dual;
  -- +----------------------------------------------------------------------------+
  -- |                   GATHER DATABASE REPORT INFORMATION                       |
  -- +----------------------------------------------------------------------------+
  set heading on
  set markup html on spool on preformat off entmap on -
  head ' -
@@ Line 166: / Line 164: @@
    </style>' -
  body   'BGCOLOR="#C0C0C0"' -
  table  'WIDTH="90%" BORDER="1"'
  spool &FileName._&_dbname._&_spool_time..html
  set markup html on entmap off
  -- +----------------------------------------------------------------------------+
  -- |                             - REPORT HEADER -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name=top></a>
  prompt &reportHeader
  -- +----------------------------------------------------------------------------+
  -- |                             - REPORT INDEX -                               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="report_index"></a>
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Report Index</b></font><hr align="center" width="250"></center> -
  <table width="90%" border="1"> -
@@ Line 216: / Line 214: @@
  <td nowrap align="center" width="25%"><br></td> -
  </tr>
  prompt -
  <tr><th colspan="4">Scheduler / Jobs</th></tr> -
@@ Line 239: / Line 237: @@
  <td nowrap align="center" width="25%"><br></td> -
  </tr>
  prompt -
  <tr><th colspan="4">UNDO Segments</th></tr> -
@@ Line 249: / Line 247: @@
  <td nowrap align="center" width="25%"><br></td> -
  </tr>
  prompt -
  <tr><th colspan="4">Backups</th></tr> -
@@ Line 271: / Line 269: @@
  <td nowrap align="center" width="25%"><a class="link" href="#flash_recovery_area_status">Flash Recovery Area Status</a></td> -
  </tr>
  prompt -
  <tr><th colspan="4">Flashback Technologies</th></tr> -
@@ Line 287: / Line 285: @@
  <td nowrap align="center" width="25%"><a class="link" href="#"><br></a></td> -
  </tr>
  prompt -
  <tr><th colspan="4">Performance</th></tr> -
@@ Line 315: / Line 313: @@
  <td nowrap align="center" width="25%"><a class="link" href="#dba_enabled_aggregations">Enabled Aggregations</a></td> -
  </tr>
  prompt -
  <tr><th colspan="4">Automatic Workload Repository - (AWR)</th></tr> -
@@ Line 338: / Line 336: @@
  <td nowrap align="center" width="25%"><a class="link" href="#dba_enabled_aggregations">Enabled Aggregations</a></td> -
  </tr>
  prompt -
  <tr><th colspan="4">Security</th></tr> -
@@ Line 354: / Line 352: @@
  <td nowrap align="center" width="25%"><a class="link" href="#"><br></a></td> -
  </tr>
  prompt -
  <tr><th colspan="4">Objects</th></tr> -
@@ Line 376: / Line 374: @@
  <td nowrap align="center" width="25%"><a class="link" href="#dba_lob_segments">LOB Segments</a></td> -
  </tr>
  prompt -
  <tr> -
@@ Line 397: / Line 395: @@
  <td nowrap align="center" width="25%"><a class="link" href="#"><br></a></td> -
  </tr>
  prompt -
  <tr><th colspan="4">Online Analytical Processing - (OLAP)</th></tr> -
@@ Line 413: / Line 411: @@
  <td nowrap align="center" width="25%"><a class="link" href="#dba_olap_materialized_view_refresh_groups">Materialized View Refresh Groups</a></td> -
  </tr>
  prompt -
  <tr><th colspan="4">Data Pump</th></tr> -
@@ Line 423: / Line 421: @@
  <td nowrap align="center" width="25%"><a class="link" href="#"><br></a></td> -
  </tr>
  prompt -
  <tr><th colspan="4">Networking</th></tr> -
@@ Line 433: / Line 431: @@
  <td nowrap align="center" width="25%"><a class="link" href="#"><br></a></td> -
  </tr>
  prompt -
  <tr><th colspan="4">Replication</th></tr> -
@@ Line 462: / Line 460: @@
  </tr> -
  </table>
  prompt <p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 475: / Line 473: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Database and Instance Information</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                            - REPORT HEADER -                               |
  -- +----------------------------------------------------------------------------+
  prompt
  prompt <a name="report_header"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Report Header</b></font><hr align="left" width="460">
  prompt <table width="90%" border="1"> -
  <tr><th align="left" width="20%">Report Name</th><td width="80%"><tt>&FileName._&_dbname._&_spool_time..html</tt></td></tr> -
@@ Line 507: / Line 505: @@
  <tr><th align="left" width="20%">Report Run User</th><td width="80%"><tt>&_reportRunUser</tt></td></tr> -
  </table>
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- SET TIMING ON
  -- +----------------------------------------------------------------------------+
  -- |                                 - VERSION -                                |
  -- +----------------------------------------------------------------------------+
  prompt <a name="version"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Version</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN banner   FORMAT a120   HEADING 'Banner'
  SELECT * FROM v$version;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                                 - OPTIONS -                                |
  -- +----------------------------------------------------------------------------+
  prompt <a name="options"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Options</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN parameter      HEADING 'Option Name'      ENTMAP off
  COLUMN value          HEADING 'Installed?'       ENTMAP off
  SELECT
      DECODE(   value
@@ Line 559: / Line 557: @@
  FROM v$option
  ORDER BY parameter;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                         - DATABASE REGISTRY -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name="database_registry"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Database Registry</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN comp_id       FORMAT a75   HEADING 'Component ID'       ENTMAP off
  COLUMN comp_name     FORMAT a75   HEADING 'Component Name'     ENTMAP off
@@ Line 582: / Line 580: @@
  COLUMN schema                     HEADING 'Schema'             ENTMAP off
  COLUMN procedure                  HEADING 'Procedure'          ENTMAP off
  SELECT
      '<font color="#336699"><b>' || comp_id    || '</b></font>' comp_id
@@ Line 597: / Line 595: @@
  FROM dba_registry
  ORDER BY comp_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                       - FEATURE USAGE STATISTICS -                         |
  -- +----------------------------------------------------------------------------+
  prompt <a name="feature_usage_statistics"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Feature Usage Statistics</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN feature_name          FORMAT a115    HEADING 'Feature|Name'
  COLUMN version               FORMAT a75     HEADING 'Version'
@@ Line 621: / Line 619: @@
  COLUMN last_sample_date      FORMAT a95     HEADING 'Last Sample|Date'
  COLUMN next_sample_date      FORMAT a95     HEADING 'Next Sample|Date'
  SELECT
      '<div align="left"><font color="#336699"><b>' || name || '</b></font></div>'      feature_name
    , DECODE(   detected_usages
              , 0
              , version
              , '<font color="#663300"><b>' || version || '</b></font>')                  version
    , DECODE(   detected_usages
@@ Line 658: / Line 656: @@
  FROM dba_feature_usage_statistics
  ORDER BY name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                      - HIGH WATER MARK STATISTICS -                        |
  -- +----------------------------------------------------------------------------+
  prompt <a name="high_water_mark_statistics"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>High Water Mark Statistics</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN statistic_name        FORMAT a115                    HEADING 'Statistic Name'
  COLUMN version               FORMAT a62                     HEADING 'Version'
@@ Line 678: / Line 676: @@
  COLUMN last_value            FORMAT 9,999,999,999,999,999   HEADING 'Last Value'
  COLUMN description           FORMAT a120                    HEADING 'Description'
  SELECT
      '<div align="left"><font color="#336699"><b>' || name || '</b></font></div>'  statistic_name
@@ Line 687: / Line 685: @@
  FROM dba_high_water_mark_statistics
  ORDER BY name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - INSTANCE OVERVIEW -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="instance_overview"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Instance Overview</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name_print       FORMAT a75    HEADING 'Instance|Name'       ENTMAP off
  COLUMN instance_number_print     FORMAT a75    HEADING 'Instance|Num'        ENTMAP off
@@ Line 714: / Line 712: @@
  COLUMN logins                    FORMAT a75    HEADING 'Logins'              ENTMAP off
  COLUMN archiver                  FORMAT a75    HEADING 'Archiver'            ENTMAP off
  SELECT
      '<div align="center"><font color="#336699"><b>' || instance_name || '</b></font></div>'         instance_name_print
@@ Line 732: / Line 730: @@
  FROM gv$instance
  ORDER BY instance_number;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - DATABASE OVERVIEW -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="database_overview"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Database Overview</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN name                            FORMAT a75     HEADING 'Database|Name'              ENTMAP off
  COLUMN dbid                                           HEADING 'Database|ID'                ENTMAP off
@@ Line 759: / Line 757: @@
  COLUMN controlfile_type                               HEADING 'Controlfile|Type'           ENTMAP off
  COLUMN last_open_incarnation_number                   HEADING 'Last Open|Incarnation Num'  ENTMAP off
  SELECT
      '<div align="center"><font color="#336699"><b>'  || name  || '</b></font></div>'          name
@@ Line 774: / Line 772: @@
    , '<div align="center">' || last_open_incarnation# || '</div>'                              last_open_incarnation_number
  FROM v$database;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                       - INITIALIZATION PARAMETERS -                        |
  -- +----------------------------------------------------------------------------+
  prompt <a name="initialization_parameters"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Initialization Parameters</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN spfile  HEADING 'SPFILE Usage'
  SELECT
    'This database '||
@@ Line 800: / Line 798: @@
  FROM v$spparameter
  WHERE value IS NOT null;
  COLUMN pname                FORMAT a75    HEADING 'Parameter Name'    ENTMAP off
  COLUMN instance_name_print  FORMAT a45    HEADING 'Instance Name'     ENTMAP off
@@ Line 807: / Line 805: @@
  COLUMN isdefault            FORMAT a75    HEADING 'Is Default?'       ENTMAP off
  COLUMN issys_modifiable     FORMAT a75    HEADING 'Is Dynamic?'       ENTMAP off
  BREAK ON report ON pname
  SELECT
      DECODE(   p.isdefault
@@ Line 839: / Line 837: @@
      p.name
    , i.instance_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                            - CONTROL FILES -                               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="control_files"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Control Files</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN name                           HEADING 'Controlfile Name'  ENTMAP off
  COLUMN status           FORMAT a75    HEADING 'Status'            ENTMAP off
  COLUMN file_size        FORMAT a75    HEADING 'File Size'         ENTMAP off
  SELECT
      '<tt>' || c.name || '</tt>'                                                                      name
@@ Line 865: / Line 863: @@
              ,  '<div align="center"><b><font color="#663300">'   || c.status || '</font></b></div>') status
    , '<div align="right">' || TO_CHAR(block_size *  file_size_blks, '999,999,999,999') || '</div>'    file_size
  FROM
      v$controlfile c
  ORDER BY
      c.name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                         - CONTROL FILE RECORDS -                           |
  -- +----------------------------------------------------------------------------+
  prompt <a name="control_file_records"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Control File Records</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN type           FORMAT          a95    HEADING 'Record Section Type'      ENTMAP off
  COLUMN record_size    FORMAT       999,999   HEADING 'Record Size|(in bytes)'   ENTMAP off
@@ Line 894: / Line 892: @@
  COLUMN last_index                            HEADING 'Last Index'               ENTMAP off
  COLUMN last_recid                            HEADING 'Last RecID'               ENTMAP off
  BREAK ON report
  COMPUTE sum LABEL '<font color="#990000"><b>Total: </b></font>'   of record_size records_total bytes_alloc records_used bytes_used ON report
  COMPUTE avg LABEL '<font color="#990000"><b>Average: </b></font>' of pct_used      ON report
  SELECT
      '<div align="left"><font color="#336699"><b>' || type || '</b></font></div>'  type
@@ Line 912: / Line 910: @@
  FROM v$controlfile_record_section
  ORDER BY type;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                          - ONLINE REDO LOGS -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name="online_redo_logs"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Online Redo Logs</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name_print  FORMAT a95                HEADING 'Instance Name'    ENTMAP off
  COLUMN thread_number_print  FORMAT a95                HEADING 'Thread Number'    ENTMAP off
@@ Line 935: / Line 933: @@
  COLUMN bytes                FORMAT 999,999,999,999    HEADING 'Bytes'            ENTMAP off
  COLUMN archived             FORMAT a75                HEADING 'Archived?'        ENTMAP off
  BREAK ON report ON instance_name_print ON thread_number_print
  SELECT
      '<div align="center"><font color="#336699"><b>' || i.instance_name || '</b></font></div>'        instance_name_print
@@ Line 963: / Line 961: @@
    , f.group#
    , f.member;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                         - REDO LOG SWITCHES -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name="redo_log_switches"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Redo Log Switches</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN DAY   FORMAT a75              HEADING 'Day / Time'  ENTMAP off
  COLUMN H00   FORMAT 999,999B         HEADING '00'          ENTMAP off
@@ Line 1005: / Line 1003: @@
  COLUMN H23   FORMAT 999,999B         HEADING '23'          ENTMAP off
  COLUMN TOTAL FORMAT 999,999,999      HEADING 'Total'       ENTMAP off
  BREAK ON report
  COMPUTE sum LABEL '<font color="#990000"><b>Total:</b></font>' avg label '<font color="#990000"><b>Average:</b></font>' OF total ON report
  SELECT
      '<div align="center"><font color="#336699"><b>' || SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5)  || '</b></font></div>'  DAY
@@ Line 1041: / Line 1039: @@
  ORDER BY SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5)
  /
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                          - OUTSTANDING ALERTS -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="outstanding_alerts"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Outstanding Alerts</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN severity          FORMAT a75       HEADING 'Severity'        ENTMAP off
  COLUMN target_name       FORMAT a75       HEADING 'Target Name'     ENTMAP off
@@ Line 1063: / Line 1061: @@
  COLUMN message           FORMAT a125      HEADING 'Message'         ENTMAP off
  COLUMN alert_triggered   FORMAT a75       HEADING 'Alert Triggered' ENTMAP off
  SELECT
      DECODE(   alert_state
@@ Line 1091: / Line 1089: @@
      alert_state
    , collection_timestamp;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                          - STATISTICS LEVEL -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name="statistics_level"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Statistics Level</b></font><hr align="left" width="460">
  prompt "Automatic Database Management" was first introduced in Oracle10<i>g</i> where the Oracle database
  prompt can now automatically perform many of the routine monitoring and administrative activities that had
@@ Line 1111: / Line 1109: @@
  prompt of these new components can only be enabled when the STATISTICS_LEVEL initialization parameter
  prompt is set to TYPICAL (the default) or ALL. A value of BASIC turns off these components and disables
  prompt all self-tuning capabilities of the database. The view V$STATISTICS_LEVEL shows the statistic
  prompt component, description, and at what level of the STATISTICS_LEVEL parameter the
  prompt component is enabled.
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name_print     FORMAT a95    HEADING 'Instance Name'         ENTMAP off
  COLUMN statistics_name         FORMAT a95    HEADING 'Statistics Name'       ENTMAP off
@@ Line 1124: / Line 1122: @@
  COLUMN statistics_view_name    FORMAT a95    HEADING 'Statistics View Name'  ENTMAP off
  COLUMN session_settable        FORMAT a95    HEADING 'Session Settable?'     ENTMAP off
  BREAK ON report ON instance_name_print
  SELECT
      '<div align="center"><font color="#336699"><b>' || i.instance_name    || '</b></font></div>'               instance_name_print
@@ Line 1155: / Line 1153: @@
      i.instance_name
    , s.statistics_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 1168: / Line 1166: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Scheduler / Jobs</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                                 - JOBS -                                   |
  -- +----------------------------------------------------------------------------+
  prompt <a name="jobs"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Jobs</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN job_id     FORMAT a75             HEADING 'Job ID'           ENTMAP off
  COLUMN username   FORMAT a75             HEADING 'User'             ENTMAP off
@@ Line 1191: / Line 1189: @@
  COLUMN failures   FORMAT a75             HEADING 'Failures'         ENTMAP off
  COLUMN broken     FORMAT a75             HEADING 'Broken?'          ENTMAP off
  SELECT
      DECODE(   broken
@@ Line 1208: / Line 1206: @@
              , 'Y'
              , '<div nowrap align="right"><b><font color="#990000">' || NVL(TO_CHAR(next_date, 'mm/dd/yyyy HH24:MI:SS'), '<br>') || '</font></b></div>'
              , '<div nowrap align="right">'                          || NVL(TO_CHAR(next_date, 'mm/dd/yyyy HH24:MI:SS'), '<br>') || '</div>')      next_date
    , DECODE(   broken
              , 'Y'
@@ Line 1216: / Line 1214: @@
              , 'Y'
              , '<div nowrap align="right"><b><font color="#990000">' || NVL(TO_CHAR(last_date, 'mm/dd/yyyy HH24:MI:SS'), '<br>') || '</font></b></div>'
              , '<div nowrap align="right">'                          || NVL(TO_CHAR(last_date, 'mm/dd/yyyy HH24:MI:SS'), '<br>') || '</div>')    last_date
    , DECODE(   broken
              , 'Y'
@@ Line 1229: / Line 1227: @@
  ORDER BY
      job;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 1242: / Line 1240: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Storage</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                            - TABLESPACES -                                 |
  -- +----------------------------------------------------------------------------+
  prompt <a name="tablespaces"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Tablespaces</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN status                                  HEADING 'Status'            ENTMAP off
  COLUMN name                                    HEADING 'Tablespace Name'   ENTMAP off
@@ Line 1266: / Line 1264: @@
  COLUMN used        FORMAT 999,999,999,999,999  HEADING 'Used (in bytes)'   ENTMAP off
  COLUMN pct_used                                HEADING 'Pct. Used'         ENTMAP off
  BREAK ON report
  COMPUTE SUM label '<font color="#990000"><b>Total:</b></font>'   OF ts_size used free ON report
  SELECT
      DECODE(   d.status
@@ Line 1282: / Line 1280: @@
    , NVL(f.bytes, 0)                                     free
    , NVL(a.bytes - NVL(f.bytes, 0), 0)                   used
    , '<div align="right"><b>' ||
            DECODE (
                (1-SIGN(1-SIGN(TRUNC(NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0)) - 90)))
@@ Line 1290: / Line 1288: @@
            )
      || '</b> %</div>' pct_used
  FROM
      sys.dba_tablespaces d
    , ( select tablespace_name, sum(bytes) bytes
@@ Line 1308: / Line 1306: @@
      d.contents like 'TEMPORARY'
    )
  UNION ALL
  SELECT
      DECODE(   d.status
@@ Line 1321: / Line 1319: @@
    , NVL(a.bytes - NVL(t.bytes,0), 0)             free
    , NVL(t.bytes, 0)                              used
    , '<div align="right"><b>' ||
            DECODE (
                (1-SIGN(1-SIGN(TRUNC(NVL(t.bytes / a.bytes * 100, 0)) - 90)))
@@ Line 1345: / Line 1343: @@
    AND d.contents like 'TEMPORARY'
  ORDER BY 2;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                            - DATA FILES -                                  |
  -- +----------------------------------------------------------------------------+
  prompt <a name="data_files"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Data Files</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN tablespace                                   HEADING 'Tablespace Name / File Class'  ENTMAP off
  COLUMN filename                                     HEADING 'Filename'                      ENTMAP off
@@ Line 1366: / Line 1364: @@
  COLUMN increment_by    FORMAT 999,999,999,999,999   HEADING 'Next'                          ENTMAP off
  COLUMN maxbytes        FORMAT 999,999,999,999,999   HEADING 'Max'                           ENTMAP off
  BREAK ON report
  COMPUTE sum LABEL '<font color="#990000"><b>Total: </b></font>' OF filesize ON report
  SELECT /*+ ordered */
      '<font color="#336699"><b>' || d.tablespace_name  || '</b></font>'  tablespace
@@ Line 1381: / Line 1379: @@
    , v$datafile v
    , (SELECT value
       FROM v$parameter
       WHERE name = 'db_block_size') e
  WHERE
@@ Line 1387: / Line 1385: @@
  UNION
  SELECT
      '<font color="#336699"><b>' || d.tablespace_name || '</b></font>'   tablespace
    , '<tt>' || d.file_name  || '</tt>'                                   filename
    , d.bytes                                                             filesize
@@ Line 1396: / Line 1394: @@
      sys.dba_temp_files d
    , (SELECT value
       FROM v$parameter
       WHERE name = 'db_block_size') e
  UNION
  SELECT
-     '<font color="#336699"><b>[ ONLINE REDO LOG ]</b></font>'
+     '<font color="#336699"><b>[[ ONLINE REDO LOG ]]</b></font>'
    , '<tt>' || a.member || '</tt>'
    , b.bytes
@@ Line 1413: / Line 1411: @@
  UNION
  SELECT
-     '<font color="#336699"><b>[ CONTROL FILE    ]</b></font>'
+     '<font color="#336699"><b>[[ CONTROL FILE    ]]</b></font>'
    , '<tt>' || a.name || '</tt>'
    , null
@@ Line 1424: / Line 1422: @@
    , 2;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                          - DATABASE GROWTH -                               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="database_growth"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Database Growth</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN month        FORMAT a75                  HEADING 'Month'
  COLUMN growth       FORMAT 999,999,999,999,999  HEADING 'Growth (bytes)'
  BREAK ON report
  COMPUTE SUM label '<font color="#990000"><b>Total:</b></font>' OF growth ON report
  SELECT
      '<div align="left"><font color="#336699"><b>' || TO_CHAR(creation_time, 'RRRR-MM') || '</b></font></div>' month
@@ Line 1451: / Line 1449: @@
  GROUP BY TO_CHAR(creation_time, 'RRRR-MM')
  ORDER BY TO_CHAR(creation_time, 'RRRR-MM');
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                        - TABLESPACE EXTENTS -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name="tablespace_extents"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Tablespace Extents</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN tablespace_name                              HEADING 'Tablespace Name'         ENTMAP off
  COLUMN largest_ext     FORMAT 999,999,999,999,999   HEADING 'Largest Extent'          ENTMAP off
@@ Line 1471: / Line 1469: @@
  COLUMN total_free      FORMAT 999,999,999,999,999   HEADING 'Total Free'              ENTMAP off
  COLUMN pieces          FORMAT 999,999,999,999,999   HEADING 'Number of Free Extents'  ENTMAP off
  break on report
  compute sum label '<font color="#990000"><b>Total:</b></font>' of largest_ext smallest_ext total_free pieces on report
  SELECT
      '<b><font color="#336699">' || tablespace_name || '</font></b>' tablespace_name
    , max(bytes)       largest_ext
@@ Line 1487: / Line 1485: @@
  ORDER BY
      tablespace_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                        - TABLESPACE TO OWNER  -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="tablespace_to_owner"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Tablespace to Owner</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN tablespace_name  FORMAT a75                  HEADING 'Tablespace Name'  ENTMAP off
  COLUMN owner            FORMAT a75                  HEADING 'Owner'            ENTMAP off
@@ Line 1507: / Line 1505: @@
  COLUMN bytes            FORMAT 999,999,999,999,999  HEADING 'Size (in Bytes)'  ENTMAP off
  COLUMN seg_count        FORMAT 999,999,999,999      HEADING 'Segment Count'    ENTMAP off
  BREAK ON report ON tablespace_name
  COMPUTE sum LABEL '<font color="#990000"><b>Total: </b></font>' of seg_count bytes ON report
  SELECT
      '<font color="#336699"><b>' || tablespace_name || '</b></font>'  tablespace_name
@@ Line 1527: / Line 1525: @@
    , owner
    , segment_type;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                       - OWNER TO TABLESPACE -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name="owner_to_tablespace"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Owner to Tablespace</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner            FORMAT a75                  HEADING 'Owner'            ENTMAP off
  COLUMN tablespace_name  FORMAT a75                  HEADING 'Tablespace Name'  ENTMAP off
@@ Line 1547: / Line 1545: @@
  COLUMN bytes            FORMAT 999,999,999,999,999  HEADING 'Size (in Bytes)'  ENTMAP off
  COLUMN seg_count        FORMAT 999,999,999,999      HEADING 'Segment Count'    ENTMAP off
  break on report on owner
  compute sum label '<font color="#990000"><b>Total: </b></font>' of seg_count bytes on report
  SELECT
      '<font color="#336699"><b>'  || owner           || '</b></font>' owner
@@ Line 1567: / Line 1565: @@
    , tablespace_name
    , segment_type;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 1580: / Line 1578: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>UNDO Segments</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                       - UNDO RETENTION PARAMETERS -                        |
  -- +----------------------------------------------------------------------------+
  prompt <a name="undo_retention_parameters"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>UNDO Retention Parameters</b></font><hr align="left" width="460">
  prompt <b>undo_retention is specified in minutes</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name_print   FORMAT a95    HEADING 'Instance Name'     ENTMAP off
  COLUMN thread_number_print   FORMAT a95    HEADING 'Thread Number'     ENTMAP off
  COLUMN name                  FORMAT a125   HEADING 'Name'              ENTMAP off
  COLUMN value                               HEADING 'Value'             ENTMAP off
  BREAK ON report ON instance_name_print ON thread_number_print
  SELECT
      '<div align="center"><font color="#336699"><b>' || i.instance_name || '</b></font></div>'        instance_name_print
@@ Line 1622: / Line 1620: @@
      i.instance_name
    , p.name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                            - UNDO SEGMENTS -                               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="undo_segments"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>UNDO Segments</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name FORMAT a75              HEADING 'Instance Name'      ENTMAP off
  COLUMN tablespace    FORMAT a85              HEADING 'Tablspace'          ENTMAP off
@@ Line 1648: / Line 1646: @@
  COLUMN bytes         FORMAT 999,999,999,999  HEADING 'Bytes'              ENTMAP off
  COLUMN extents       FORMAT 999,999,999      HEADING 'Extents'            ENTMAP off
  CLEAR COMPUTES BREAKS
  BREAK ON report ON instance_name ON tablespace
  -- COMPUTE sum LABEL '<font color="#990000"><b>Total:</b></font>' OF bytes extents shrinks wraps ON report
  SELECT
      '<div nowrap><font color="#336699"><b>' ||  NVL(i.instance_name, '<br>')     || '</b></font></div>'  instance_name
@@ Line 1692: / Line 1690: @@
      a.tablespace_name
    , a.segment_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                        - UNDO SEGMENT CONTENTION -                         |
  -- +----------------------------------------------------------------------------+
  prompt <a name="undo_segment_contention"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>UNDO Segment Contention</b></font><hr align="left" width="460">
  prompt <b>UNDO statistics from V$ROLLSTAT - (ordered by waits)</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN roll_name                             HEADING 'UNDO Segment Name'   ENTMAP off
  COLUMN gets             FORMAT 999,999,999   HEADING 'Gets'                ENTMAP off
@@ Line 1714: / Line 1712: @@
  COLUMN immediate_misses FORMAT 999,999,999   HEADING 'Immediate Misses'    ENTMAP off
  COLUMN hit_ratio                             HEADING 'Hit Ratio'           ENTMAP off
  BREAK ON report
  COMPUTE SUM label '<font color="#990000"><b>Total:</b></font>' OF gets waits ON report
  SELECT
      '<font color="#336699"><b>' || b.name || '</b></font>'  roll_name
@@ Line 1723: / Line 1721: @@
    , waits                              waits
    , '<div align="right">' || TO_CHAR(ROUND(((gets - waits)*100)/gets, 2)) || '%</div>' hit_ratio
  FROM
      sys.v_$rollstat a
    , sys.v_$rollname b
@@ Line 1730: / Line 1728: @@
  ORDER BY
      waits DESC;
  prompt
  prompt <b>Wait statistics</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN class                  HEADING 'Class'
  COLUMN ratio                  HEADING 'Wait Ratio'
  SELECT
      '<font color="#336699"><b>' || w.class || '</b></font>'                            class
@@ Line 1756: / Line 1754: @@
      w.class
    , w.count;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 1770: / Line 1768: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Backups</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                           - RMAN BACKUP JOBS -                             |
  -- +----------------------------------------------------------------------------+
  prompt <a name="rman_backup_jobs"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>RMAN Backup Jobs</b></font><hr align="left" width="460">
  prompt <b>Last 10 RMAN backup jobs</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN backup_name           FORMAT a130   HEADING 'Backup Name'          ENTMAP off
  COLUMN start_time            FORMAT a75    HEADING 'Start Time'           ENTMAP off
@@ Line 1796: / Line 1794: @@
  COLUMN output_size                         HEADING 'Output Size'          ENTMAP off
  COLUMN output_rate_per_sec                 HEADING 'Output Rate Per Sec'  ENTMAP off
  SELECT
      '<div nowrap><b><font color="#336699">' || r.command_id                                   || '</font></b></div>'  backup_name
@@ Line 1830: / Line 1828: @@
      ) r
  WHERE
      rownum < 11;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - RMAN CONFIGURATION -                           |
  -- +----------------------------------------------------------------------------+
  prompt <a name="rman_configuration"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>RMAN Configuration</b></font><hr align="left" width="460">
  prompt <b>All non-default RMAN configuration settings</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN name     FORMAT a130   HEADING 'Name'   ENTMAP off
  COLUMN value                  HEADING 'Value'  ENTMAP off
  SELECT
      '<div nowrap><b><font color="#336699">' || name || '</font></b></div>'   name
@@ Line 1858: / Line 1856: @@
  ORDER BY
      name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - RMAN BACKUP SETS -                             |
  -- +----------------------------------------------------------------------------+
  prompt <a name="rman_backup_sets"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>RMAN Backup Sets</b></font><hr align="left" width="460">
  prompt <b>Available backup sets contained in the control file including available and expired backup sets</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN bs_key                 FORMAT a75                    HEADING 'BS Key'                 ENTMAP off
  COLUMN backup_type            FORMAT a70                    HEADING 'Backup Type'            ENTMAP off
@@ Line 1890: / Line 1888: @@
  COLUMN keep_until             FORMAT a75                    HEADING 'Keep Until'             ENTMAP off
  COLUMN keep_options           FORMAT a15                    HEADING 'Keep Options'           ENTMAP off
  BREAK ON report
  COMPUTE sum LABEL '<font color="#990000"><b>Total:</b></font>' OF pieces elapsed_seconds ON report
  SELECT
      '<div align="center"><font color="#336699"><b>' || bs.recid || '</b></font></div>'                        bs_key
@@ Line 1932: / Line 1930: @@
  ORDER BY
      bs.recid;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                          - RMAN BACKUP PIECES -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="rman_backup_pieces"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>RMAN Backup Pieces</b></font><hr align="left" width="460">
  prompt <b>Available backup pieces contained in the control file including available and expired backup sets</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN bs_key              FORMAT a75                     HEADING 'BS Key'            ENTMAP off
  COLUMN piece#                                             HEADING 'Piece #'           ENTMAP off
@@ Line 1959: / Line 1957: @@
  COLUMN elapsed_seconds     FORMAT 999,999,999,999,999     HEADING 'Elapsed Seconds'   ENTMAP off
  COLUMN deleted             FORMAT a10                     HEADING 'Deleted?'          ENTMAP off
  BREAK ON bs_key
  SELECT
      '<div align="center"><font color="#336699"><b>' || bs.recid  || '</b></font></div>'                bs_key
@@ Line 1985: / Line 1983: @@
      bs.recid
    , piece#;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                       - RMAN BACKUP CONTROL FILES -                        |
  -- +----------------------------------------------------------------------------+
  prompt <a name="rman_backup_control_files"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>RMAN Backup Control Files</b></font><hr align="left" width="460">
  prompt <b>Available automatic control files within all available (and expired) backup sets</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN bs_key                 FORMAT a75                     HEADING 'BS Key'                 ENTMAP off
  COLUMN piece#                                                HEADING 'Piece #'                ENTMAP off
@@ Line 2013: / Line 2011: @@
  COLUMN elapsed_seconds        FORMAT 999,999,999,999,999     HEADING 'Elapsed Seconds'        ENTMAP off
  COLUMN deleted                FORMAT a10                     HEADING 'Deleted?'               ENTMAP off
  BREAK ON bs_key
  SELECT
      '<div align="center"><font color="#336699"><b>' || bs.recid  || '</b></font></div>'             bs_key
@@ Line 2040: / Line 2038: @@
      bs.recid
    , piece#;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - RMAN BACKUP SPFILE -                           |
  -- +----------------------------------------------------------------------------+
  prompt <a name="rman_backup_spfile"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>RMAN Backup SPFILE</b></font><hr align="left" width="460">
  prompt <b>Available automatic SPFILE backups within all available (and expired) backup sets</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN bs_key                 FORMAT a75                     HEADING 'BS Key'                 ENTMAP off
  COLUMN piece#                                                HEADING 'Piece #'                ENTMAP off
@@ Line 2068: / Line 2066: @@
  COLUMN elapsed_seconds        FORMAT 999,999,999,999,999     HEADING 'Elapsed Seconds'        ENTMAP off
  COLUMN deleted                FORMAT a10                     HEADING 'Deleted?'               ENTMAP off
  BREAK ON bs_key
  SELECT
      '<div align="center"><font color="#336699"><b>' || bs.recid  || '</b></font></div>'             bs_key
@@ Line 2098: / Line 2096: @@
      bs.recid
    , piece#;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                             - ARCHIVING MODE -                             |
  -- +----------------------------------------------------------------------------+
  prompt <a name="archiving_mode"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Archiving Mode</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN db_log_mode                  FORMAT a95                HEADING 'Database|Log Mode'             ENTMAP off
  COLUMN log_archive_start            FORMAT a95                HEADING 'Automatic|Archival'            ENTMAP off
  COLUMN oldest_online_log_sequence   FORMAT 999999999999999    HEADING 'Oldest Online |Log Sequence'   ENTMAP off
  COLUMN current_log_seq              FORMAT 999999999999999    HEADING 'Current |Log Sequence'         ENTMAP off
  SELECT
      '<div align="center"><font color="#663300"><b>' || d.log_mode           || '</b></font></div>'    db_log_mode
@@ Line 2148: / Line 2146: @@
      ) o
  /
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                         - ARCHIVE DESTINATIONS -                           |
  -- +----------------------------------------------------------------------------+
  prompt <a name="archive_destinations"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Archive Destinations</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN dest_id                                                HEADING 'Destination|ID'            ENTMAP off
  COLUMN dest_name                                              HEADING 'Destination|Name'          ENTMAP off
@@ Line 2171: / Line 2169: @@
  COLUMN archiver                                               HEADING 'Archiver'                  ENTMAP off
  COLUMN log_sequence                 FORMAT 999999999999999    HEADING 'Current Log|Sequence'      ENTMAP off
  SELECT
      '<div align="center"><font color="#336699"><b>' || a.dest_id || '</b></font></div>'    dest_id
@@ Line 2191: / Line 2189: @@
      a.dest_id
  /
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                    - ARCHIVING INSTANCE PARAMETERS -                       |
  -- +----------------------------------------------------------------------------+
  prompt <a name="archiving_instance_parameters"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Archiving Instance Parameters</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN name      HEADING 'Parameter Name'   ENTMAP off
  COLUMN value     HEADING 'Parameter Value'  ENTMAP off
  SELECT
      '<b><font color="#336699">' || a.name || '</font></b>'    name
@@ Line 2219: / Line 2217: @@
  ORDER BY
      a.name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - ARCHIVING HISTORY -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="archiving_history"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Archiving History</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN thread#          FORMAT a79                   HEADING 'Thread#'           ENTMAP off
  COLUMN sequence#        FORMAT a79                   HEADING 'Sequence#'         ENTMAP off
@@ Line 2246: / Line 2244: @@
  COLUMN deleted          FORMAT a31                   HEADING 'Deleted?'          ENTMAP off
  COLUMN status           FORMAT a75                   HEADING 'Status'            ENTMAP off
  BREAK ON report ON thread#
  SELECT
      '<div align="center"><b><font color="#336699">' || thread#   || '</font></b></div>'  thread#
@@ Line 2274: / Line 2272: @@
      thread#
    , sequence#;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                     - FLASH RECOVERY AREA PARAMETERS -                     |
  -- +----------------------------------------------------------------------------+
  prompt <a name="flash_recovery_area_parameters"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Flash Recovery Area Parameters</b></font><hr align="left" width="460">
  prompt <b>db_recovery_file_dest_size is specified in bytes</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name_print   FORMAT a95    HEADING 'Instance Name'     ENTMAP off
  COLUMN thread_number_print   FORMAT a95    HEADING 'Thread Number'     ENTMAP off
  COLUMN name                  FORMAT a125   HEADING 'Name'              ENTMAP off
  COLUMN value                               HEADING 'Value'             ENTMAP off
  BREAK ON report ON instance_name_print ON thread_number_print
  SELECT
      '<div align="center"><font color="#336699"><b>' || i.instance_name || '</b></font></div>'        instance_name_print
@@ Line 2316: / Line 2314: @@
    , 3;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                      - FLASH RECOVERY AREA STATUS -                        |
  -- +----------------------------------------------------------------------------+
  prompt <a name="flash_recovery_area_status"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Flash Recovery Area Status</b></font><hr align="left" width="460">
  prompt <b>Current location, disk quota, space in use, space reclaimable by deleting files, and number of files in the Flash Recovery Area</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN name               FORMAT a75                  HEADING 'Name'               ENTMAP off
  COLUMN space_limit        FORMAT 99,999,999,999,999   HEADING 'Space Limit'        ENTMAP off
@@ Line 2340: / Line 2338: @@
  COLUMN pct_reclaimable    FORMAT 999.99               HEADING '% Reclaimable'      ENTMAP off
  COLUMN number_of_files    FORMAT 999,999              HEADING 'Number of Files'    ENTMAP off
  SELECT
      '<div align="center"><font color="#336699"><b>' || name || '</b></font></div>'    name
@@ Line 2353: / Line 2351: @@
  ORDER BY
      name;
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN file_type                  FORMAT a75     HEADING 'File Type'
  COLUMN percent_space_used                        HEADING 'Percent Space Used'
  COLUMN percent_space_reclaimable                 HEADING 'Percent Space Reclaimable'
  COLUMN number_of_files            FORMAT 999,999 HEADING 'Number of Files'
  SELECT
      '<div align="center"><font color="#336699"><b>' || file_type || '</b></font></div>' file_type
@@ Line 2369: / Line 2367: @@
  FROM
      v$flash_recovery_area_usage;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 2382: / Line 2380: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Flashback Technologies</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                     - FLASHBACK DATABASE PARAMETERS -                      |
  -- +----------------------------------------------------------------------------+
  prompt <a name="flashback_database_parameters"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Flashback Database Parameters</b></font><hr align="left" width="460">
  prompt <b>db_flashback_retention_target is specified in minutes</b>
  prompt <b>db_recovery_file_dest_size is specified in bytes</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name_print   FORMAT a95    HEADING 'Instance Name'     ENTMAP off
  COLUMN thread_number_print   FORMAT a95    HEADING 'Thread Number'     ENTMAP off
  COLUMN name                  FORMAT a125   HEADING 'Name'              ENTMAP off
  COLUMN value                               HEADING 'Value'             ENTMAP off
  BREAK ON report ON instance_name_print ON thread_number_print
  SELECT
      '<div align="center"><font color="#336699"><b>' || i.instance_name || '</b></font></div>'        instance_name_print
@@ Line 2426: / Line 2424: @@
    , 3;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                       - FLASHBACK DATABASE STATUS -                        |
  -- +----------------------------------------------------------------------------+
  prompt <a name="flashback_database_status"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Flashback Database Status</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN dbid                                HEADING 'DB ID'              ENTMAP off
  COLUMN name             FORMAT A75         HEADING 'DB Name'            ENTMAP off
  COLUMN log_mode         FORMAT A75         HEADING 'Log Mode'           ENTMAP off
  COLUMN flashback_on     FORMAT A75         HEADING 'Flashback DB On?'   ENTMAP off
  SELECT
      '<div align="center"><font color="#336699"><b>' || dbid          || '</b></font></div>'  dbid
@@ Line 2452: / Line 2450: @@
    , '<div align="center">'                          || flashback_on  || '</div>'             flashback_on
  FROM v$database;
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN oldest_flashback_time    FORMAT a125               HEADING 'Oldest Flashback Time'     ENTMAP off
  COLUMN oldest_flashback_scn                               HEADING 'Oldest Flashback SCN'      ENTMAP off
@@ Line 2461: / Line 2459: @@
  COLUMN flashback_size           FORMAT 9,999,999,999,999  HEADING 'Flashback Size'            ENTMAP off
  COLUMN estimated_flashback_size FORMAT 9,999,999,999,999  HEADING 'Estimated Flashback Size'  ENTMAP off
  SELECT
      '<div align="center"><font color="#336699"><b>' || TO_CHAR(oldest_flashback_time,'mm/dd/yyyy HH24:MI:SS') || '</b></font></div>'  oldest_flashback_time
@@ Line 2473: / Line 2471: @@
  ORDER BY
 ;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                  - FLASHBACK DATABASE REDO TIME MATRIX -                   |
  -- +----------------------------------------------------------------------------+
  prompt <a name="flashback_database_redo_time_matrix"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Flashback Database Redo Time Matrix</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN begin_time               FORMAT a75                HEADING 'Begin Time'               ENTMAP off
  COLUMN end_time                 FORMAT a75                HEADING 'End Time'                 ENTMAP off
@@ Line 2494: / Line 2492: @@
  COLUMN redo_data                FORMAT 9,999,999,999,999  HEADING 'Redo Data'                ENTMAP off
  COLUMN estimated_flashback_size FORMAT 9,999,999,999,999  HEADING 'Estimated Flashback Size' ENTMAP off
  SELECT
      '<div align="right">' || TO_CHAR(begin_time,'mm/dd/yyyy HH24:MI:SS') || '</div>'  begin_time
@@ Line 2506: / Line 2504: @@
  ORDER BY
     begin_time;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 2519: / Line 2517: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Performance</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                             - SGA INFORMATION -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="sga_information"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>SGA Information</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name FORMAT a79                 HEADING 'Instance Name'    ENTMAP off
  COLUMN name          FORMAT a150                HEADING 'Pool Name'        ENTMAP off
  COLUMN value         FORMAT 999,999,999,999,999 HEADING 'Bytes'            ENTMAP off
  BREAK ON report ON instance_name
  COMPUTE sum LABEL '<font color="#990000"><b>Total:</b></font>' OF value ON instance_name
  SELECT
      '<div align="left"><font color="#336699"><b>' || i.instance_name || '</b></font></div>'  instance_name
@@ Line 2553: / Line 2551: @@
      i.instance_name
    , s.value DESC;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - SGA TARGET ADVICE -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="sga_target_advice"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>SGA Target Advice</b></font><hr align="left" width="460">
  prompt Modify the SGA_TARGET parameter (up to the size of the SGA_MAX_SIZE, if necessary) to reduce
  prompt the number of "Estimated Physical Reads".
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name FORMAT a79     HEADING 'Instance Name'    ENTMAP off
  COLUMN name          FORMAT a79     HEADING 'Parameter Name'   ENTMAP off
  COLUMN value         FORMAT a79     HEADING 'Value'            ENTMAP off
  BREAK ON report ON instance_name
  SELECT
      '<div align="left"><font color="#336699"><b>' || i.instance_name || '</b></font></div>'  instance_name
@@ Line 2595: / Line 2593: @@
      i.instance_name
    , p.name;
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name         FORMAT a79                   HEADING 'Instance Name'              ENTMAP off
  COLUMN sga_size              FORMAT 999,999,999,999,999   HEADING 'SGA Size'                   ENTMAP off
@@ Line 2606: / Line 2604: @@
  COLUMN estd_db_time_factor   FORMAT 999,999,999,999,999   HEADING 'Estimated DB Time Factor'   ENTMAP off
  COLUMN estd_physical_reads   FORMAT 999,999,999,999,999   HEADING 'Estimated Physical Reads'   ENTMAP off
  BREAK ON report ON instance_name
  SELECT
      '<div align="left"><font color="#336699"><b>' || i.instance_name || '</b></font></div>'  instance_name
@@ Line 2624: / Line 2622: @@
      i.instance_name
    , s.sga_size_factor;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                      - SGA (ASMM) DYNAMIC COMPONENTS -                     |
  -- +----------------------------------------------------------------------------+
  prompt <a name="sga_asmm_dynamic_components"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>SGA (ASMM) Dynamic Components</b></font><hr align="left" width="460">
  prompt Provides a summary report of all dynamic components as part of the Automatic Shared Memory
  prompt Management (ASMM) configuration. This will display the total real memory allocation for the current
  prompt SGA from the V$SGA_DYNAMIC_COMPONENTS view, which contains both manual and autotuned SGA components.
  prompt As with the other manageability features of Oracle Database 10g, ASMM requires you to set the
  prompt STATISTICS_LEVEL parameter to at least TYPICAL (the default) before attempting to enable ASMM. ASMM
  prompt can be enabled by setting SGA_TARGET to a nonzero value in the initialization parameter file (pfile/spfile).
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name         FORMAT a79                HEADING 'Instance Name'        ENTMAP off
  COLUMN component             FORMAT a79                HEADING 'Component Name'       ENTMAP off
@@ Line 2657: / Line 2655: @@
  COLUMN last_oper_time        FORMAT a75                HEADING 'Last Oper.|Time'      ENTMAP off
  COLUMN granule_size          FORMAT 999,999,999,999    HEADING 'Granule Size'         ENTMAP off
  BREAK ON report ON instance_name
  SELECT
      '<div align="left"><font color="#336699"><b>' || i.instance_name || '</b></font></div>'  instance_name
@@ Line 2678: / Line 2676: @@
      i.instance_name
    , sdc.component DESC;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - PGA TARGET ADVICE -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="pga_target_advice"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>PGA Target Advice</b></font><hr align="left" width="460">
  prompt The <b>V$PGA_TARGET_ADVICE</b> view predicts how the statistics cache hit percentage and over
  prompt allocation count in V$PGASTAT will be impacted if you change the value of the
@@ Line 2705: / Line 2703: @@
  prompt goal is to maximize the PGA cache hit percentage, based on your response-time requirement
  prompt and memory constraints.
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name FORMAT a79     HEADING 'Instance Name'    ENTMAP off
  COLUMN name          FORMAT a79     HEADING 'Parameter Name'   ENTMAP off
  COLUMN value         FORMAT a79     HEADING 'Value'            ENTMAP off
  BREAK ON report ON instance_name
  SELECT
      '<div align="left"><font color="#336699"><b>' || i.instance_name || '</b></font></div>'  instance_name
@@ Line 2731: / Line 2729: @@
      i.instance_name
    , p.name;
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name                  FORMAT a79                   HEADING 'Instance Name'               ENTMAP off
  COLUMN pga_target_for_estimate        FORMAT 999,999,999,999,999   HEADING 'PGA Target for Estimate'     ENTMAP off
@@ Line 2741: / Line 2739: @@
  COLUMN estd_pga_cache_hit_percentage  FORMAT 999,999,999,999,999   HEADING 'Estimated PGA Cache Hit %'   ENTMAP off
  COLUMN estd_overalloc_count           FORMAT 999,999,999,999,999   HEADING 'ESTD_OVERALLOC_COUNT'        ENTMAP off
  BREAK ON report ON instance_name
  SELECT
      '<div align="left"><font color="#336699"><b>' || i.instance_name || '</b></font></div>'  instance_name
@@ Line 2758: / Line 2756: @@
      i.instance_name
    , p.pga_target_for_estimate;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                         - FILE I/O STATISTICS -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="file_io_statistics"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>File I/O Statistics</b></font><hr align="left" width="460">
  prompt <b>Ordered by "Physical Reads" since last startup of the Oracle instance</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN tablespace_name   FORMAT a50                   HEAD 'Tablespace'       ENTMAP off
  COLUMN fname                                          HEAD 'File Name'        ENTMAP off
@@ Line 2782: / Line 2780: @@
  COLUMN write_pct                                      HEAD 'Write Pct.'       ENTMAP off
  COLUMN total_io          FORMAT 999,999,999,999,999   HEAD 'Total I/O'        ENTMAP off
  BREAK ON report
  COMPUTE sum LABEL '<font color="#990000"><b>Total: </b></font>' OF phyrds phywrts total_io ON report
  SELECT
      '<font color="#336699"><b>' || df.tablespace_name || '</b></font>'                      tablespace_name
@@ Line 2818: / Line 2816: @@
      tf.file_id = ts.file#
  ORDER BY phyrds DESC;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - FILE I/O TIMINGS -                             |
  -- +----------------------------------------------------------------------------+
  prompt <a name="file_io_timings"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>File I/O Timings</b></font><hr align="left" width="460">
  prompt <b>Average time (in milliseconds) for an I/O call per datafile since last startup of the Oracle instance - (ordered by Physical Reads)</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN fname                                           HEAD 'File Name'                                      ENTMAP off
  COLUMN phyrds            FORMAT 999,999,999,999,999    HEAD 'Physical Reads'                                 ENTMAP off
@@ Line 2840: / Line 2838: @@
  COLUMN phywrts           FORMAT 999,999,999,999,999    HEAD 'Physical Writes'                                ENTMAP off
  COLUMN write_rate        FORMAT 999,999,999,999,999.99 HEAD 'Average Write Time<br>(milliseconds per write)' ENTMAP off
  BREAK ON REPORT
  COMPUTE sum LABEL '<font color="#990000"><b>Total: </b></font>' OF phyrds phywrts ON report
  COMPUTE avg LABEL '<font color="#990000"><b>Average: </b></font>' OF read_rate write_rate ON report
  SELECT
      '<b><font color="#336699">' || d.name || '</font></b>'  fname
@@ Line 2870: / Line 2868: @@
  ORDER BY
 DESC;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                    - AVERAGE OVERALL I/O PER SECOND -                      |
  -- +----------------------------------------------------------------------------+
  prompt <a name="average_overall_io_per_sec"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Average Overall I/O per Second</b></font><hr align="left" width="460">
  prompt <b>Average overall I/O calls (physical read/write calls) since last startup of the Oracle instance</b>
  CLEAR COLUMNS BREAKS COMPUTES
  DECLARE
  CURSOR get_file_io IS
    SELECT
@@ Line 2901: / Line 2899: @@
    FROM
        v$tempstat b;
  current_time           DATE;
  elapsed_time_seconds   NUMBER;
@@ Line 2912: / Line 2910: @@
  tempfile_io_per_sec    NUMBER;
  total_io_per_sec       NUMBER;
  BEGIN
      OPEN get_file_io;
@@ Line 2923: / Line 2921: @@
        END IF;
      END LOOP;
      total_io := sum_datafile_io2 + sum_tempfile_io2;
      SELECT sysdate INTO current_time FROM dual;
      SELECT CEIL ((current_time - startup_time)*(60*60*24)) INTO elapsed_time_seconds FROM v$instance;
      datafile_io_per_sec := sum_datafile_io2/elapsed_time_seconds;
      tempfile_io_per_sec := sum_tempfile_io2/elapsed_time_seconds;
      total_io_per_sec    := total_io/elapsed_time_seconds;
      DBMS_OUTPUT.PUT_LINE('<table width="90%" border="1">');
      DBMS_OUTPUT.PUT_LINE('<tr><th align="left" width="20%">Elapsed Time (in seconds)</th><td width="80%">' || TO_CHAR(elapsed_time_seconds, '9,999,999,999,999') || '</td></tr>');
      DBMS_OUTPUT.PUT_LINE('<tr><th align="left" width="20%">Datafile I/O Calls per Second</th><td width="80%">' || TO_CHAR(datafile_io_per_sec, '9,999,999,999,999') || '</td></tr>');
      DBMS_OUTPUT.PUT_LINE('<tr><th align="left" width="20%">Tempfile I/O Calls per Second</th><td width="80%">' || TO_CHAR(tempfile_io_per_sec, '9,999,999,999,999') || '</td></tr>');
      DBMS_OUTPUT.PUT_LINE('<tr><th align="left" width="20%">Total I/O Calls per Second</th><td width="80%">' || TO_CHAR(total_io_per_sec, '9,999,999,999,999') || '</td></tr>');
      DBMS_OUTPUT.PUT_LINE('</table>');
  END;
  /
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                        - REDO LOG CONTENTION -                             |
  -- +----------------------------------------------------------------------------+
  prompt <a name="redo_log_contention"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Redo Log Contention</b></font><hr align="left" width="460">
  prompt <b>All latches like redo% - (ordered by misses)</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN name             FORMAT a95                        HEADING 'Latch Name'
  COLUMN gets             FORMAT 999,999,999,999,999,999    HEADING 'Gets'
@@ Line 2965: / Line 2963: @@
  COLUMN immediate_gets   FORMAT 999,999,999,999,999,999    HEADING 'Immediate Gets'
  COLUMN immediate_misses FORMAT 999,999,999,999            HEADING 'Immediate Misses'
  BREAK ON report
  COMPUTE sum LABEL '<font color="#990000"><b>Total:</b></font>' OF gets misses sleeps immediate_gets immediate_misses ON report
  SELECT
      '<div align="left"><font color="#336699"><b>' || INITCAP(name) || '</b></font></div>' name
    , gets
@@ Line 2979: / Line 2977: @@
  WHERE name LIKE 'redo%'
  ORDER BY 1;
  prompt
  prompt <b>System statistics like redo%</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN name    FORMAT a95                   HEADING 'Statistics Name'
  COLUMN value   FORMAT 999,999,999,999,999   HEADING 'Value'
  SELECT
      '<div align="left"><font color="#336699"><b>' || INITCAP(name) || '</b></font></div>' name
@@ Line 2995: / Line 2993: @@
  WHERE name LIKE 'redo%'
  ORDER BY 1;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - FULL TABLE SCANS -                             |
  -- +----------------------------------------------------------------------------+
  prompt <a name="full_table_scans"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Full Table Scans</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN large_table_scans   FORMAT 999,999,999,999,999  HEADING 'Large Table Scans'   ENTMAP off
  COLUMN small_table_scans   FORMAT 999,999,999,999,999  HEADING 'Small Table Scans'   ENTMAP off
  COLUMN pct_large_scans                                 HEADING 'Pct. Large Scans'    ENTMAP off
  SELECT
      a.value large_table_scans
@@ Line 3024: / Line 3022: @@
        a.name = 'table scans (long tables)'
    AND b.name = 'table scans (short tables)';
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                                - SORTS -                                   |
  -- +----------------------------------------------------------------------------+
  prompt <a name="sorts"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Sorts</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN disk_sorts     FORMAT 999,999,999,999,999    HEADING 'Disk Sorts'       ENTMAP off
  COLUMN memory_sorts   FORMAT 999,999,999,999,999    HEADING 'Memory Sorts'     ENTMAP off
  COLUMN pct_disk_sorts                               HEADING 'Pct. Disk Sorts'  ENTMAP off
  SELECT
      a.value   disk_sorts
@@ Line 3053: / Line 3051: @@
        a.name = 'sorts (disk)'
    AND b.name = 'sorts (memory)';
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                               - OUTLINES -                                 |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_outlines"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Outlines</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN category       FORMAT a125    HEADING 'Category'     ENTMAP off
  COLUMN owner          FORMAT a125    HEADING 'Owner'        ENTMAP off
@@ Line 3075: / Line 3073: @@
  COLUMN version                       HEADING 'Version'      ENTMAP off
  COLUMN sql_text                      HEADING 'SQL Text'     ENTMAP off
  SELECT
      '<div nowrap><font color="#336699"><b>' || category || '</b></font></div>' category
@@ Line 3090: / Line 3088: @@
    , owner
    , name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                            - OUTLINE HINTS -                               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_outline_hints"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Outline Hints</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN category       FORMAT a125    HEADING 'Category'        ENTMAP off
  COLUMN owner          FORMAT a125    HEADING 'Owner'           ENTMAP off
@@ Line 3111: / Line 3109: @@
  COLUMN join_pos                      HEADING 'Join Position'   ENTMAP off
  COLUMN hint                          HEADING 'Hint'            ENTMAP off
  BREAK ON category ON owner ON name
  SELECT
      '<div nowrap><font color="#336699"><b>' || a.category || '</b></font></div>' category
@@ Line 3131: / Line 3129: @@
    , owner
    , name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                - SQL STATEMENTS WITH MOST BUFFER GETS -                    |
  -- +----------------------------------------------------------------------------+
  prompt <a name="sql_statements_with_most_buffer_gets"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>SQL Statements With Most Buffer Gets</b></font><hr align="left" width="460">
  prompt <b>Top 100 SQL statements with buffer gets greater than 1000</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN username        FORMAT a75                   HEADING 'Username'                 ENTMAP off
  COLUMN buffer_gets     FORMAT 999,999,999,999,999   HEADING 'Buffer Gets'              ENTMAP off
@@ Line 3153: / Line 3151: @@
  COLUMN gets_per_exec   FORMAT 999,999,999,999,999   HEADING 'Buffer Gets / Execution'  ENTMAP off
  COLUMN sql_text                                     HEADING 'SQL Text'                 ENTMAP off
  SELECT
      '<font color="#336699"><b>' || UPPER(b.username) || '</b></font>' username
    , a.buffer_gets              buffer_gets
@@ Line 3160: / Line 3158: @@
    , (a.buffer_gets / decode(a.executions, 0, 1, a.executions))  gets_per_exec
    , a.sql_text                 sql_text
  FROM
      (SELECT ai.buffer_gets, ai.executions, ai.sql_text, ai.parsing_user_id
       FROM sys.v_$sqlarea ai
@@ Line 3167: / Line 3165: @@
    , dba_users b
  WHERE
        a.parsing_user_id = b.user_id
    AND a.buffer_gets > 1000
    AND b.username NOT IN ('SYS','SYSTEM')
@@ Line 3173: / Line 3171: @@
  ORDER BY
      a.buffer_gets DESC;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                 - SQL STATEMENTS WITH MOST DISK READS -                    |
  -- +----------------------------------------------------------------------------+
  prompt <a name="sql_statements_with_most_disk_reads"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>SQL Statements With Most Disk Reads</b></font><hr align="left" width="460">
  prompt <b>Top 100 SQL statements with disk reads greater than 1000</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN username        FORMAT a75                   HEADING 'Username'           ENTMAP off
  COLUMN disk_reads      FORMAT 999,999,999,999,999   HEADING 'Disk Reads'         ENTMAP off
@@ Line 3195: / Line 3193: @@
  COLUMN reads_per_exec  FORMAT 999,999,999,999,999   HEADING 'Reads / Execution'  ENTMAP off
  COLUMN sql_text                                     HEADING 'SQL Text'           ENTMAP off
  SELECT
      '<font color="#336699"><b>' || UPPER(b.username) || '</b></font>' username
    , a.disk_reads       disk_reads
@@ Line 3202: / Line 3200: @@
    , (a.disk_reads / decode(a.executions, 0, 1, a.executions))  reads_per_exec
    , a.sql_text         sql_text
  FROM
      (SELECT ai.disk_reads, ai.executions, ai.sql_text, ai.parsing_user_id
       FROM sys.v_$sqlarea ai
@@ Line 3209: / Line 3207: @@
    , dba_users b
  WHERE
        a.parsing_user_id = b.user_id
    AND a.disk_reads > 1000
    AND b.username NOT IN ('SYS','SYSTEM')
@@ Line 3215: / Line 3213: @@
  ORDER BY
      a.disk_reads DESC;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 3228: / Line 3226: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Automatic Workload Repository - (AWR)</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                   - WORKLOAD REPOSITORY INFORMATION -                      |
  -- +----------------------------------------------------------------------------+
  prompt <a name="awr_workload_repository_information"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Workload Repository Information</b></font><hr align="left" width="460">
  prompt <b>Instances found in the "Workload Repository"</b>
  prompt <b>The instance running this report (&_instance_name) is indicated in "<font color="darkgreen">GREEN</font>"</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN dbbid          FORMAT a75           HEAD 'Database ID'      ENTMAP off
  COLUMN dbb_name       FORMAT a75           HEAD 'Database Name'    ENTMAP off
@@ Line 3252: / Line 3250: @@
  COLUMN host           FORMAT a75           HEAD 'Host'             ENTMAP off
  COLUMN host_platform  FORMAT a125          HEAD 'Host Platform'    ENTMAP off
  SELECT
      DISTINCT (CASE WHEN cd.dbid = wr.dbid
                          AND
                          cd.name = wr.db_name
                          AND
@@ Line 3275: / Line 3273: @@
  ORDER BY
      wr.instance_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                          - AWR SNAPSHOT SETTINGS -                         |
  -- +----------------------------------------------------------------------------+
  prompt <a name="awr_snapshot_settings"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>AWR Snapshot Settings</b></font><hr align="left" width="460">
  prompt Use the <b>DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS</b> procedure to modify the interval
  prompt of the snapshot generation and how long the snapshots are retained in the Workload Repository. The
@@ Line 3291: / Line 3289: @@
  prompt The default retention period is 10,080 minutes (7 days) and can be set to a value between
  prompt 1,440 minutes (1 day) and 52,560,000 minutes (100 years).
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN dbbid           FORMAT a75    HEAD 'Database ID'          ENTMAP off
  COLUMN dbb_name        FORMAT a75    HEAD 'Database Name'        ENTMAP off
@@ Line 3299: / Line 3297: @@
  COLUMN retention       FORMAT a75    HEAD 'Retention Period'     ENTMAP off
  COLUMN topnsql         FORMAT a75    HEAD 'Top N SQL'            ENTMAP off
  SELECT
      '<div align="left"><font color="#336699"><b>' || s.dbid || '</b></font></div>'  dbbid
@@ Line 3305: / Line 3303: @@
    , s.snap_interval                                                                 snap_interval
    , s.retention                                                                     retention
    , s.topnsql
  FROM
      dba_hist_wr_control   s
@@ Line 3313: / Line 3311: @@
  ORDER BY
      dbbid;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - AWR SNAPSHOT LIST -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="awr_snapshot_list"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>AWR Snapshot List</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name_print  FORMAT a75               HEADING 'Instance Name'          ENTMAP off
  COLUMN snap_id              FORMAT a75               HEADING 'Snap ID'                ENTMAP off
@@ Line 3337: / Line 3335: @@
  COLUMN pct_db_time          FORMAT a75               HEADING '% DB Time'              ENTMAP off
  COLUMN cpu_time             FORMAT 999,999,999.99    HEADING 'CPU Time (min)'         ENTMAP off
  BREAK ON instance_name_print ON startup_time
  SELECT
      '<div align="center"><font color="#336699"><b>' || i.instance_name                                         || '</b></font></div>'  instance_name_print
@@ Line 3351: / Line 3349: @@
            EXTRACT(SECOND FROM s.end_interval_time - s.begin_interval_time) / 60, 2)                                                    elapsed_time
    , ROUND((e.value - b.value)/1000000/60, 2)                                                                                           db_time
    , '<div align="right">' ||
          ROUND(((((e.value - b.value)/1000000/60) / (EXTRACT(DAY FROM  s.end_interval_time - s.begin_interval_time) * 1440 +
                                                      EXTRACT(HOUR FROM s.end_interval_time - s.begin_interval_time) * 60 +
                                                      EXTRACT(MINUTE FROM s.end_interval_time - s.begin_interval_time) +
                                                      EXTRACT(SECOND FROM s.end_interval_time - s.begin_interval_time) / 60) ) * 100), 2)
                               || ' %</div>'                                                                                             pct_db_time
  FROM
@@ Line 3373: / Line 3371: @@
      i.instance_name
    , s.snap_id;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                      - AWR SNAPSHOT SIZE ESTIMATES -                       |
  -- +----------------------------------------------------------------------------+
  prompt <a name="awr_snapshot_size_estimates"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>AWR Snapshot Size Estimates</b></font><hr align="left" width="460">
  DECLARE
      CURSOR get_instances IS
          SELECT COUNT(DISTINCT instance_number)
          FROM wrm$_database_instance;
      CURSOR get_wr_control_info IS
          SELECT snapint_num, retention_num
          FROM wrm$_wr_control;
      CURSOR get_snaps IS
          SELECT
@@ Line 3410: / Line 3408: @@
               FROM wrm$_snapshot s
               );
      CURSOR sysaux_occ_usage IS
          SELECT
@@ Line 3421: / Line 3419: @@
              space_usage_kbytes DESC
            , occupant_name;
      mb_format           CONSTANT  VARCHAR2(30)  := '99,999,990.0';
      kb_format           CONSTANT  VARCHAR2(30)  := '999,999,990';
@@ Line 3437: / Line 3435: @@
      num_days            NUMBER;
      num_instances       NUMBER;
  BEGIN
      OPEN get_instances;
      FETCH get_instances INTO num_instances;
      CLOSE get_instances;
      OPEN get_wr_control_info;
      FETCH get_wr_control_info INTO snapshot_interval, retention_interval;
      CLOSE get_wr_control_info;
      OPEN get_snaps;
      FETCH get_snaps INTO all_snaps, good_snaps, today_snaps, num_days;
      CLOSE get_snaps;
      FOR occ_rec IN sysaux_occ_usage
      LOOP
@@ Line 3458: / Line 3456: @@
          END IF;
      END LOOP;
      snap_size := awr_size/all_snaps;
      awr_average_size := snap_size*86400/snapshot_interval;
      today_snaps := today_snaps / num_instances;
      IF (num_days < 1) THEN
          est_today_snaps := ROUND(today_snaps / num_days);
@@ Line 3469: / Line 3467: @@
          est_today_snaps := today_snaps;
      END IF;
      awr_size_past24 := snap_size * est_today_snaps;
      DBMS_OUTPUT.PUT_LINE('<table width="90%" border="1">');
      DBMS_OUTPUT.PUT_LINE('<tr><th align="center" colspan="3">Estimates based on ' || ROUND(snapshot_interval/60) || ' minute snapshot intervals</th></tr>');
      DBMS_OUTPUT.PUT_LINE('<tr><td>AWR size/day</td><td align="right">'
@@ Line 3487: / Line 3485: @@
                              || ' MB</td><td align="right">(size_per_day * 7) per database</td></tr>' );
      END IF;
      DBMS_OUTPUT.PUT_LINE('<tr><th align="center" colspan="3">Estimates based on ' || ROUND(today_snaps) || ' snaps in past 24 hours</th></tr>');
      DBMS_OUTPUT.PUT_LINE('<tr><td>AWR size/day</td><td align="right">'
                              || TO_CHAR(awr_size_past24, mb_format)
@@ Line 3504: / Line 3502: @@
                              || ' MB</td><td align="right">(size_per_day * 7) per database</td></tr>' );
      END IF;
      DBMS_OUTPUT.PUT_LINE('</table>');
  END;
  /
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                              - AWR BASELINES -                             |
  -- +----------------------------------------------------------------------------+
  prompt <a name="awr_baselines"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>AWR Baselines</b></font><hr align="left" width="460">
  prompt Use the <b>DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE</b> procedure to create a named baseline.
  prompt A baseline (also known as a preserved snapshot set) is a pair of AWR snapshots that represents a
  prompt specific period of database usage. The Oracle database server will exempt the AWR snapshots
  prompt assigned to a specific baseline from the automated purge routine. The main purpose of a baseline
  prompt is to preserve typical run-time statistics in the AWR repository which can then be compared to
  prompt current performance or similar periods in the past.
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN dbbid            FORMAT a75    HEAD 'Database ID'              ENTMAP off
  COLUMN dbb_name         FORMAT a75    HEAD 'Database Name'            ENTMAP off
@@ Line 3539: / Line 3537: @@
  COLUMN end_snap_id                    HEAD 'Ending Snapshot ID'       ENTMAP off
  COLUMN end_snap_time    FORMAT a75    HEAD 'Ending Snapshot Time'     ENTMAP off
  SELECT
      '<div align="left"><font color="#336699"><b>' || b.dbid || '</b></font></div>'  dbbid
@@ Line 3557: / Line 3555: @@
      dbbid
    , b.baseline_id;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 3570: / Line 3568: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Sessions</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                          - CURRENT SESSIONS -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name="current_sessions"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Current Sessions</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name_print  FORMAT a45    HEADING 'Instance Name'              ENTMAP off
  COLUMN thread_number_print  FORMAT a45    HEADING 'Thread Number'              ENTMAP off
@@ Line 3590: / Line 3588: @@
  COLUMN value                FORMAT a45    HEADING 'Max No. of Processes'       ENTMAP off
  COLUMN pct_usage            FORMAT a45    HEADING '% Usage'                    ENTMAP off
  SELECT
      '<div align="center"><font color="#336699"><b>' || a.instance_name  || '</b></font></div>'  instance_name_print
@@ Line 3610: / Line 3608: @@
  ORDER BY
      a.instance_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                        - USER SESSION MATRIX -                             |
  -- +----------------------------------------------------------------------------+
  prompt <a name="user_session_matrix"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>User Session Matrix</b></font><hr align="left" width="460">
  prompt <b>User sessions (excluding SYS and background processes)</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name_print  FORMAT a75               HEADING 'Instance Name'            ENTMAP off
  COLUMN thread_number_print  FORMAT a75               HEADING 'Thread Number'            ENTMAP off
@@ Line 3634: / Line 3632: @@
  COLUMN count_i              FORMAT 999,999,999       HEADING 'Inactive Logins'          ENTMAP off
  COLUMN count_k              FORMAT 999,999,999       HEADING 'Killed Logins'            ENTMAP off
  BREAK ON report ON instance_name_print ON thread_number_print
  SELECT
      '<div align="center"><font color="#336699"><b>' || i.instance_name || '</b></font></div>'                      instance_name_print
    , '<div align="center"><font color="#336699"><b>' || i.thread#       || '</b></font></div>'                      thread_number_print
-   , '<div align="left"><font color="#000000">' || NVL(sess.username, '[B.G. Process]') || '</font></div>' username
+   , '<div align="left"><font color="#000000">' || NVL(sess.username, '[[B.G. Process]]') || '</font></div>' username
    , count(*)              num_user_sess
    , NVL(act.count, 0)     count_a
    , NVL(inact.count, 0)   count_i
    , NVL(killed.count, 0)  count_k
  FROM
      gv$session                        sess
    , gv$instance                       i
-   , (SELECT    count(*) count, NVL(username, '[B.G. Process]') username, inst_id
+   , (SELECT    count(*) count, NVL(username, '[[B.G. Process]]') username, inst_id
       FROM      gv$session
       WHERE     status = 'ACTIVE'
       GROUP BY  username, inst_id)              act
-   , (SELECT    count(*) count, NVL(username, '[B.G. Process]') username, inst_id
+   , (SELECT    count(*) count, NVL(username, '[[B.G. Process]]') username, inst_id
       FROM      gv$session
       WHERE     status = 'INACTIVE'
       GROUP BY  username, inst_id)              inact
-   , (SELECT    count(*) count, NVL(username, '[B.G. Process]') username, inst_id
+   , (SELECT    count(*) count, NVL(username, '[[B.G. Process]]') username, inst_id
       FROM      gv$session
       WHERE     status = 'KILLED'
@@ Line 3663: / Line 3661: @@
           sess.inst_id                         = i.inst_id
       AND (
-            NVL(sess.username, '[B.G. Process]') = act.username (+)
+            NVL(sess.username, '[[B.G. Process]]') = act.username (+)
             AND
             sess.inst_id  = act.inst_id (+)
           )
       AND (
-            NVL(sess.username, '[B.G. Process]') = inact.username (+)
+            NVL(sess.username, '[[B.G. Process]]') = inact.username (+)
             AND
             sess.inst_id  = inact.inst_id (+)
           )
       AND (
-            NVL(sess.username, '[B.G. Process]') = killed.username (+)
+            NVL(sess.username, '[[B.G. Process]]') = killed.username (+)
             AND
             sess.inst_id  = killed.inst_id (+)
@@ Line 3689: / Line 3687: @@
    , i.thread#
    , sess.username;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                            - ENABLED TRACES -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_enabled_traces"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Enabled Traces</b></font><hr align="left" width="460">
  prompt <b><u>End-to-End Application Tracing from View DBA_ENABLED_TRACES.</u></b>
  prompt   <li> <b>Trace Type:</b> Possible values are CLIENT_ID, SESSION, SERVICE, SERVICE_MODULE, SERVICE_MODULE_ACTION, and DATABASE, based on the type of tracing enabled.
  prompt   <li> <b>Primary ID:</b> Specific client identifier (username) or service name.
  prompt <p>
  prompt <b><u>Application tracing is enabled using the DBMS_MONITOR package and the following procedures:</u></b>
  prompt   <li> <b>CLIENT_ID_TRACE_ENABLE:</b> Enable tracing based on client identifier (username).
@@ Line 3718: / Line 3716: @@
  prompt   <li> <b>DATABASE_TRACE_DISABLE:</b> Disable database tracing.
  prompt <p>
- prompt <b><font color="#ff0000">Hint</font>:</b> In a shared environment where you have more than one session to trace, it is
+ prompt <b><font color="#ff0000">Hint</font>></b> In a shared environment where you have more than one session to trace, it is
  prompt possible to end up with many trace files when tracing is enabled (i.e. connection pools).
  prompt Oracle10<i>g</i> introduces the <b>trcsess</b> command-line utility to combine all the relevant
@@ Line 3726: / Line 3724: @@
  prompt sent to tkprof for a formatted output. Type trcsess at the command-line without any arguments to
  prompt show the parameters and usage.
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN trace_type           FORMAT a75    HEADING 'Trace Type'         ENTMAP off
  COLUMN primary_id           FORMAT a75    HEADING 'Primary ID'         ENTMAP off
@@ Line 3736: / Line 3734: @@
  COLUMN binds                FORMAT a75    HEADING 'Binds?'             ENTMAP off
  COLUMN instance_name_print  FORMAT a75    HEADING 'Instance Name'      ENTMAP off
  SELECT
      '<div align="left"><font color="#336699"><b>'   || trace_type                 || '</b></font></div>' trace_type
@@ Line 3752: / Line 3750: @@
    , qualifier_id1
    , qualifier_id2;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                         - ENABLED AGGREGATIONS -                           |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_enabled_aggregations"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Enabled Aggregations</b></font><hr align="left" width="460">
  prompt <b><u>Statistics Aggregation from View DBA_ENABLED_AGGREGATIONS.</u></b>
  prompt   <li> <b>Aggregation Type:</b> Possible values are CLIENT_ID, SERVICE_MODULE, and SERVICE_MODULE_ACTION, based on the type of statistics being gathered.
  prompt   <li> <b>Primary ID:</b> Specific client identifier (username) or service name.
  prompt <p>
  prompt <b><u>Statistics aggregation is enabled using the DBMS_MONITOR package and the following procedures.</u></b>
  prompt Note that statistics gathering is global for the database and is persistent across instance starts
@@ Line 3778: / Line 3776: @@
  prompt   <li> <b>SERV_MOD_ACT_STAT_DISABLE:</b> Disable service, module, and action statistics gathering.
  prompt <p>
- prompt <b><font color="#ff0000">Hint</font>:</b> While the DBA_ENABLED_AGGREGATIONS provides global statistics for currently enabled
+ prompt <b><font color="#ff0000">Hint</font>></b> While the DBA_ENABLED_AGGREGATIONS provides global statistics for currently enabled
  prompt statistics, several other views can be used to query statistics aggregation values: V$CLIENT_STATS,
  prompt V$SERVICE_STATS, V$SERV_MOD_ACT_STATS, and V$SERVICEMETRIC.
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN aggregation_type     FORMAT a75    HEADING 'Aggregation Type'   ENTMAP off
  COLUMN primary_id           FORMAT a75    HEADING 'Primary ID'         ENTMAP off
  COLUMN qualifier_id1        FORMAT a75    HEADING 'Module Name'        ENTMAP off
  COLUMN qualifier_id2        FORMAT a75    HEADING 'Action Name'        ENTMAP off
  SELECT
      '<div align="left"><font color="#336699"><b>'   || aggregation_type           || '</b></font></div>' aggregation_type
@@ Line 3802: / Line 3800: @@
    , qualifier_id1
    , qualifier_id2;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 3815: / Line 3813: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Security</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                             - USER ACCOUNTS -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name="user_accounts"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>User Accounts</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN username              FORMAT a75    HEAD 'Username'        ENTMAP off
  COLUMN account_status        FORMAT a75    HEAD 'Account Status'  ENTMAP off
@@ Line 3839: / Line 3837: @@
  COLUMN sysdba                FORMAT a75    HEAD 'SYSDBA'          ENTMAP off
  COLUMN sysoper               FORMAT a75    HEAD 'SYSOPER'         ENTMAP off
  SELECT distinct
      '<b><font color="#336699">' || a.username || '</font></b>'                                            username
@@ Line 3851: / Line 3849: @@
    , '<div nowrap align="right">' || TO_CHAR(a.created, 'mm/dd/yyyy HH24:MI:SS') || '</div>'               created
    , a.profile                                        profile
-   , '<div nowrap align="center">' || NVL(DECODE(p.sysdba,'TRUE', 'TRUE',''), '<br>') || '</div>'   sysdba
+   , '<div nowrap align="center">' || NVL(DECODE(p.sysdba,'TRUE', 'TRUE',//), '<br>') || '</div>'   sysdba
-   , '<div nowrap align="center">' || NVL(DECODE(p.sysoper,'TRUE','TRUE',''), '<br>') || '</div>'   sysoper
+   , '<div nowrap align="center">' || NVL(DECODE(p.sysoper,'TRUE','TRUE',//), '<br>') || '</div>'   sysoper
  FROM
      dba_users       a
    , v$pwfile_users  p
  WHERE
      p.username (+) = a.username
  ORDER BY
      username;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                      - USERS WITH DBA PRIVILEGES -                         |
  -- +----------------------------------------------------------------------------+
  prompt <a name="users_with_dba_privileges"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Users With DBA Privileges</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN grantee        FORMAT a70   HEADING 'Grantee'         ENTMAP off
  COLUMN granted_role   FORMAT a35   HEADING 'Granted Role'    ENTMAP off
  COLUMN admin_option   FORMAT a75   HEADING 'Admin. Option?'  ENTMAP off
  COLUMN default_role   FORMAT a75   HEADING 'Default Role?'   ENTMAP off
  SELECT
      '<b><font color="#336699">' || grantee       || '</font></b>'  grantee
@@ Line 3902: / Line 3900: @@
      grantee
    , granted_role;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                                 - ROLES -                                  |
  -- +----------------------------------------------------------------------------+
  prompt <a name="roles"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Roles</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN role             FORMAT a70    HEAD 'Role Name'       ENTMAP off
  COLUMN grantee          FORMAT a35    HEAD 'Grantee'         ENTMAP off
  COLUMN admin_option     FORMAT a75    HEAD 'Admin Option?'   ENTMAP off
  COLUMN default_role     FORMAT a75    HEAD 'Default Role?'   ENTMAP off
  BREAK ON role
  SELECT
     '<b><font color="#336699">' ||  b.role         || '</font></b>'          role
@@ Line 3951: / Line 3949: @@
      b.role
    , a.grantee;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                          - DEFAULT PASSWORDS -                             |
  -- +----------------------------------------------------------------------------+
  prompt <a name="default_passwords"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Default Passwords</b></font><hr align="left" width="460">
  prompt <b>User(s) with default password</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN username                      HEADING 'Username'        ENTMAP off
  COLUMN account_status   FORMAT a75   HEADING 'Account Status'  ENTMAP off
  SELECT
      '<b><font color="#336699">' || username        || '</font></b>'        username
@@ Line 4002: / Line 4000: @@
  ORDER BY
      username;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                              - DB LINKS -                                  |
  -- +----------------------------------------------------------------------------+
  prompt <a name="db_links"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>DB Links</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner        FORMAT a75    HEADING 'Owner'           ENTMAP off
  COLUMN db_link      FORMAT a75    HEADING 'DB Link Name'    ENTMAP off
@@ Line 4022: / Line 4020: @@
  COLUMN host                       HEADING 'Host'            ENTMAP off
  COLUMN created      FORMAT a75    HEADING 'Created'         ENTMAP off
  BREAK ON owner
  SELECT
      '<b><font color="#336699">' || owner || '</font></b>'  owner
@@ Line 4033: / Line 4031: @@
  FROM dba_db_links
  ORDER BY owner, db_link;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 4046: / Line 4044: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Objects</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                            - OBJECT SUMMARY -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name="object_summary"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Object Summary</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner           FORMAT a60               HEADING 'Owner'           ENTMAP off
  COLUMN object_type     FORMAT a25               HEADING 'Object Type'     ENTMAP off
  COLUMN obj_count       FORMAT 999,999,999,999   HEADING 'Object Count'    ENTMAP off
  BREAK ON report ON owner SKIP 2
  -- compute sum label ""               of obj_count on owner
  -- compute sum label '<font color="#990000"><b>Grand Total: </b></font>' of obj_count on report
  COMPUTE sum LABEL '<font color="#990000"><b>Total: </b></font>' OF obj_count ON report
  SELECT
      '<b><font color="#336699">' || owner || '</font></b>'  owner
@@ Line 4082: / Line 4080: @@
      owner
    , object_type;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                          - SEGMENT SUMMARY -                               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="segment_summary"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Segment Summary</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner           FORMAT a50                    HEADING 'Owner'             ENTMAP off
  COLUMN segment_type    FORMAT a25                    HEADING 'Segment Type'      ENTMAP off
  COLUMN seg_count       FORMAT 999,999,999,999        HEADING 'Segment Count'     ENTMAP off
  COLUMN bytes           FORMAT 999,999,999,999,999    HEADING 'Size (in Bytes)'   ENTMAP off
  BREAK ON report ON owner SKIP 2
  -- COMPUTE sum LABEL ""                                                  OF seg_count bytes ON owner
  COMPUTE sum LABEL '<font color="#990000"><b>Total: </b></font>' OF seg_count bytes ON report
  SELECT
      '<b><font color="#336699">' || owner || '</font></b>'  owner
@@ Line 4119: / Line 4117: @@
      owner
    , segment_type;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                    - TOP 100 SEGMENTS (BY SIZE) -                          |
  -- +----------------------------------------------------------------------------+
  prompt <a name="top_100_segments_by_size"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Top 100 Segments (by size)</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner                                               HEADING 'Owner'            ENTMAP off
  COLUMN segment_name                                        HEADING 'Segment Name'     ENTMAP off
@@ Line 4141: / Line 4139: @@
  COLUMN bytes               FORMAT 999,999,999,999,999,999  HEADING 'Size (in bytes)'  ENTMAP off
  COLUMN extents             FORMAT 999,999,999,999,999,999  HEADING 'Extents'          ENTMAP off
  BREAK ON report
  COMPUTE sum LABEL '<font color="#990000"><b>Total: </b></font>' OF bytes extents ON report
  SELECT
      a.owner
@@ Line 4169: / Line 4167: @@
  WHERE
      rownum < 100;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                      - TOP 100 SEGMENTS (BY EXTENTS) -                     |
  -- +----------------------------------------------------------------------------+
  prompt <a name="top_100_segments_by_extents"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Top 100 Segments (by number of extents)</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner                                               HEADING 'Owner'            ENTMAP off
  COLUMN segment_name                                        HEADING 'Segment Name'     ENTMAP off
@@ Line 4191: / Line 4189: @@
  COLUMN extents             FORMAT 999,999,999,999,999,999  HEADING 'Extents'          ENTMAP off
  COLUMN bytes               FORMAT 999,999,999,999,999,999  HEADING 'Size (in bytes)'  ENTMAP off
  BREAK ON report
  COMPUTE sum LABEL '<font color="#990000"><b>Total: </b></font>' OF extents bytes ON report
  SELECT
      a.owner
@@ Line 4219: / Line 4217: @@
  WHERE
      rownum < 100;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - DIRECTORIES -                                  |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_directories"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Directories</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner             FORMAT a75  HEADING 'Owner'             ENTMAP off
  COLUMN directory_name    FORMAT a75  HEADING 'Directory Name'    ENTMAP off
  COLUMN directory_path                HEADING 'Directory Path'    ENTMAP off
  BREAK ON report ON owner
  SELECT
      '<div align="left"><font color="#336699"><b>' || owner          || '</b></font></div>'  owner
@@ Line 4249: / Line 4247: @@
      owner
    , directory_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                        - DIRECTORY PRIVILEGES -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_directory_privileges"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Directory Privileges</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN table_name    FORMAT a75      HEADING 'Directory Name'    ENTMAP off
  COLUMN grantee       FORMAT a75      HEADING 'Grantee'           ENTMAP off
  COLUMN privilege     FORMAT a75      HEADING 'Privilege'         ENTMAP off
  COLUMN grantable     FORMAT a75      HEADING 'Grantable?'        ENTMAP off
  BREAK ON report ON table_name ON grantee
  SELECT
      '<b><font color="#336699">' || table_name || '</font></b>'  table_name
@@ Line 4289: / Line 4287: @@
    , grantee
    , privilege;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                             - LIBRARIES -                                  |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_libraries"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Libraries</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner          FORMAT a75    HEADING 'Owner'             ENTMAP off
  COLUMN library_name   FORMAT a75    HEADING 'Library Name'      ENTMAP off
@@ Line 4309: / Line 4307: @@
  COLUMN dynamic        FORMAT a75    HEADING 'Dynamic?'          ENTMAP off
  COLUMN status         FORMAT a75    HEADING 'Status'            ENTMAP off
  BREAK ON report ON owner
  SELECT
      '<div align="left"><font color="#336699"><b>' || owner           || '</b></font></div>'  owner
@@ Line 4326: / Line 4324: @@
      owner
    , library_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                               - TYPES -                                    |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_types"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Types</b></font><hr align="left" width="460">
  prompt <b>Excluding all internal system schemas (i.e. CTXSYS, MDSYS, SYS, SYSTEM)</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner              FORMAT a75        HEADING 'Owner'              ENTMAP off
  COLUMN type_name          FORMAT a75        HEADING 'Type Name'          ENTMAP off
@@ Line 4356: / Line 4354: @@
  COLUMN local_attributes   FORMAT a75        HEADING 'Local Attributes'   ENTMAP off
  COLUMN local_methods      FORMAT a75        HEADING 'Local Methods'      ENTMAP off
  BREAK ON report ON owner
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || t.owner || '</b></font></div>'    owner
@@ Line 4395: / Line 4393: @@
      t.owner
    , t.type_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - TYPE ATTRIBUTES -                              |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_type_attributes"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Type Attributes</b></font><hr align="left" width="460">
  prompt <b>Excluding all internal system schemas (i.e. CTXSYS, MDSYS, SYS, SYSTEM)</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner                FORMAT a75        HEADING 'Owner'                ENTMAP off
  COLUMN type_name            FORMAT a75        HEADING 'Type Name'            ENTMAP off
@@ Line 4418: / Line 4416: @@
  COLUMN attribute_datatype   FORMAT a75        HEADING 'Attribute Data Type'  ENTMAP off
  COLUMN inherited            FORMAT a75        HEADING 'Inherited?'           ENTMAP off
  BREAK ON report ON owner ON type_name ON typecode
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || t.owner || '</b></font></div>'    owner
@@ Line 4469: / Line 4467: @@
    , t.typecode
    , a.attr_no;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                             - TYPE METHODS -                               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_type_methods"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Type Methods</b></font><hr align="left" width="460">
  prompt <b>Excluding all internal system schemas (i.e. CTXSYS, MDSYS, SYS, SYSTEM)</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner              FORMAT a75        HEADING 'Owner'              ENTMAP off
  COLUMN type_name          FORMAT a75        HEADING 'Type Name'          ENTMAP off
@@ Line 4497: / Line 4495: @@
  COLUMN overriding         FORMAT a75        HEADING 'Overriding?'        ENTMAP off
  COLUMN inherited          FORMAT a75        HEADING 'Inherited?'         ENTMAP off
  BREAK ON report ON owner ON type_name ON typecode
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || t.owner || '</b></font></div>'    owner
@@ Line 4544: / Line 4542: @@
    , t.typecode
    , m.method_no;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                              - COLLECTIONS -                               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_collections"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Collections</b></font><hr align="left" width="460">
  prompt <b>Excluding all internal system schemas (i.e. CTXSYS, MDSYS, SYS, SYSTEM)</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner                FORMAT a75        HEADING 'Owner'              ENTMAP off
  COLUMN type_name            FORMAT a75        HEADING 'Type Name'          ENTMAP off
@@ Line 4570: / Line 4568: @@
  COLUMN elem_storage         FORMAT a75        HEADING 'Element Storage'    ENTMAP off
  COLUMN nulls_stored         FORMAT a75        HEADING 'Nulls Stored?'      ENTMAP off
  BREAK ON report ON owner ON type_name
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || c.owner || '</b></font></div>'    owner
@@ Line 4619: / Line 4617: @@
      c.owner
    , c.type_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                           - LOB SEGMENTS -                                 |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_lob_segments"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>LOB Segments</b></font><hr align="left" width="460">
  prompt <b>Excluding all internal system schemas (i.e. CTXSYS, MDSYS, SYS, SYSTEM)</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner              FORMAT a85        HEADING 'Owner'              ENTMAP off
  COLUMN table_name         FORMAT a75        HEADING 'Table Name'         ENTMAP off
@@ Line 4644: / Line 4642: @@
  COLUMN index_name         FORMAT a125       HEADING 'LOB Index Name'     ENTMAP off
  COLUMN in_row             FORMAT a75        HEADING 'In Row?'            ENTMAP off
  BREAK ON report ON owner ON table_name
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || l.owner || '</b></font></div>'    owner
@@ Line 4687: / Line 4685: @@
    , l.table_name
    , l.column_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                      - OBJECTS UNABLE TO EXTEND -                          |
  -- +----------------------------------------------------------------------------+
  prompt <a name="objects_unable_to_extend"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Objects Unable to Extend</b></font><hr align="left" width="460">
  prompt <b>Segments that cannot extend because of MAXEXTENTS or not enough space</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner             FORMAT a75                  HEADING 'Owner'            ENTMAP off
  COLUMN tablespace_name                               HEADING 'Tablespace Name'  ENTMAP off
@@ Line 4713: / Line 4711: @@
  COLUMN extents           FORMAT 999,999,999,999,999  HEADING 'Num. of Extents'  ENTMAP off
  COLUMN max_extents       FORMAT 999,999,999,999,999  HEADING 'Max Extents'      ENTMAP off
  BREAK ON report ON owner
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || ds.owner || '</b></font></div>'    owner
@@ Line 4726: / Line 4724: @@
    , ds.extents            extents
    , ds.max_extents        max_extents
  FROM
      dba_segments ds
    , (select
@@ Line 4733: / Line 4731: @@
         , tablespace_name
       from
           dba_free_space
       group by
           tablespace_name
@@ Line 4747: / Line 4745: @@
    , ds.tablespace_name
    , ds.segment_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |               - OBJECTS WHICH ARE NEARING MAXEXTENTS -                     |
  -- +----------------------------------------------------------------------------+
  prompt <a name="objects_which_are_nearing_maxextents"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Objects Which Are Nearing MAXEXTENTS</b></font><hr align="left" width="460">
  prompt <b>Segments where number of EXTENTS is less than 1/2 of MAXEXTENTS</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner             FORMAT a75                   HEADING 'Owner'             ENTMAP off
  COLUMN tablespace_name   FORMAT a30                   HEADING 'Tablespace name'   ENTMAP off
@@ Line 4774: / Line 4772: @@
  COLUMN max_extents       FORMAT 999,999,999,999,999   HEADING 'Max Extents'       ENTMAP off
  COLUMN pct_util          FORMAT a35                   HEADING '% Utilized'        ENTMAP off
  SELECT
      owner
@@ Line 4793: / Line 4791: @@
  ORDER BY
      (extents/max_extents) DESC;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                          - INVALID OBJECTS -                               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="invalid_objects"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Invalid Objects</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner           FORMAT a85         HEADING 'Owner'         ENTMAP off
  COLUMN object_name     FORMAT a30         HEADING 'Object Name'   ENTMAP off
  COLUMN object_type     FORMAT a20         HEADING 'Object Type'   ENTMAP off
  COLUMN status          FORMAT a75         HEADING 'Status'        ENTMAP off
  BREAK ON report ON owner
  COMPUTE count LABEL '<font color="#990000"><b>Grand Total: </b></font>' OF object_name ON report
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || owner || '</b></font></div>'    owner
@@ Line 4829: / Line 4827: @@
      owner
    , object_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                     - PROCEDURAL OBJECT ERRORS -                           |
  -- +----------------------------------------------------------------------------+
  prompt <a name="procedural_object_errors"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Procedural Object Errors</b></font><hr align="left" width="460">
  prompt <b>All records from DBA_ERRORS</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner                FORMAT a85      HEAD 'Schema'        ENTMAP off
  COLUMN name                 FORMAT a30      HEAD 'Object Name'   ENTMAP off
@@ Line 4853: / Line 4851: @@
  COLUMN position             FORMAT 999,999  HEAD 'Position'      ENTMAP off
  COLUMN text                                 HEAD 'Text'          ENTMAP off
  BREAK ON report ON owner
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || owner || '</b></font></div>'    owner
@@ Line 4870: / Line 4868: @@
    , 2
    , 3;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                     - OBJECTS WITHOUT STATISTICS -                         |
  -- +----------------------------------------------------------------------------+
  prompt <a name="objects_without_statistics"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Objects Without Statistics</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner            FORMAT a95                HEAD 'Owner'            ENTMAP off
  COLUMN object_type      FORMAT a20                HEAD 'Object Type'      ENTMAP off
  COLUMN count            FORMAT 999,999,999,999    HEAD 'Count'            ENTMAP off
  BREAK ON report ON owner
  COMPUTE count LABEL '<font color="#990000"><b>Total: </b></font>' OF object_name ON report
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || owner || '</b></font></div>'        owner
@@ Line 4897: / Line 4895: @@
    , count(*)                                                                                    count
  FROM
      sys.dba_tables
  WHERE
        last_analyzed IS NULL
    AND owner NOT IN ('SYS','SYSTEM')
    AND partitioned = 'NO'
  GROUP BY
      owner
    , 'Table'
  UNION
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || owner || '</b></font></div>'        owner
@@ Line 4911: / Line 4909: @@
    , count(*)                                                                                    count
  FROM
      sys.dba_indexes
  WHERE
        last_analyzed IS NULL
    AND owner NOT IN ('SYS','SYSTEM')
    AND partitioned = 'NO'
  GROUP BY
      owner
    , 'Index'
  UNION
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || table_owner || '</b></font></div>'  owner
@@ Line 4925: / Line 4923: @@
    , count(*)                                                                                    count
  FROM
      sys.dba_tab_partitions
  WHERE
        last_analyzed IS NULL
    AND table_owner NOT IN ('SYS','SYSTEM')
  GROUP BY
      table_owner
    , 'Table Partition'
  UNION
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || index_owner || '</b></font></div>'  owner
@@ Line 4938: / Line 4936: @@
    , count(*)                                                                                    count
  FROM
      sys.dba_ind_partitions
  WHERE
        last_analyzed IS NULL
    AND index_owner NOT IN ('SYS','SYSTEM')
  GROUP BY
@@ Line 4949: / Line 4947: @@
    , 2
    , 3;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |           - TABLES SUFFERING FROM ROW CHAINING/MIGRATION -                 |
  -- +----------------------------------------------------------------------------+
  prompt <a name="tables_suffering_from_row_chaining_migration"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Tables Suffering From Row Chaining/Migration</b></font><hr align="left" width="460">
- prompt <b><font color="#990000">NOTE</font>: Tables must have statistics gathered</b>
+ prompt <b><font color="#990000">NOTE</font>> Tables must have statistics gathered</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner                                          HEADING 'Owner'           ENTMAP off
  COLUMN table_name                                     HEADING 'Table Name'      ENTMAP off
@@ Line 4972: / Line 4970: @@
  COLUMN pct_chained_rows   FORMAT a65                  HEADING '% Chained Rows'  ENTMAP off
  COLUMN avg_row_length     FORMAT 999,999,999,999,999  HEADING 'Avg Row Length'  ENTMAP off
  SELECT
      owner                               owner
    , table_name                          table_name
-   , ''                                  partition_name
+   , //                                  partition_name
    , num_rows                            num_rows
    , '<div align="right">' || ROUND((chain_cnt/num_rows)*100, 2) || '%</div>' pct_chained_rows
@@ Line 4986: / Line 4984: @@
         , chain_cnt
         , num_rows
         , avg_row_len
       from
           sys.dba_tables
       where
             chain_cnt is not null
         and num_rows is not null
         and chain_cnt > 0
         and num_rows > 0
         and owner != 'SYS')
  UNION ALL
  SELECT
      table_owner                         owner
@@ Line 5010: / Line 5008: @@
         , chain_cnt
         , num_rows
         , avg_row_len
       from
           sys.dba_tab_partitions
       where
             chain_cnt is not null
         and num_rows is not null
         and chain_cnt > 0
         and num_rows > 0
         and table_owner != 'SYS') b
  WHERE
      (chain_cnt/num_rows)*100 > 10;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |             - USERS WITH DEFAULT TABLESPACE - (SYSTEM) -                   |
  -- +----------------------------------------------------------------------------+
  prompt <a name="users_with_default_tablespace_defined_as_system"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Users With Default Tablespace - (SYSTEM)</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN username                 FORMAT a75    HEADING 'Username'                ENTMAP off
  COLUMN default_tablespace       FORMAT a125   HEADING 'Default Tablespace'      ENTMAP off
@@ Line 5041: / Line 5039: @@
  COLUMN created                  FORMAT a75    HEADING 'Created'                 ENTMAP off
  COLUMN account_status           FORMAT a75    HEADING 'Account Status'          ENTMAP off
  SELECT
      '<font color="#336699"><b>' || username             || '</font></b>'                  username
@@ Line 5057: / Line 5055: @@
  ORDER BY
      username;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |          - USERS WITH DEFAULT TEMPORARY TABLESPACE - (SYSTEM) -            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="users_with_default_temporary_tablespace_as_system"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Users With Default Temporary Tablespace - (SYSTEM)</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN username                 FORMAT a75    HEADING 'Username'                ENTMAP off
  COLUMN default_tablespace       FORMAT a125   HEADING 'Default Tablespace'      ENTMAP off
@@ Line 5077: / Line 5075: @@
  COLUMN created                  FORMAT a75    HEADING 'Created'                 ENTMAP off
  COLUMN account_status           FORMAT a75    HEADING 'Account Status'          ENTMAP off
  SELECT
      '<font color="#336699"><b>'  || username             || '</font></b>'                  username
@@ Line 5093: / Line 5091: @@
  ORDER BY
      username;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                  - OBJECTS IN THE SYSTEM TABLESPACE -                      |
  -- +----------------------------------------------------------------------------+
  prompt <a name="objects_in_the_system_tablespace"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Objects in the SYSTEM Tablespace</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner               FORMAT a75                   HEADING 'Owner'           ENTMAP off
  COLUMN segment_name        FORMAT a125                  HEADING 'Segment Name'    ENTMAP off
@@ Line 5118: / Line 5116: @@
  COLUMN next_extent         FORMAT 999,999,999,999,999   HEADING 'Next|Ext'        ENTMAP off
  COLUMN pct_increase        FORMAT 999,999,999,999,999   HEADING 'Pct|Inc'         ENTMAP off
  BREAK ON report ON owner
  COMPUTE count LABEL '<font color="#990000"><b>Total Count: </b></font>' OF segment_name ON report
  COMPUTE sum   LABEL '<font color="#990000"><b>Total Bytes: </b></font>' OF bytes ON report
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || owner || '</b></font></div>'    owner
@@ Line 5142: / Line 5140: @@
    , segment_name
    , extents DESC;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                              - RECYCLE BIN -                               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_recycle_bin"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Recycle Bin</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner               FORMAT a85                   HEADING 'Owner'           ENTMAP off
  COLUMN original_name                                    HEADING 'Original|Name'   ENTMAP off
@@ Line 5168: / Line 5166: @@
  COLUMN can_purge                                        HEADING 'Can|Purge?'      ENTMAP off
  COLUMN bytes               FORMAT 999,999,999,999,999   HEADING 'Bytes'           ENTMAP off
  BREAK ON report ON owner
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || owner || '</b></font></div>'    owner
@@ Line 5203: / Line 5201: @@
      owner
    , object_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 5216: / Line 5214: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Online Analytical Processing - (OLAP)</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                              - DIMENSIONS -                                |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_dimensions"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Dimensions</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner              FORMAT a75     HEADING 'Owner'            ENTMAP off
  COLUMN dimension_name     FORMAT a75     HEADING 'Dimension Name'   ENTMAP off
@@ Line 5236: / Line 5234: @@
  COLUMN compile_state      FORMAT a75     HEADING 'Compile State'    ENTMAP off
  COLUMN revision                          HEADING 'Revision'         ENTMAP off
  BREAK ON report ON owner
  SELECT
      '<div align="left"><font color="#336699"><b>' || dd.owner || '</b></font></div>'    owner
    , dd.dimension_name                                                                   dimension_name
    , '<div align="center">' || dd.invalid  || '</div>'                                   invalid
    , DECODE(   dd.compile_state
              , 'VALID'
@@ Line 5253: / Line 5251: @@
      dd.owner
    , dd.dimension_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                            - DIMENSION LEVELS -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_dimension_levels"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Dimension Levels</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner              FORMAT a75                HEADING 'Owner'            ENTMAP off
  COLUMN dimension_name     FORMAT a75                HEADING 'Dimension Name'   ENTMAP off
@@ Line 5274: / Line 5272: @@
  COLUMN column_name        FORMAT a75                HEADING 'Column Name(s)'   ENTMAP off
  COLUMN key_position       FORMAT a75                HEADING 'Column Position'  ENTMAP off
  BREAK ON owner ON dimension_name ON level_name ON level_table_name
  SELECT
      '<div align="left"><font color="#336699"><b>' || d.owner || '</b></font></div>'  owner
@@ Line 5300: / Line 5298: @@
    , level_table_name
    , k.key_position;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                         - DIMENSION ATTRIBUTES -                           |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_dimension_attributes"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Dimension Attributes</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner              FORMAT a75     HEADING 'Owner'                    ENTMAP off
  COLUMN dimension_name     FORMAT a75     HEADING 'Dimension Name'           ENTMAP off
@@ Line 5323: / Line 5321: @@
  COLUMN column_name        FORMAT a75     HEADING 'Attribute Source Column'  ENTMAP off
  COLUMN inferred           FORMAT a75     HEADING 'Inferred?'                ENTMAP off
  BREAK ON report ON owner ON dimension_name ON level_name
  SELECT
      '<div align="left"><font color="#336699"><b>' || d.owner || '</b></font></div>'  owner
@@ Line 5348: / Line 5346: @@
    , l.level_name
    , level_table_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                         - DIMENSION HIERARCHIES -                          |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_dimension_hierarchies"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Dimension Hierarchies</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner              FORMAT a75              HEADING 'Owner'                ENTMAP off
  COLUMN dimension_name     FORMAT a75              HEADING 'Dimension Name'       ENTMAP off
@@ Line 5370: / Line 5368: @@
  COLUMN position           FORMAT a75              HEADING 'Position'             ENTMAP off
  COLUMN join_key_id        FORMAT a75              HEADING 'Join Key ID'          ENTMAP off
  BREAK ON owner ON dimension_name ON hierarchy_name
  SELECT
      '<div align="left"><font color="#336699"><b>' || d.owner || '</b></font></div>'  owner
@@ Line 5396: / Line 5394: @@
    , h.hierarchy_name
    , c.position DESC;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                                 - CUBES -                                  |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_cubes"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Cubes</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner                    FORMAT a75                 HEADING 'Owner'            ENTMAP off
  COLUMN cube_name                FORMAT a75                 HEADING 'Cube Name'        ENTMAP off
@@ Line 5416: / Line 5414: @@
  COLUMN display_name             FORMAT a75                 HEADING 'Display Name'     ENTMAP off
  COLUMN description              FORMAT a275                HEADING 'Description'      ENTMAP off
  BREAK ON report ON owner
  SELECT
      '<div align="left"><font color="#336699"><b>' || c.owner || '</b></font></div>'  owner
@@ Line 5432: / Line 5430: @@
              , '<div align="center"><font color="darkgreen"><b>Yes</b></font></div>'
              , '<div align="center">' || invalid  || '</div>')   invalid
    , c.display_name                                                                   display_name
-   , REPLACE(REPLACE(c.description, '<', '\&lt;'), '>', '\&gt;')                      description
+   , REPLACE(REPLACE(c.description, '<', '\\&lt;'), '>', '\\&gt;')                      description
  FROM
      dba_olap_cubes   c
@@ Line 5439: / Line 5437: @@
      c.owner
    , c.cube_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                          - MATERIALIZED VIEWS -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_olap_materialized_views"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Materialized Views</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner                FORMAT a75     HEADING 'Owner'               ENTMAP off
  COLUMN mview_name           FORMAT a75     HEADING 'MView|Name'          ENTMAP off
@@ Line 5468: / Line 5466: @@
  COLUMN staleness            FORMAT a75     HEADING 'Staleness'           ENTMAP off
  COLUMN compile_state        FORMAT a75     HEADING 'Compile State'       ENTMAP off
  BREAK ON owner
  SELECT
      '<div align="left"><font color="#336699"><b>' || m.owner || '</b></font></div>'                    owner
@@ Line 5490: / Line 5488: @@
              , '<div align="center"><font color="#990000"><b>'   || m.compile_state || '</b></font></div>' ) compile_state
  FROM
    dba_mviews     m
  ORDER BY
      owner
    , mview_name
  /
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                        - MATERIALIZED VIEW LOGS -                          |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_olap_materialized_view_logs"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Materialized View Logs</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN log_owner            FORMAT a75     HEADING 'Log Owner'            ENTMAP off
  COLUMN log_table            FORMAT a75     HEADING 'Log Table'            ENTMAP off
@@ Line 5520: / Line 5518: @@
  COLUMN sequence             FORMAT a75     HEADING 'Sequence?'            ENTMAP off
  COLUMN include_new_values   FORMAT a75     HEADING 'Include New Values?'  ENTMAP off
  BREAK ON log_owner
  SELECT
      '<div align="left"><font color="#336699"><b>' || ml.log_owner || '</b></font></div>'       log_owner
@@ Line 5539: / Line 5537: @@
      ml.log_owner
    , ml.master;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                   - MATERIALIZED VIEW REFRESH GROUPS -                     |
  -- +----------------------------------------------------------------------------+
  prompt <a name="dba_olap_materialized_view_refresh_groups"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Materialized View Refresh Groups</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner         FORMAT a75   HEADING 'Owner'        ENTMAP off
  COLUMN name          FORMAT a75   HEADING 'Name'         ENTMAP off
@@ Line 5559: / Line 5557: @@
  COLUMN next_date     FORMAT a75   HEADING 'Next Date'    ENTMAP off
  COLUMN interval      FORMAT a75   HEADING 'Interval'     ENTMAP off
  BREAK ON report ON owner
  SELECT
      '<div nowrap align="left"><font color="#336699"><b>' || rowner   || '</b></font></div>'  owner
@@ Line 5569: / Line 5567: @@
    , '<div nowrap align="right">'                         || interval || '</div>'             interval
  FROM
      dba_refresh
  ORDER BY
      rowner
    , rname
  /
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 5587: / Line 5585: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Data Pump</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                           - DATA PUMP JOBS -                               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="data_pump_jobs"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Data Pump Jobs</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner_name         FORMAT a75            HEADING 'Owner Name'         ENTMAP off
  COLUMN job_name           FORMAT a75            HEADING 'Job Name'           ENTMAP off
@@ Line 5609: / Line 5607: @@
  COLUMN degree             FORMAT 999,999,999    HEADING 'Degree'             ENTMAP off
  COLUMN attached_sessions  FORMAT 999,999,999    HEADING 'Attached Sessions'  ENTMAP off
  SELECT
      '<div align="left"><font color="#336699"><b>' || dpj.owner_name || '</b></font></div>'  owner_name
@@ Line 5623: / Line 5621: @@
      dpj.owner_name
    , dpj.job_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                          - DATA PUMP SESSIONS -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="data_pump_sessions"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Data Pump Sessions</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name_print  FORMAT a75            HEADING 'Instance Name'    ENTMAP off
  COLUMN owner_name           FORMAT a75            HEADING 'Owner Name'       ENTMAP off
@@ Line 5647: / Line 5645: @@
  COLUMN os_username          FORMAT a75            HEADING 'O/S Username'     ENTMAP off
  COLUMN os_pid                                     HEADING 'O/S PID'          ENTMAP off
  BREAK ON report ON instance_name_print ON owner_name ON job_name
  SELECT
      '<div align="center"><font color="#336699"><b>' || i.instance_name  || '</b></font></div>'  instance_name_print
    , dj.owner_name                                                                               owner_name
    , dj.job_name                                                                                 job_name
    , ds.type                                                                                     session_type
@@ Line 5679: / Line 5677: @@
    , dj.job_name
    , ds.type;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                        - DATA PUMP JOB PROGRESS -                          |
  -- +----------------------------------------------------------------------------+
  prompt <a name="data_pump_job_progress"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Data Pump Job Progress</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN instance_name_print  FORMAT a75                 HEADING 'Instance Name'           ENTMAP off
  COLUMN owner_name           FORMAT a75                 HEADING 'Owner Name'              ENTMAP off
@@ Line 5703: / Line 5701: @@
  COLUMN totalwork            FORMAT 9,999,999,999,999   HEADING 'Total Bytes for Job'     ENTMAP off
  COLUMN pct_completed                                   HEADING '% Completed'             ENTMAP off
  BREAK ON report ON instance_name_print ON owner_name ON job_name
  SELECT
      '<div align="center"><font color="#336699"><b>' || i.instance_name  || '</b></font></div>'   instance_name_print
    , dj.owner_name                                                                                owner_name
    , dj.job_name                                                                                  job_name
    , ds.type                                                                                      session_type
@@ Line 5737: / Line 5735: @@
    , dj.job_name
    , ds.type;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 5750: / Line 5748: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Networking</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                     - MTS DISPATCHER STATISTICS -                          |
  -- +----------------------------------------------------------------------------+
  prompt <a name="mts_dispatcher_statistics"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>MTS Dispatcher Statistics</b></font><hr align="left" width="460">
  prompt <b>Dispatcher rate</b>
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN name                    HEADING 'Name'                  ENTMAP off
  COLUMN avg_loop_rate           HEADING 'Avg|Loop|Rate'         ENTMAP off
@@ Line 5784: / Line 5782: @@
  COLUMN avg_out_connect_rate    HEADING 'Avg|Out|Connect|Rate'  ENTMAP off
  COLUMN avg_reconnect_rate      HEADING 'Avg|Reconnect|Rate'    ENTMAP off
  SELECT
      name
@@ Line 5807: / Line 5805: @@
  ORDER BY
      name;
  COLUMN protocol           HEADING 'Protocol'         ENTMAP off
  COLUMN total_busy_rate    HEADING 'Total Busy Rate'  ENTMAP off
  prompt <b>Dispatcher busy rate</b>
  SELECT
      a.network protocol
@@ Line 5821: / Line 5819: @@
  GROUP BY
      a.network;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |             - MTS DISPATCHER RESPONSE QUEUE WAIT STATS -                   |
  -- +----------------------------------------------------------------------------+
  prompt <a name="mts_dispatcher_response_queue_wait_stats"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>MTS Dispatcher Response Queue Wait Stats</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN type        HEADING 'Type'                         ENTMAP off
  COLUMN avg_wait    HEADING 'Avg Wait Time Per Response'   ENTMAP off
  SELECT
      a.type
@@ Line 5848: / Line 5846: @@
  GROUP BY
      a.type;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                  - MTS SHARED SERVER WAIT STATISTICS -                     |
  -- +----------------------------------------------------------------------------+
  prompt <a name="mts_shared_server_wait_statistics"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>MTS Shared Server Wait Statistics</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN avg_wait   HEADING 'Average Wait Time Per Request'  ENTMAP off
  SELECT
      DECODE(a.totalq, 0, 'No Requests', a.wait/a.totalq || ' HUNDREDTHS OF SECONDS') avg_wait
@@ Line 5872: / Line 5870: @@
  WHERE
      a.type='COMMON';
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +============================================================================+
  -- |                                                                            |
@@ Line 5885: / Line 5883: @@
  -- |                                                                            |
  -- +============================================================================+
  prompt
  prompt <center><font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#663300"><b><u>Replication</u></b></font></center>
  -- +----------------------------------------------------------------------------+
  -- |                         - REPLICATION SUMMARY -                            |
  -- +----------------------------------------------------------------------------+
  prompt <a name="replication_summary"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Replication Summary</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN gname           HEADING 'Current Database Name'       ENTMAP off
  COLUMN admin_request   HEADING '# Admin. Requests'           ENTMAP off
@@ Line 5906: / Line 5904: @@
  COLUMN df_error        HEADING '# Def. Tran Errors'          ENTMAP off
  COLUMN complete        HEADING '# Complete Trans in Queue'   ENTMAP off
  SELECT
      g.global_name           gname
@@ Line 5916: / Line 5914: @@
  FROM
      (select global_name from global_name)  g
    , (select count(id) admin_request
       from sys.dba_repcatlog)               d
    , (select count(status) status
       from sys.dba_repcatlog
       where status = 'ERROR')               e
    , (select count(*) tran
       from deftrandest)                     dt
    , (select count(*) error
- 	from deferror)                     de
+ \tfrom deferror)                     de
    , (select count(a.deferred_tran_id) complete
       from deftran a
       where a.deferred_tran_id not in
             (select b.deferred_tran_id
              from deftrandest b)
      )                                      c
  /
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                        - DEFERRED TRANSACTIONS -                           |
  -- +----------------------------------------------------------------------------+
  prompt <a name="deferred_transactions"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Deferred Transactions</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN source     HEADING 'Source'              ENTMAP off
  COLUMN dest       HEADING 'Target'              ENTMAP off
  COLUMN trans      HEADING '# Def. Trans'        ENTMAP off
  COLUMN errors     HEADING '# Def. Tran Errors'  ENTMAP off
  SELECT
      source
@@ Line 5964: / Line 5962: @@
         , to_char(count(*))  errors
       from
           deferror e
       group by
           e.origin_tran_db
         , e.destination
       union
       select
           g.global_name      source
@@ Line 5977: / Line 5975: @@
           (select global_name from global_name)  g
         ,  deftran                               t
         ,  deftrandest                           d
       where
            d.deferred_tran_id = t.deferred_tran_id
       group by
            g.global_name, d.dblink
       );
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                     - ADMINISTRATIVE REQUEST JOBS -                        |
  -- +----------------------------------------------------------------------------+
  prompt <a name="administrative_request_jobs"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Administrative Request Jobs</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN job                          HEADING 'Job ID'             ENTMAP off
  COLUMN priv_user                    HEADING 'Privilege Schema'   ENTMAP off
@@ Line 6004: / Line 6002: @@
  COLUMN next_date       FORMAT a75   HEADING 'Start'              ENTMAP off
  COLUMN interval                     HEADING 'Interval'           ENTMAP off
  SELECT
      job                                            job
@@ Line 6013: / Line 6011: @@
    , interval
  FROM
      sys.dba_jobs
  WHERE
      what LIKE '%dbms_repcat.do_deferred_repcat_admin%'
  ORDER BY
 ;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                      - INITIALIZATION PARAMETERS -                         |
  -- +----------------------------------------------------------------------------+
  prompt <a name="rep_initialization_parameters"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>Initialization Parameters</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN pname             FORMAT a55  HEADING 'Parameter Name'    ENTMAP off
  COLUMN value             FORMAT a55  HEADING 'Value'             ENTMAP off
  COLUMN isdefault         FORMAT a55  HEADING 'Is Default?'       ENTMAP off
  COLUMN issys_modifiable  FORMAT a55  HEADING 'Is Dynamic?'       ENTMAP off
  SELECT
      DECODE(   isdefault
@@ Line 6056: / Line 6054: @@
              , '<div align="right">' || issys_modifiable || '</div>') issys_modifiable
  FROM
      v$parameter
  WHERE
      name IN (   'compatible'
@@ Line 6081: / Line 6079: @@
    )
  ORDER BY name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                        - (SCHEDULE) - PURGE JOBS -                         |
  -- +----------------------------------------------------------------------------+
  prompt <a name="schedule_purge_jobs"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Schedule) - Purge Jobs</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN job                          HEADING 'Job ID'            ENTMAP off
  COLUMN priv_user                    HEADING 'Privilege Schema'  ENTMAP off
@@ Line 6101: / Line 6099: @@
  COLUMN next_date       FORMAT a75   HEADING 'Start'             ENTMAP off
  COLUMN interval                     HEADING 'Interval'          ENTMAP off
  SELECT
      j.job                                           job
@@ Line 6107: / Line 6105: @@
    , decode(broken, 'Y', 'Broken', 'Normal')         status
    , '<div nowrap align="right">' || NVL(TO_CHAR(s.next_date, 'mm/dd/yyyy HH24:MI:SS'), '<br>') || '</div>'   next_date
    , s.interval                                      interval
  FROM
      sys.defschedule   s
    , sys.dba_jobs      j
  WHERE
        s.dblink = (select global_name from global_name)
    AND s.interval is not null AND s.job = j.job
  ORDER BY
 ;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                       - (SCHEDULE) - PUSH JOBS -                           |
  -- +----------------------------------------------------------------------------+
  prompt <a name="schedule_push_jobs"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Schedule) - Push Jobs</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN job                         HEADING 'Job ID'             ENTMAP off
  COLUMN priv_user                   HEADING 'Privilege Schema'   ENTMAP off
@@ Line 6137: / Line 6135: @@
  COLUMN next_date      FORMAT a75   HEADING 'Start'              ENTMAP off
  COLUMN interval                    HEADING 'Interval'           ENTMAP off
  SELECT
      j.job                                          job
@@ Line 6147: / Line 6145: @@
  FROM
      sys.defschedule  s
    , sys.dba_jobs     j
  WHERE
        s.dblink != (select global_name from global_name)
    AND s.interval is not null
    AND s.job = j.job
  ORDER BY
 ;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                      - (SCHEDULE) - REFRESH JOBS -                         |
  -- +----------------------------------------------------------------------------+
  prompt <a name="schedule_refresh_jobs"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Schedule) - Refresh Jobs</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN job                           HEADING 'Job ID'             ENTMAP off
  COLUMN priv_user                     HEADING 'Privilege Schema'   ENTMAP off
@@ Line 6175: / Line 6173: @@
  COLUMN next_date         FORMAT a75  HEADING 'Start'              ENTMAP off
  COLUMN interval          FORMAT a75  HEADING 'Interval'           ENTMAP off
  SELECT
      j.job                                          job
@@ Line 6187: / Line 6185: @@
    , sys.dba_jobs     j
  WHERE
      r.job = j.job
  order by
 ;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                    - (MULTI-MASTER) - MASTER GROUPS -                      |
  -- +----------------------------------------------------------------------------+
  prompt <a name="multimaster_master_groups"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Multi-Master) - Master Groups</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN name                       HEADING 'Master Group'             ENTMAP off
  COLUMN num_def_trans              HEADING '# Def. Trans'             ENTMAP off
@@ Line 6210: / Line 6208: @@
  COLUMN num_admin_requests         HEADING '# Admin. Requests'        ENTMAP off
  COLUMN num_admin_request_errors   HEADING '# Admin. Request Errors'  ENTMAP off
  SELECT
      g.gname          name
@@ Line 6217: / Line 6215: @@
    , NVL(a.cnt3, 0)   num_admin_requests
    , NVL(b.cnt4, 0)   num_admin_request_errors
  FROM
      (select distinct gname
       from dba_repgroup
       where master='Y')                             g
    , (select
           rog                        rog
         , count(dt.deferred_tran_id) cnt1
       from (select distinct
                 ro.gname            rog
               , d.deferred_tran_id  dft
             from
                 dba_repobject  ro
               , defcall        d
               , deftrANDest    td
             where
                   ro.sname = d.schemaname
               AND ro.oname = d.packagename
               AND ro.type in ('TABLE', 'PACKAGE', 'SNAPSHOT')
               AND td.deferred_tran_id = d.deferred_tran_id
            ) t0, deftrANDest dt
       where
           dt.deferred_tran_id = dft
       group by rog
      )                                              t
    , (select distinct
           ro.gname
         , count(distinct e.deferred_tran_id) cnt2
       from
           dba_repobject  ro
         , defcall        d
         , deferror       e
       where
             ro.sname = d.schemaname
         AND ro.oname = d.packagename
         AND ro.type in ('TABLE', 'PACKAGE', 'SNAPSHOT')
         AND e.deferred_tran_id = d.deferred_tran_id
         AND e.callno = d.callno
       group by ro.gname
      )                                              ie
    , (select gname, count(*) cnt3
       from dba_repcatlog
       group by gname
      )                                              a
    , (select gname, count(*) cnt4
       from dba_repcatlog
       where status = 'ERROR'
       group BY gname
      )                                              b
  WHERE
        g.gname = ie.gname (+)
    AND g.gname = t.rog (+)
    AND g.gname = a.gname (+)
    AND g.gname = b.gname (+)
  ORDER BY
      g.gname;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |               - (MULTI-MASTER) - MASTER GROUPS AND SITES -                 |
  -- +----------------------------------------------------------------------------+
  prompt <a name="multimaster_master_groups_and_sites"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Multi-Master) - Master Groups and Sites</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN master_group             HEADING 'Master Group'            ENTMAP off
  COLUMN sites                    HEADING 'Sites'                   ENTMAP off
  COLUMN master_definition_site   HEADING 'Master Definition Site'  ENTMAP off
  SELECT
      gname                                     master_group
@@ Line 6298: / Line 6296: @@
      sys.dba_repsites
  WHERE
        master = 'Y'
    AND gname NOT IN (
                        SELECT gname from sys.dba_repsites
                        WHERE snapmaster = 'Y'
                      )
  ORDER BY
      gname;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |               - (MATERIALIZED VIEW) - MASTER SITE SUMMARY -                |
  -- +----------------------------------------------------------------------------+
  prompt <a name="materialized_view_master_site_summary"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Materialized View) - Master Site Summary</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN mgroup     HEADING '# of Master Groups'          ENTMAP off
  COLUMN mvgroup    HEADING '# of Registered MV Groups'   ENTMAP off
@@ Line 6325: / Line 6323: @@
  COLUMN mvlog      HEADING '# of MV Logs'                ENTMAP off
  COLUMN template   HEADING '# of Templates'              ENTMAP off
  SELECT
      a.mgroup      mgroup
@@ Line 6332: / Line 6330: @@
    , d.mvlog       mvlog
    , e.template    template
  FROM
      (select count(g.gname) mgroup
       from sys.dba_repgroup g, sys.dba_repsites s
       where g.master = 'Y'
         and s.master = 'Y'
         and g.gname = s.gname
         and s.my_dblink = 'Y')                      a
    , (select count(*) mvGROUP
       from sys.dba_registered_snapshot_groups)      b
    , (select count(*) mv
       from sys.dba_registered_snapshots)            c
    , (select count(*) mvlog
       from sys.dba_snapshot_logs)                   d
    , (select count(*) template
       from sys.dba_repcat_refresh_templates)        e;
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN log_owner        FORMAT a75     HEADING 'Log Owner'         ENTMAP off
  COLUMN log_table                       HEADING 'Log Table'         ENTMAP off
@@ Line 6358: / Line 6356: @@
  COLUMN primary_key      FORMAT a75     HEADING 'Primary Key'       ENTMAP off
  COLUMN filter_columns   FORMAT a75     HEADING 'Filter Columns'    ENTMAP off
  BREAK ON report ON log_owner
  SELECT
      '<div align="left"><font color="#336699"><b>' || log_owner || '</b></font></div>'  log_owner
@@ Line 6369: / Line 6367: @@
    , '<div align="center">' || filter_columns  || '</div>'   filter_columns
  FROM
      sys.dba_snapshot_logs
  ORDER BY
      log_owner;
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN ref_temp_name      HEADING 'Refresh Template Name'      ENTMAP off
  COLUMN owner              HEADING 'Owner'                      ENTMAP off
@@ Line 6381: / Line 6379: @@
  COLUMN instantiated       HEADING '# of Instantiated Sites'    ENTMAP off
  COLUMN template_comment   HEADING 'Comment'                    ENTMAP off
  SELECT
      rt.refresh_template_name                   ref_temp_name
@@ Line 6390: / Line 6388: @@
  FROM
      sys.dba_repcat_refresh_templates rt
    , (SELECT y.refresh_template_name, count(x.status) instantiated
       FROM sys.dba_repcat_template_sites x, sys.dba_repcat_refresh_templates y
       WHERE x.refresh_template_name(+) = y.refresh_template_name
       GROUP BY y.refresh_template_name) rs
  WHERE
      rt.refresh_template_name(+) = rs.refresh_template_name
  ORDER BY
      rt.refresh_template_name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |               - (MATERIALIZED VIEW) - MASTER SITE LOGS -                   |
  -- +----------------------------------------------------------------------------+
  prompt <a name="materialized_view_master_site_logs"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Materialized View) - Master Site Logs</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN log_owner        FORMAT a75     HEADING 'Log Owner'         ENTMAP off
  COLUMN log_table                       HEADING 'Log Table'         ENTMAP off
@@ Line 6419: / Line 6417: @@
  COLUMN primary_key      FORMAT a75     HEADING 'Primary Key'       ENTMAP off
  COLUMN filter_columns   FORMAT a75     HEADING 'Filter Columns'    ENTMAP off
  BREAK ON report ON log_owner
  SELECT
      '<div align="left"><font color="#336699"><b>' || log_owner || '</b></font></div>'  log_owner
@@ Line 6430: / Line 6428: @@
    , '<div align="center">' || filter_columns  || '</div>'   filter_columns
  FROM
      sys.dba_snapshot_logs
  ORDER BY
      log_owner;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |             - (MATERIALIZED VIEW) - MASTER SITE TEMPLATES -                |
  -- +----------------------------------------------------------------------------+
  prompt <a name="materialized_view_master_site_templates"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Materialized View) - Master Site Templates</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner                   HEADING 'Owner'                     ENTMAP off
  COLUMN refresh_template_name   HEADING 'Refresh Template Name'     ENTMAP off
@@ Line 6453: / Line 6451: @@
  COLUMN instantiated            HEADING '# of Instantiated Sites'   ENTMAP off
  COLUMN template_comment        HEADING 'Comment'                   ENTMAP off
  BREAK ON owner
  SELECT
      '<div align="left"><font color="#336699"><b>' || owner || '</b></font></div>'  owner
@@ Line 6464: / Line 6462: @@
  FROM
      sys.dba_repcat_refresh_templates rt
    , ( SELECT y.refresh_template_name, count(x.status) instantiated
        FROM sys.dba_repcat_template_sites x, sys.dba_repcat_refresh_templates y
        WHERE x.refresh_template_name(+) = y.refresh_template_name
        GROUP BY y.refresh_template_name
      ) rs
  WHERE
      rt.refresh_template_name(+) = rs.refresh_template_name
  ORDER BY
      owner;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                  - (MATERIALIZED VIEW) - SITE SUMMARY -                    |
  -- +----------------------------------------------------------------------------+
  prompt <a name="materialized_view_summary"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Materialized View) - Site Summary</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN mvgroup   HEADING '# of Materialized View Groups'  ENTMAP off
  COLUMN mv        HEADING '# of Materialized Views'        ENTMAP off
  COLUMN rgroup    HEADING '# of Refresh Groups'            ENTMAP off
  SELECT
      a.mvgroup    mvgroup
@@ Line 6497: / Line 6495: @@
    , c.rgroup     rgroup
  FROM
      (  select count(s.gname) mvgroup
         from sys.dba_repsites s
         where s.snapmaster = 'Y')         a
    , (  select count(*) mv
         from sys.dba_snapshots)           b
    , (  select count(*) rgroup
         from sys.dba_refresh)             c;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                 - (MATERIALIZED VIEW) - SITE GROUPS -                      |
  -- +----------------------------------------------------------------------------+
  prompt <a name="materialized_view_groups"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Materialized View) - Site Groups</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN gname         HEADING 'Name'           ENTMAP off
  COLUMN dblink        HEADING 'Master'         ENTMAP off
  COLUMN propagation   HEADING 'Propagation'    ENTMAP off
  COLUMN remark        HEADING 'Remark'         ENTMAP off
  SELECT
      s.gname                                      gname
@@ Line 6537: / Line 6535: @@
  ORDER BY
      s.gname;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |            - (MATERIALIZED VIEW) - SITE MATERIALIZED VIEWS -               |
  -- +----------------------------------------------------------------------------+
  prompt <a name="materialized_view_materialized_views"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Materialized View) - Site Materialized Views</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner          FORMAT a75  HEADING 'Owner'           ENTMAP off
  COLUMN name                       HEADING 'Name'            ENTMAP off
@@ Line 6561: / Line 6559: @@
  COLUMN can_use_log    FORMAT a75  HEADING 'Can Use Log?'    ENTMAP off
  COLUMN last_refresh   FORMAT a75  HEADING 'Last Refresh'    ENTMAP off
  BREAK ON owner
  SELECT
      '<div align="left"><font color="#336699"><b>' || s.owner  || '</b></font></div>'  owner
@@ Line 6576: / Line 6574: @@
  FROM
      sys.dba_snapshots  s
    , sys.dba_mviews     m
  WHERE
        s.name = m.mview_name
    AND s.owner = m.owner
  ORDER BY
      s.owner
    , s.name;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |              - (MATERIALIZED VIEW) - SITE REFRESH GROUPS -                 |
  -- +----------------------------------------------------------------------------+
  prompt <a name="materialized_view_refresh_groups"></a>
  prompt <font size="+2" face="Arial,Helvetica,Geneva,sans-serif" color="#336699"><b>(Materialized View) - Site Refresh Groups</b></font><hr align="left" width="460">
  CLEAR COLUMNS BREAKS COMPUTES
  COLUMN owner         FORMAT a75   HEADING 'Owner'        ENTMAP off
  COLUMN name          FORMAT a75   HEADING 'Name'         ENTMAP off
@@ Line 6603: / Line 6601: @@
  COLUMN next_date     FORMAT a75   HEADING 'Next Date'    ENTMAP off
  COLUMN interval      FORMAT a75   HEADING 'Interval'     ENTMAP off
  BREAK ON owner
  SELECT
      '<div align="left"><font color="#336699"><b>' || rowner   || '</b></font></div>'  owner
@@ Line 6617: / Line 6615: @@
      rowner
    , rname;
- prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
+ prompt <center>[[<a class="noLink" href="#top">Top</a>]]</center><p>
  -- +----------------------------------------------------------------------------+
  -- |                            - END OF REPORT -                               |
  -- +----------------------------------------------------------------------------+
  SPOOL OFF
  SET MARKUP HTML OFF
  SET TERMOUT ON
  prompt
  prompt Output written to: &FileName._&_dbname._&_spool_time..html
  EXIT;
 </code>