Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\metadata\instance.xmlp

<Metric NAME="sql_response" TYPE="TABLE">
		<ValidIf>
			<CategoryProp NAME="MCPkg" CHOICES="2;3"/>
		</ValidIf>
		<Display>
			<Label NLSID="sql_response">SQL Response Time</Label>
		</Display>
		<TableDescriptor>
			
			<ColumnDescriptor NAME="time2" TYPE="NUMBER" TRANSIENT="TRUE" HELP="NO_HELP"/>
                        <ColumnDescriptor NAME="baselineTime" TYPE="NUMBER">
                                <Display FOR_SUMMARY_UI="TRUE">
                                        <Label NLSID="baseline_sql_response_time">Baseline SQL Response Time</Label>
                                        <ShortName NLSID="baseline_sql_response_time_short">Baseline Response</ShortName>
                                </Display>
                        </ColumnDescriptor>
                        <ColumnDescriptor NAME="currentTime" TYPE="NUMBER">
                                <Display FOR_SUMMARY_UI="TRUE">
                                        <Label NLSID="current_sql_response_time">Current SQL Response Time</Label>
                                        <ShortName NLSID="current_sql_response_time_short">Current Response</ShortName>
                                </Display>
                        </ColumnDescriptor>
			
			<ColumnDescriptor NAME="time1" TYPE="NUMBER" TRANSIENT="TRUE" HELP="NO_HELP" COMPUTE_EXPR="_time2"/>
			
			<ColumnDescriptor NAME="time0" TYPE="NUMBER" TRANSIENT="TRUE" HELP="NO_HELP" COMPUTE_EXPR="_time1"/>
			
			<ColumnDescriptor NAME="time1vs2" TYPE="NUMBER" TRANSIENT="TRUE" HELP="NO_HELP" COMPUTE_EXPR="(time1 > time2) ? time1 : time2"/>
			
			<ColumnDescriptor NAME="time0vs2" TYPE="NUMBER" TRANSIENT="TRUE" HELP="NO_HELP" COMPUTE_EXPR="(time0 > time2) ? time0 : time2"/>
			
			<ColumnDescriptor NAME="time0vs1" TYPE="NUMBER" TRANSIENT="TRUE" HELP="NO_HELP" COMPUTE_EXPR="_time1vs2"/>
			
			<ColumnDescriptor NAME="timeMid" TYPE="NUMBER" TRANSIENT="TRUE" HELP="NO_HELP" COMPUTE_EXPR="((time2 > time0vs1) ? time0vs1 : ((time1 > time0vs2) ? time0vs2 : time1vs2))"/>
			
			<ColumnDescriptor NAME="time" TYPE="NUMBER" COMPUTE_EXPR="(time2 > 400) ? timeMid : time2">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="sql_response_time">SQL Response Time (%)</Label>
					<ShortName NLSID="sql_response_time_short">Response</ShortName>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="SQL">
			<Property NAME="STATEMENT" SCOPE="GLOBAL"><![CDATA[
BEGIN
  IF (:1 = 'READ WRITE') THEN
    ----
    -- For a read-write database appropriately configured, try to evaluate.
    ----
    IF (:2 = '1') THEN
      dbsnmp.mgmt_response.get_metric_curs(:3);
    ELSE
      execute immediate 'begin dbsnmp.mgmt_response.get_latest_curs(:a); end;' using in out :3;
    END IF;
  ELSE
    ----
    -- For a read-only database, do not evaluate, but rather return an empty
    -- cursor.
    ----
    DECLARE
      TYPE        data_cursor_type IS REF CURSOR;
      data_cursor data_cursor_type;
    BEGIN
      OPEN data_cursor FOR
        SELECT -1
          FROM dual
         WHERE 0=1;
      :3 := data_cursor;
    END;
  END IF;
END;
]]></Property>
			<Property NAME="SQLINPARAM1" SCOPE="INSTANCE">OpenMode</Property>
                        <Property NAME="SQLINPARAM2" SCOPE="INSTANCE">MCResponse</Property>
			<Property NAME="SQLOUTPARAMPOS" SCOPE="GLOBAL">3</Property>
			<Property NAME="SQLOUTPARAMTYPE" SCOPE="GLOBAL">SQL_CURSOR</Property>
			<Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
			<Property NAME="Port" SCOPE="INSTANCE">Port</Property>
			<Property NAME="SID" SCOPE="INSTANCE">SID</Property>
			<Property NAME="UserName" SCOPE="INSTANCE">UserName</Property>
			<Property NAME="password" SCOPE="INSTANCE">password</Property>
			<Property NAME="Role" SCOPE="INSTANCE" OPTIONAL="TRUE">Role</Property>
		</QueryDescriptor>
	</Metric>
        
             <Metric NAME="sql_response_collect" TYPE="TABLE" USAGE_TYPE="HIDDEN_COLLECT">
                <ValidIf>
                        <CategoryProp NAME="MCPkg" CHOICES="2;3"/>
                </ValidIf>
                <Display>
                        <Label NLSID="collect_sql_response">Collect SQL Response Time</Label>
                </Display>
                <TableDescriptor>
                        <ColumnDescriptor NAME="time" TYPE="NUMBER">
                                <Display>
                                        <Label NLSID="sql_response_time">SQL Response Time (%)</Label>
                                        <ShortName NLSID="sql_response_time_short">Response</ShortName>
                                </Display>
                        </ColumnDescriptor>
                </TableDescriptor>
                <QueryDescriptor FETCHLET_ID="SQL">
                        <Property NAME="STATEMENT" SCOPE="GLOBAL"><![CDATA[
BEGIN
  IF (:1 = 'READ WRITE' AND (:2 = '2' OR :2 = '3')) THEN
    ----
    -- For a read-write database appropriately configured, try to evaluate.
    ----
    dbsnmp.mgmt_response.get_metric_curs(:3);
  ELSE
    ----
    -- For a read-only database, do not evaluate, but rather return an empty
    -- cursor.
    ----
    DECLARE
      TYPE        data_cursor_type IS REF CURSOR;
      data_cursor data_cursor_type;
    BEGIN
      OPEN data_cursor FOR
        SELECT -1
          FROM dual
         WHERE 0=1;
      :3 := data_cursor;
    END;
  END IF;
END;
]]></Property>
                        <Property NAME="SQLINPARAM1" SCOPE="INSTANCE">OpenMode</Property>
                        <Property NAME="SQLINPARAM2" SCOPE="INSTANCE">MCResponse</Property>
                        <Property NAME="SQLOUTPARAMPOS" SCOPE="GLOBAL">3</Property>
                        <Property NAME="SQLOUTPARAMTYPE" SCOPE="GLOBAL">SQL_CURSOR</Property>
                        <Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
                        <Property NAME="Port" SCOPE="INSTANCE">Port</Property>
                        <Property NAME="SID" SCOPE="INSTANCE">SID</Property>
                        <Property NAME="UserName" SCOPE="INSTANCE">UserName</Property>
                        <Property NAME="password" SCOPE="INSTANCE">password</Property>
                        <Property NAME="Role" SCOPE="INSTANCE" OPTIONAL="TRUE">Role</Property>
                </QueryDescriptor>
        </Metric>

<Metric NAME="instance_throughput" TYPE="TABLE">
		<ValidIf>
			<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
		</ValidIf>
		<Display>
			<Label NLSID="instance_throughput">Throughput</Label>
		</Display>
		<TableDescriptor>
			
			
			
			<ColumnDescriptor NAME="logons_current" TYPE="NUMBER" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_logons_current">All Sessions</Label>
					<ShortName NLSID="instance_throughput_logons_current">All Sessions</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="logons_cumulative" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_logons_cumulative">logons cumulative</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="parses" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_parses">parse count (total)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="hard_parses" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_hard_parses">parse count (hard)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="executions" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_executions">execution count</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="user_calls" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_user_calls">user calls</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="recursive_calls" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_recursive_calls">recursive calls</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sorts_memory" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_sorts_memory">sorts (memory)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sorts_disk" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_sorts_disk">sorts (disk)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sorts_rows" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_sorts_rows">sorts (rows)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="logical_reads" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_logical_reads">session logical reads</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="physical_reads" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_physical_reads">physical reads</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="table_scans_long" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_table_scans_long">table scans (long tables)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="index_ffs_full" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_index_ffs_full">index fast full scans (full)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="physical_writes" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_physical_writes">physical writes</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="bytes_to_client" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_bytes_to_client">bytes sent via SQL*Net to client</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="bytes_from_client" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_bytes_from_client">bytes received via SQL*Net from client</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="bytes_to_dblink" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_bytes_to_dblink">bytes sent via SQL*Net to dblink</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="bytes_from_dblink" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_bytes_from_dblink">bytes received via SQL*Net from dblink</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="commits" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_commits">user commits</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="dbwr_checkpoints" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_dbwr_checkpoints">DBWR checkpoints</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="rollbacks" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_rollbacks">user rollbacks</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="redo_size" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_redo_size">redo size</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="redo_writes" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_throughput_redo_writes">redo writes</Label>
				</Display>
			</ColumnDescriptor>
			
			
			<ColumnDescriptor NAME="transactions" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP" COMPUTE_EXPR="(commits + rollbacks > _commits + _rollbacks) ? (commits - _commits) + (rollbacks - _rollbacks) : 0">
				<Display>
					<Label NLSID="instance_throughput_transactions">transactions</Label>
				</Display>
			</ColumnDescriptor>
			
			<ColumnDescriptor NAME="transactions_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="transactions/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_transactions_ps">Number of Transactions (per second)</Label>
					<ShortName NLSID="instance_throughput_transactions_ps_short">Transactions/s</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="physreads_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_physical_reads > physical_reads) ? (1/0) : (physical_reads - _physical_reads)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_physreads_ps">Physical Reads (per second)</Label>
					<ShortName NLSID="instance_throughput_physreads_ps_short">Physical Reads/s</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="physreads_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_physical_reads > physical_reads) ? (1/0) : (physical_reads - _physical_reads)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_physreads_pt">Physical Reads (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="physwrites_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_physical_writes > physical_writes) ? (1/0) : (physical_writes - _physical_writes)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_physwrites_ps">Physical Writes (per second)</Label>
					<ShortName NLSID="instance_throughput_physwrites_ps_short">Phys Writes/sec</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="physwrites_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_physical_writes > physical_writes) ? (1/0) : (physical_writes - _physical_writes)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_physwrites_pt">Physical Writes (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="redosize_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_redo_size > redo_size) ? (1/0) : (redo_size - _redo_size)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_redosize_ps">Redo Generated (per second)</Label>
					<ShortName NLSID="instance_throughput_redosize_ps_short">Redo Size/sec</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="redosize_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_redo_size > redo_size) ? (1/0) : (redo_size - _redo_size)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_redosize_pt">Redo Generated (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="logons_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_logons_cumulative > logons_cumulative) ? (1/0) : (logons_cumulative - _logons_cumulative)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_logons_ps">Cumulative Logons (per second)</Label>
					<ShortName NLSID="instance_throughput_logons_ps_short">Logons/sec</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="logons_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_logons_cumulative > logons_cumulative) ? (1/0) : (logons_cumulative - _logons_cumulative)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_logons_pt">Cumulative Logons (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="commits_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_commits > commits) ? (1/0) : (commits - _commits)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_commits_ps">User Commits (per second)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="commits_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_commits > commits) ? (1/0) : (commits - _commits)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_commits_pt">User Commits (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="rollbacks_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_rollbacks > rollbacks) ? (1/0) : (rollbacks - _rollbacks)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_rollbacks_ps">User Rollbacks (per second)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="rollbacks_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_rollbacks > rollbacks) ? (1/0) : (rollbacks - _rollbacks)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_rollbacks_pt">User Rollbacks (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="usercalls_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_user_calls > user_calls) ? (1/0) : (user_calls - _user_calls)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_usercalls_ps">User Calls (per second)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="usercalls_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_user_calls > user_calls) ? (1/0) : (user_calls - _user_calls)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_usercalls_pt">User Calls (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="recurscalls_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_recursive_calls > recursive_calls) ? (1/0) : (recursive_calls - _recursive_calls)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_recurscalls_ps">Recursive Calls (per second)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="recurscalls_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_recursive_calls > recursive_calls) ? (1/0) : (recursive_calls - _recursive_calls)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_recurscalls_pt">Recursive Calls (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="logreads_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_logical_reads > logical_reads) ? (1/0) : (logical_reads - _logical_reads)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_logreads_ps">Session Logical Reads (per second)</Label>
					<ShortName NLSID="instance_throughput_logreads_ps_short">Logical Reads/s</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="logreads_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_logical_reads > logical_reads) ? (1/0) : (logical_reads - _logical_reads)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_logreads_pt">Session Logical Reads (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="dbwrcheckpoints_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_dbwr_checkpoints > dbwr_checkpoints) ? (1/0) : (dbwr_checkpoints - _dbwr_checkpoints)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_dbwrcheckpoints_ps">DBWR Checkpoints (per second)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="redowrites_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_redo_writes > redo_writes) ? (1/0) : (redo_writes - _redo_writes)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_redowrites_ps">Redo Writes (per second)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="redowrites_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_redo_writes > redo_writes) ? (1/0) : (redo_writes - _redo_writes)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_redowrites_pt">Redo Writes (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="tabscanslong_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_table_scans_long > table_scans_long) ? (1/0) : (table_scans_long - _table_scans_long)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_tabscanslong_ps">Scans on Long Tables (per second)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="tabscanslong_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_table_scans_long > table_scans_long) ? (1/0) : (table_scans_long - _table_scans_long)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_tabscanslong_pt">Scans on Long Tables (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="parses_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_parses > parses) ? (1/0) : (parses - _parses)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_parses_ps">Total Parses (per second)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="parses_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_parses > parses) ? (1/0) : (parses - _parses)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_parses_pt">Total Parses (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="hardparses_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_hard_parses > hard_parses) ? (1/0) : (hard_parses - _hard_parses)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_hardparses_ps">Hard Parses (per second)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="hardparses_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_hard_parses > hard_parses) ? (1/0) : (hard_parses - _hard_parses)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_hardparses_pt">Hard Parses (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="executions_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_executions > executions) ? (1/0) : (executions - _executions)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_executions_ps">Executes (per second)</Label>
					<ShortName NLSID="instance_throughput_executions_ps_short">SQL Executions/s</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sortsdisk_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_sorts_disk > sorts_disk) ? (1/0) : (sorts_disk - _sorts_disk)/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_sortsdisk_ps">Sorts to Disk (per second)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sortsdisk_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_sorts_disk > sorts_disk) ? (1/0) : (sorts_disk - _sorts_disk)/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_sortsdisk_pt">Sorts to Disk (per transaction)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="rows_psort" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_sorts_rows + _sorts_disk + _sorts_memory > sorts_rows + sorts_disk + sorts_memory) ? (1/0) : (sorts_rows - _sorts_rows)/((sorts_disk - _sorts_disk) + (sorts_memory - _sorts_memory))">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_rows_psort">Rows Processed (per sort)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="executeswoparse_pct" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_parses + _executions > parses + executions) ? (1/0) : (((executions - _executions) > (parses - _parses)) ? (100 * (((executions - _executions) - (parses - _parses))/(executions - _executions))) : 0)">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_executeswoparse_pct">Executes Performed without Parses (%)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="softparse_pct" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_parses + _hard_parses > parses + hard_parses) ? (1/0) : 100 * (((parses - _parses) - (hard_parses - _hard_parses))/(parses - _parses))">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_softparse_pct">Soft Parse (%)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="usercall_pct" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_user_calls + _recursive_calls > user_calls + recursive_calls) ? (1/0) : 100 * ((user_calls - _user_calls)/((user_calls - _user_calls) + (recursive_calls - _recursive_calls)))">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_usercall_pct">User Calls (%)</Label>

</Display>
			</ColumnDescriptor>               
           
			<ColumnDescriptor NAME="tabscanstotal_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_table_scans_long + _index_ffs_full > table_scans_long + index_ffs_full) ? (1/0) : ((table_scans_long - _table_scans_long) + (index_ffs_full - _index_ffs_full))/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_tabscanstotal_ps">Total Table Scans (per second)</Label>

</Display>
			</ColumnDescriptor>
            
			<ColumnDescriptor NAME="tabscanstotal_pt" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_table_scans_long + _index_ffs_full > table_scans_long + index_ffs_full) ? (1/0) : ((table_scans_long - _table_scans_long) + (index_ffs_full - _index_ffs_full))/transactions">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_tabscanstotal_pt">Total Table Scans (per transaction)</Label>

</Display>
			</ColumnDescriptor>

<ColumnDescriptor NAME="networkbytes_ps" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_bytes_to_client + _bytes_from_client + _bytes_to_dblink + _bytes_from_dblink > bytes_to_client + bytes_from_client + bytes_to_dblink + bytes_from_dblink) ? (1/0) : ((bytes_to_client - _bytes_to_client) + (bytes_from_client - _bytes_from_client) + (bytes_to_dblink - _bytes_to_dblink) + (bytes_from_dblink - _bytes_from_dblink))/__interval">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_throughput_networkbytes_ps">Network Bytes (per second)</Label>

</Display>
			</ColumnDescriptor>    
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="SQL">
			<Property NAME="STATEMENT" SCOPE="GLOBAL"><![CDATA[
DECLARE
  logons_current    NUMBER := NULL;
  logons_cumulative NUMBER := NULL;
  parses            NUMBER := NULL;
  hard_parses       NUMBER := NULL;
  executions        NUMBER := NULL;
  user_calls        NUMBER := NULL;
  recursive_calls   NUMBER := NULL;
  sorts_memory      NUMBER := NULL;
  sorts_disk        NUMBER := NULL;
  sorts_rows        NUMBER := NULL;
  logical_reads     NUMBER := NULL;
  physical_reads    NUMBER := NULL;
  table_scans_long  NUMBER := NULL;
  index_ffs_full    NUMBER := NULL;
  physical_writes   NUMBER := NULL;
  bytes_to_client   NUMBER := NULL;
  bytes_from_client NUMBER := NULL;
  bytes_to_dblink   NUMBER := NULL;
  bytes_from_dblink NUMBER := NULL;
  commits           NUMBER := NULL;
  dbwr_checkpoints  NUMBER := NULL;
  rollbacks         NUMBER := NULL;
  redo_size         NUMBER := NULL;
  redo_writes       NUMBER := NULL;

TYPE        data_cursor_type IS REF CURSOR;
  data_cursor data_cursor_type;

BEGIN

FOR name_value_pair IN
    (SELECT sn.name, sv.value
       FROM v$statname sn, v$sysstat sv
      WHERE sn.name IN
            ('DBWR checkpoints',
             'bytes received via SQL*Net from client',
             'bytes received via SQL*Net from dblink',
             'bytes sent via SQL*Net to client',
             'bytes sent via SQL*Net to dblink',
             'execute count',
             'index fast full scans (full)',
             'logons cumulative',
             'logons current',
             'parse count (hard)',
             'parse count (total)',
             'physical reads',
             'physical writes',
             'recursive calls',
             'redo size',
             'redo writes',
             'session logical reads',
             'sorts (disk)',
             'sorts (memory)',
             'sorts (rows)',
             'table scans (long tables)',
             'user calls',
             'user commits',
             'user rollbacks')
        AND sn.statistic# = sv.statistic#)
  LOOP

IF name_value_pair.name = 'DBWR checkpoints' THEN
      dbwr_checkpoints := name_value_pair.value;
    ELSIF name_value_pair.name = 'bytes received via SQL*Net from client' THEN
      bytes_from_client := name_value_pair.value;
    ELSIF name_value_pair.name = 'bytes received via SQL*Net from dblink' THEN
      bytes_from_dblink := name_value_pair.value;
    ELSIF name_value_pair.name = 'bytes sent via SQL*Net to client' THEN
      bytes_to_client := name_value_pair.value;
    ELSIF name_value_pair.name = 'bytes sent via SQL*Net to dblink' THEN
      bytes_to_dblink := name_value_pair.value;
    ELSIF name_value_pair.name = 'execute count' THEN
      executions := name_value_pair.value;
    ELSIF name_value_pair.name = 'index fast full scans (full)' THEN
      index_ffs_full := name_value_pair.value;
    ELSIF name_value_pair.name = 'logons cumulative' THEN
      logons_cumulative := name_value_pair.value;
    ELSIF name_value_pair.name = 'logons current' THEN
      logons_current := name_value_pair.value;
    ELSIF name_value_pair.name = 'parse count (hard)' THEN
      hard_parses := name_value_pair.value;
    ELSIF name_value_pair.name = 'parse count (total)' THEN
      parses := name_value_pair.value;
    ELSIF name_value_pair.name = 'physical reads' THEN
      physical_reads := name_value_pair.value;
    ELSIF name_value_pair.name = 'physical writes' THEN
      physical_writes := name_value_pair.value;
    ELSIF name_value_pair.name = 'recursive calls' THEN
      recursive_calls := name_value_pair.value;
    ELSIF name_value_pair.name = 'redo size' THEN
      redo_size := name_value_pair.value;
    ELSIF name_value_pair.name = 'redo writes' THEN
      redo_writes := name_value_pair.value;
    ELSIF name_value_pair.name = 'session logical reads' THEN
      logical_reads := name_value_pair.value;
    ELSIF name_value_pair.name = 'sorts (disk)' THEN
      sorts_disk := name_value_pair.value;
    ELSIF name_value_pair.name = 'sorts (memory)' THEN
      sorts_memory := name_value_pair.value;
    ELSIF name_value_pair.name = 'sorts (rows)' THEN
      sorts_rows := name_value_pair.value;
    ELSIF name_value_pair.name = 'table scans (long tables)' THEN
      table_scans_long := name_value_pair.value;
    ELSIF name_value_pair.name = 'user calls' THEN
      user_calls := name_value_pair.value;
    ELSIF name_value_pair.name = 'user commits' THEN
      commits := name_value_pair.value;
    ELSIF name_value_pair.name = 'user rollbacks' THEN
      rollbacks := name_value_pair.value;
    END IF;

END LOOP;

-- open the cursor to return
  OPEN data_cursor FOR
    SELECT logons_current,
           logons_cumulative,
           parses,
           hard_parses,
           executions,
           user_calls,
           recursive_calls,
           sorts_memory,
           sorts_disk,
           sorts_rows,
           logical_reads,
           physical_reads,
           table_scans_long,
           index_ffs_full,
           physical_writes,
           bytes_to_client,
           bytes_from_client,
           bytes_to_dblink,
           bytes_from_dblink,
           commits,
           dbwr_checkpoints,
           rollbacks,
           redo_size,
           redo_writes
      FROM dual;

<Metric NAME="instance_efficiency" TYPE="TABLE">
		<ValidIf>
			<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
		</ValidIf>
		<Display>
			<Label NLSID="instance_efficiency">Efficiency</Label>
		</Display>
		<TableDescriptor>
			
			
			
			<ColumnDescriptor NAME="sorts_memory" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_efficiency_sorts_memory">sorts (memory)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sorts_disk" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_efficiency_sorts_disk">sorts (disk)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="logical_reads" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_efficiency_logical_reads">session logical reads</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="physical_reads" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_efficiency_physical_reads">physical reads</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="physical_reads_direct" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_efficiency_physical_reads_direct">physical reads direct</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="redo_entries" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_efficiency_redo_entries">redo entries</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="redo_space_requests" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_efficiency_redo_space_requests">redo log space requests</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="libcache_pins" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_efficiency_libcache_pins">libcache pins</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="libcache_pinhits" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_efficiency_libcache_pinhits">libcache pinhits</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="dictionary_gets" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_efficiency_dictionary_gets">dictionary gets</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="dictionary_misses" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="instance_efficiency_dictionary_misses">dictionary misses</Label>
				</Display>
			</ColumnDescriptor>
			
			
			<ColumnDescriptor NAME="bufcachehit_pct" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_logical_reads + _physical_reads + _physical_reads_direct > logical_reads + physical_reads + physical_reads_direct) ? (1/0) : ((logical_reads > _logical_reads) ? (100 * (1 - (((physical_reads - _physical_reads) - (physical_reads_direct - _physical_reads_direct))/(logical_reads - _logical_reads)))) : 100)">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_efficiency_bufcachehit_pct">Buffer Cache Hit (%)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="libcache_hit_pct" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_libcache_pins + _libcache_pinhits > libcache_pins + libcache_pinhits) ? (1/0) : ((libcache_pins > _libcache_pins) ? (100 * (libcache_pinhits - _libcache_pinhits)/(libcache_pins - _libcache_pins)) : 100)">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_efficiency_libcache_hit_pct">Library Cache Hit (%)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="dictionaryhit_pct" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_dictionary_gets + _dictionary_misses > dictionary_gets + dictionary_misses) ? (1/0) : ((dictionary_gets > _dictionary_gets) ? (100 * ((dictionary_gets - _dictionary_gets) - (dictionary_misses - _dictionary_misses))/(dictionary_gets - _dictionary_gets)) : 100)">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_efficiency_dictionaryhit_pct">Data Dictionary Hit (%)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="inmem_sort_pct" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_sorts_memory + _sorts_disk > sorts_memory + sorts_disk) ? (1/0) : ((sorts_memory + sorts_disk > _sorts_memory + _sorts_disk) ? (100 * (sorts_memory - _sorts_memory)/((sorts_memory - _sorts_memory) + (sorts_disk - _sorts_disk))) : 100)">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_efficiency_inmem_sort_pct">Sorts in Memory (%)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="redologalloc_hit_pct" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="(_redo_entries + _redo_space_requests > redo_entries + redo_space_requests) ? (1/0) : ((redo_entries > _redo_entries) ? (100 * ((redo_entries - _redo_entries) - (redo_space_requests - _redo_space_requests))/(redo_entries - _redo_entries)) : 100)">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="instance_efficiency_redologalloc_hit_pct">Redo Log Allocation Hit (%)</Label>

</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="SQL">
			<Property NAME="STATEMENT" SCOPE="GLOBAL"><![CDATA[
DECLARE
  sorts_memory                 NUMBER := 0;
  sorts_disk                   NUMBER := 0;
  logical_reads                NUMBER := 0;
  physical_reads               NUMBER := 0;
  physical_reads_direct        NUMBER := 0;
  redo_entries                 NUMBER := 0;
  redo_space_requests          NUMBER := 0;
  libcache_pins                NUMBER := 0;
  libcache_pinhits             NUMBER := 0;
  dictionary_gets              NUMBER := 0;
  dictionary_misses            NUMBER := 0;

TYPE num_sequence IS TABLE OF NUMBER;

--
  -- The statistic#'s of the v$sysstat statistics we're interested in.
  -- These numbers are ordered alphabetically, according to the stat name.
  --
  ordered_stat#s num_sequence := num_sequence();

-- keep the MAX(statistic#) as a pseudo-statistic which represents a miss
  -- in the name lookup
  max_stat#      NUMBER := 0;

-- Note: This must be alphabetical (and ending with NULL)!
  TYPE name_list IS TABLE OF VARCHAR2(64);
  stat_names CONSTANT name_list :=
   name_list('physical reads',
             'physical reads direct',
             'redo entries',
             'redo log space requests',
             'session logical reads',
             'sorts (disk)',
             'sorts (memory)',
             NULL);
  curr_stat#_ord INTEGER := 1;

-- since misses are not expected, we'll keep a counter and only post-
  -- process the stat# array if there were any
  statname_misses INTEGER := 0;

sysstat_vals        num_sequence := num_sequence();

i NUMBER;

TYPE        data_cursor_type IS REF CURSOR;
  data_cursor data_cursor_type;

BEGIN

----
  -- initialize ordered_stat#s with the statistic#s (+1, since these are
  -- PL/SQL array indices) for the statistics we're interested in
  ----

FOR name_stat#_pair IN
    (SELECT name, statistic# stat#
       FROM v$statname
      ORDER BY name)
  LOOP

-- (compute MAX(statistic#) for the purpose of misses)
    max_stat# := GREATEST(max_stat#, name_stat#_pair.stat#);

IF name_stat#_pair.name = stat_names(curr_stat#_ord) THEN

----
      -- log the found statistic#
      ----

ordered_stat#s.EXTEND;
      ordered_stat#s(curr_stat#_ord) := name_stat#_pair.stat# + 1;
      curr_stat#_ord := curr_stat#_ord + 1;

ELSIF name_stat#_pair.name > stat_names(curr_stat#_ord) THEN

----
      -- we've had a miss, so post-process the array, setting our NULL
      -- statistic#s to our pseudo-statistic#
      -- this can only happen if
      --  a statistic is deprecated by the server (which it doesn't do), or
      --  a misspelling of a valid statistic name in the list, or
      --  an incorrect alphabetical ordering of the list
      ----

ordered_stat#s.EXTEND;
      ordered_stat#s(curr_stat#_ord) := NULL;
      curr_stat#_ord := curr_stat#_ord + 1;
      statname_misses := statname_misses + 1;

END IF;

END LOOP;

IF statname_misses > 0 THEN

-- (post-process the misses)
    FOR stat_ord IN 1..ordered_stat#s.COUNT LOOP
      IF ordered_stat#s(stat_ord) IS NULL THEN
        ordered_stat#s(stat_ord) := max_stat# + 2;
      END IF;
    END LOOP;

END IF;

----
  -- query data into sysstat_vals, indexed by statistic#, leaving a zeroed
  -- slot at the end for misses
  ----

-- (supply a value for misses)
  sysstat_vals.EXTEND(max_stat# + 2);
  sysstat_vals(max_stat# + 2) := 0;

-- (populate the stat# table)
  FOR stat#_val_pair IN
    (SELECT statistic# stat#, value
       FROM v$sysstat)
  LOOP
    sysstat_vals(stat#_val_pair.stat# + 1) := stat#_val_pair.value;
  END LOOP;

----
  -- populate the SYSSTAT regions of the output record
  --
  -- Note: The order of this list must match the alphabetical order of
  --       statistic names!
  ----

i := 1;
  physical_reads        := sysstat_vals(ordered_stat#s(i)); i := i + 1;
  physical_reads_direct := sysstat_vals(ordered_stat#s(i)); i := i + 1;
  redo_entries          := sysstat_vals(ordered_stat#s(i)); i := i + 1;
  redo_space_requests   := sysstat_vals(ordered_stat#s(i)); i := i + 1;
  logical_reads         := sysstat_vals(ordered_stat#s(i)); i := i + 1;
  sorts_disk            := sysstat_vals(ordered_stat#s(i)); i := i + 1;
  sorts_memory          := sysstat_vals(ordered_stat#s(i)); i := i + 1;

----
  -- get library cache pin data
  ----
  SELECT SUM(pins), SUM(pinhits)
    INTO libcache_pins, libcache_pinhits
    FROM v$librarycache;

----
  -- get dictionary gets data
  ----
  SELECT SUM(gets), SUM(getmisses)
    INTO dictionary_gets, dictionary_misses
    FROM v$rowcache;

-- open the cursor to return
  OPEN data_cursor FOR
    SELECT sorts_memory,
           sorts_disk,
           logical_reads,
           physical_reads,
           physical_reads_direct,
           redo_entries,
           redo_space_requests,
           libcache_pins,
           libcache_pinhits,
           dictionary_gets,
           dictionary_misses
      FROM dual;

<Metric NAME="sga_pool_wastage" TYPE="TABLE">
		<ValidIf>
			<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
		</ValidIf>
		<Display>
			<Label NLSID="sga_pool_wastage">SGA Pool Wastage</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="shared_free_pct" TYPE="NUMBER" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="sga_pool_wastage_shared_free_pct">Shared Pool Free (%)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="large_free_pct" TYPE="NUMBER" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="sga_pool_wastage_large_free_pct">Large Pool Free (%)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="java_free_pct" TYPE="NUMBER" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="sga_pool_wastage_java_free_pct">Java Pool Free (%)</Label>

</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="SQL">
			<Property NAME="STATEMENT" SCOPE="GLOBAL"><![CDATA[
DECLARE

shared_free_pct NUMBER;
  large_free_pct  NUMBER;
  java_free_pct   NUMBER;

TYPE        data_cursor_type IS REF CURSOR;
  data_cursor data_cursor_type;

BEGIN

----
  -- compute each percentage
  ----
  FOR pool_pct_pair IN
    (SELECT pool,
            DECODE(total_bytes, 0, NULL, 100 * free_bytes / total_bytes) pct
       FROM (SELECT pool,
                    SUM(bytes) total_bytes,
                    SUM(DECODE(name, 'free memory', bytes, 0)) free_bytes
               FROM v$sgastat
              GROUP BY pool))
  LOOP
    IF pool_pct_pair.pool = 'shared pool' THEN
      shared_free_pct := pool_pct_pair.pct;
    ELSIF pool_pct_pair.pool = 'java pool' THEN
      java_free_pct   := pool_pct_pair.pct;
    ELSIF pool_pct_pair.pool = 'large pool' THEN
      large_free_pct  := pool_pct_pair.pct;
    END IF;
  END LOOP;

-- open the cursor to return
  OPEN data_cursor FOR
    SELECT shared_free_pct,
           large_free_pct,
           java_free_pct
      FROM dual;

<Metric NAME="wait_bottlenecks" TYPE="TABLE">
    <ValidIf>
       <CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
    </ValidIf>
    <Display>
      <Label NLSID="wait_bottlenecks">Wait Bottlenecks</Label>
    </Display>

<ColumnDescriptor NAME="local_write_wait_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_local_write_wait_time">local_write_wait_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_reset_to_client_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_net_reset_to_client_time">net_reset_to_client_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_reset_to_dblink_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_net_reset_to_dblink_time">net_reset_to_dblink_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_dml_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_enqueue_dml_time">enqueue_dml_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_row_lock_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_enqueue_row_lock_time">enqueue_row_lock_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_userdef_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_enqueue_userdef_time">enqueue_userdef_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_file_sync_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_log_file_sync_time">log_file_sync_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="buffer_busy_waits_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_buffer_busy_waits_time">buffer_busy_waits_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="latch_cache_buffer_chains_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_latch_cache_buffer_chains_time">latch_cache_buffer_chains_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="latch_library_cache_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_latch_library_cache_time">latch_library_cache_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="library_cache_load_lock_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_library_cache_load_lock_time">library_cache_load_lock_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="library_cache_lock_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_library_cache_lock_time">library_cache_lock_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="library_cache_pin_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_library_cache_pin_time">library_cache_pin_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="pipe_put_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_pipe_put_time">pipe_put_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="row_cache_lock_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_row_cache_lock_time">row_cache_lock_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_hw_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_enqueue_hw_time">enqueue_hw_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_st_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_enqueue_st_time">enqueue_st_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_alloc_itl_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_enqueue_alloc_itl_time">enqueue_alloc_itl_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="free_buffer_waits_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_free_buffer_waits_time">free_buffer_waits_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="latch_redo_copy_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_latch_redo_copy_time">latch_redo_copy_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="latch_shared_pool_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_latch_shared_pool_time">latch_shared_pool_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_buffer_space_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_log_buffer_space_time">log_buffer_space_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_file_switch_arch_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_log_file_switch_arch_time">log_file_switch_arch_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_file_switch_ckpt_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_log_file_switch_ckpt_time">log_file_switch_ckpt_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_file_switch_complete_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_log_file_switch_complete_time">log_file_switch_complete_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_switch_arch_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_log_switch_arch_time">log_switch_arch_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="write_complete_waits_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_write_complete_waits_time">write_complete_waits_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_msg_to_client_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_net_msg_to_client_time">net_msg_to_client_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_msg_to_dblink_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_net_msg_to_dblink_time">net_msg_to_dblink_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_more_from_client_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_net_more_from_client_time">net_more_from_client_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_more_from_dblink_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_net_more_from_dblink_time">net_more_from_dblink_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_more_to_client_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_net_more_to_client_time">net_more_to_client_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_more_to_dblink_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_net_more_to_dblink_time">net_more_to_dblink_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="db_file_scattered_read_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_db_file_scattered_read_time">db_file_scattered_read_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="db_file_sequential_read_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_db_file_sequential_read_time">db_file_sequential_read_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="db_file_single_write_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_db_file_single_write_time">db_file_single_write_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="direct_path_read_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_direct_path_read_time">direct_path_read_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="direct_path_read_lob_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_direct_path_read_lob_time">direct_path_read_lob_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="direct_path_write_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_direct_path_write_time">direct_path_write_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="direct_path_write_lob_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_direct_path_write_lob_time">direct_path_write_lob_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="latch_free_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_latch_free_time">latch_free_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_enqueue_time">enqueue_time</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="user_wait_time" TYPE="NUMBER" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_user_wait_time">Wait Time (sec)</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="user_cpu_time" TYPE="NUMBER" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_user_cpu_time">CPU Time (sec)</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="userio_time" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_userio_wait_time">User I/O Wait Time (sec)</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="cpu_cnt" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
        <Display>
          <Label NLSID="wait_bottlenecks_cpu_cnt">CPU Count</Label>
        </Display>
      </ColumnDescriptor>

<ColumnDescriptor NAME="service_time_fg_delta" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP"
                        COMPUTE_EXPR="(_user_wait_time > user_wait_time) ? 0 : ((_user_cpu_time > user_cpu_time) ? 0 : (user_wait_time - _user_wait_time) + (user_cpu_time - _user_cpu_time))">
        <Display>
          <Label NLSID="wait_bottlenecks_service_time_fg">Service Time Delta (sec)</Label>
        </Display>
      </ColumnDescriptor>

<ColumnDescriptor NAME="local_write_wait_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(local_write_wait_time > _local_write_wait_time) ? 100*(local_write_wait_time - _local_write_wait_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_local_write_wait_pct">Local write wait (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_reset_to_client_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(net_reset_to_client_time > _net_reset_to_client_time) ? 100*(net_reset_to_client_time - _net_reset_to_client_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_net_reset_to_client_pct">SQL*Net break/reset to client (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_reset_to_dblink_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(net_reset_to_dblink_time > _net_reset_to_dblink_time) ? 100*(net_reset_to_dblink_time - _net_reset_to_dblink_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_net_reset_to_dblink_pct">SQL*Net break/reset to dblink (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_dml_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(enqueue_dml_time > _enqueue_dml_time) ? 100*(enqueue_dml_time - _enqueue_dml_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_enqueue_dml_pct">Enqueue: DML - contention (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_row_lock_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(enqueue_row_lock_time > _enqueue_row_lock_time) ? 100*(enqueue_row_lock_time - _enqueue_row_lock_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_enqueue_row_lock_pct">Enqueue: TM, TX, Transaction - row lock contention (%)</Label>
          <ShortName NLSID="wait_bottlenecks_enqueue_row_lock_pct_sht">Enqueue: TM, TX, Txn (%)</ShortName>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_userdef_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(enqueue_userdef_time > _enqueue_userdef_time) ? 100*(enqueue_userdef_time - _enqueue_userdef_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_enqueue_userdef_pct">Enqueue: UL: User-defined - contention (%)</Label>
          <ShortName NLSID="wait_bottlenecks_enqueue_userdef_pct_sht">Enqueue: UL (%)</ShortName>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_file_sync_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(log_file_sync_time > _log_file_sync_time) ? 100*(log_file_sync_time - _log_file_sync_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_log_file_sync_pct">Log file sync (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="buffer_busy_waits_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(buffer_busy_waits_time > _buffer_busy_waits_time) ? 100*(buffer_busy_waits_time - _buffer_busy_waits_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_buffer_busy_waits_pct">Buffer busy waits (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="latch_cache_buffer_chains_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(latch_cache_buffer_chains_time > _latch_cache_buffer_chains_time) ? 100*(latch_cache_buffer_chains_time - _latch_cache_buffer_chains_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_latch_cache_buffer_chains_pct">Latch: cache buffer chains (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="latch_library_cache_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(latch_library_cache_time > _latch_library_cache_time) ? 100*(latch_library_cache_time - _latch_library_cache_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_latch_library_cache_pct">Latch: library cache (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="library_cache_load_lock_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(library_cache_load_lock_time > _library_cache_load_lock_time) ? 100*(library_cache_load_lock_time - _library_cache_load_lock_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_library_cache_load_lock_pct">Library cache load lock (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="library_cache_lock_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(library_cache_lock_time > _library_cache_lock_time) ? 100*(library_cache_lock_time - _library_cache_lock_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_library_cache_lock_pct">Library cache lock (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="library_cache_pin_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(library_cache_pin_time > _library_cache_pin_time) ? 100*(library_cache_pin_time - _library_cache_pin_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_library_cache_pin_pct">Library cache pin (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="pipe_put_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(pipe_put_time > _pipe_put_time) ? 100*(pipe_put_time - _pipe_put_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_pipe_put_pct">Pipe put (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="row_cache_lock_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(row_cache_lock_time > _row_cache_lock_time) ? 100*(row_cache_lock_time - _row_cache_lock_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_row_cache_lock_pct">Row cache lock (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_hw_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(enqueue_hw_time > _enqueue_hw_time) ? 100*(enqueue_hw_time - _enqueue_hw_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_enqueue_hw_pct">Enqueue: HW, Segment High Water Mark - contention (%)</Label>
          <ShortName NLSID="wait_bottlenecks_enqueue_hw_pct_sht">Enqueue: HW Segment HWM (%)</ShortName>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_st_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(enqueue_st_time > _enqueue_st_time) ? 100*(enqueue_st_time - _enqueue_st_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_enqueue_st_pct">Enqueue: ST, Space Transaction - contention (%)</Label>
          <ShortName NLSID="wait_bottlenecks_enqueue_st_pct_sht">Enqueue: ST, Space Txn (%)</ShortName>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_alloc_itl_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(enqueue_alloc_itl_time > _enqueue_alloc_itl_time) ? 100*(enqueue_alloc_itl_time - _enqueue_alloc_itl_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_enqueue_alloc_itl_pct">Enqueue: TX mode 4, Transaction - allocate ITL entry (%)</Label>
          <ShortName NLSID="wait_bottlenecks_enqueue_alloc_itl_pct_sht">Enqueue: TX mode 4, Txn (%)</ShortName>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="free_buffer_waits_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(free_buffer_waits_time > _free_buffer_waits_time) ? 100*(free_buffer_waits_time - _free_buffer_waits_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_free_buffer_waits_pct">Free buffer waits (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="latch_redo_copy_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(latch_redo_copy_time > _latch_redo_copy_time) ? 100*(latch_redo_copy_time - _latch_redo_copy_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_latch_redo_copy_pct">Latch: redo copy (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="latch_shared_pool_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(latch_shared_pool_time > _latch_shared_pool_time) ? 100*(latch_shared_pool_time - _latch_shared_pool_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_latch_shared_pool_pct">Latch: shared pool (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_buffer_space_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(log_buffer_space_time > _log_buffer_space_time) ? 100*(log_buffer_space_time - _log_buffer_space_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_log_buffer_space_pct">Log buffer space (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_file_switch_arch_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(log_file_switch_arch_time > _log_file_switch_arch_time) ? 100*(log_file_switch_arch_time - _log_file_switch_arch_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_log_file_switch_arch_pct">Log file switch (archiving needed) (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_file_switch_ckpt_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(log_file_switch_ckpt_time > _log_file_switch_ckpt_time) ? 100*(log_file_switch_ckpt_time - _log_file_switch_ckpt_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_log_file_switch_ckpt_pct">Log file switch (checkpoint complete) (%)</Label>
          <ShortName NLSID="wait_bottlenecks_log_file_switch_ckpt_pct_sht">Log file switch (ckpt complete) (%)</ShortName>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_file_switch_complete_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(log_file_switch_complete_time > _log_file_switch_complete_time) ? 100*(log_file_switch_complete_time - _log_file_switch_complete_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_log_file_switch_complete_pct">Log file switch completion (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="log_switch_arch_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(log_switch_arch_time > _log_switch_arch_time) ? 100*(log_switch_arch_time - _log_switch_arch_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_log_switch_arch_pct">Log switch/archive (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="write_complete_waits_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(write_complete_waits_time > _write_complete_waits_time) ? 100*(write_complete_waits_time - _write_complete_waits_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_write_complete_waits_pct">Write complete waits (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_msg_to_client_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(net_msg_to_client_time > _net_msg_to_client_time) ? 100*(net_msg_to_client_time - _net_msg_to_client_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_net_msg_to_client_pct">SQL*Net message to client (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_msg_to_dblink_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(net_msg_to_dblink_time > _net_msg_to_dblink_time) ? 100*(net_msg_to_dblink_time - _net_msg_to_dblink_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_net_msg_to_dblink_pct">SQL*Net message to dblink (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_more_from_client_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(net_more_from_client_time > _net_more_from_client_time) ? 100*(net_more_from_client_time - _net_more_from_client_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_net_more_from_client_pct">SQL*Net more data from client (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_more_from_dblink_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(net_more_from_dblink_time > _net_more_from_dblink_time) ? 100*(net_more_from_dblink_time - _net_more_from_dblink_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_net_more_from_dblink_pct">SQL*Net more data from dblink (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_more_to_client_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(net_more_to_client_time > _net_more_to_client_time) ? 100*(net_more_to_client_time - _net_more_to_client_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_net_more_to_client_pct">SQL*Net more data to client (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="net_more_to_dblink_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(net_more_to_dblink_time > _net_more_to_dblink_time) ? 100*(net_more_to_dblink_time - _net_more_to_dblink_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_net_more_to_dblink_pct">SQL*Net more data to dblink (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="db_file_scattered_read_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(db_file_scattered_read_time > _db_file_scattered_read_time) ? 100*(db_file_scattered_read_time - _db_file_scattered_read_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_db_file_scattered_read_pct">DB file scattered read (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="db_file_sequential_read_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(db_file_sequential_read_time > _db_file_sequential_read_time) ? 100*(db_file_sequential_read_time - _db_file_sequential_read_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_db_file_sequential_read_pct">DB file sequential read (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="db_file_single_write_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(db_file_single_write_time > _db_file_single_write_time) ? 100*(db_file_single_write_time - _db_file_single_write_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_db_file_single_write_pct">DB file single write (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="direct_path_read_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(direct_path_read_time > _direct_path_read_time) ? 100*(direct_path_read_time - _direct_path_read_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_direct_path_read_pct">Direct path read (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="direct_path_read_lob_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(direct_path_read_lob_time > _direct_path_read_lob_time) ? 100*(direct_path_read_lob_time - _direct_path_read_lob_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_direct_path_read_lob_pct">Direct path read (lob) (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="direct_path_write_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(direct_path_write_time > _direct_path_write_time) ? 100*(direct_path_write_time - _direct_path_write_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_direct_path_write_pct">Direct path write (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="direct_path_write_lob_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(direct_path_write_lob_time > _direct_path_write_lob_time) ? 100*(direct_path_write_lob_time - _direct_path_write_lob_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_direct_path_write_lob_pct">Direct path write (lob) (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="latch_free_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(latch_free_time > _latch_free_time) ? 100*(latch_free_time - _latch_free_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_latch_free_pct">Latch free - other (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="enqueue_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(enqueue_time > _enqueue_time) ? 100*(enqueue_time - _enqueue_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_enqueue_pct">Enqueue - other (%)</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="user_wait_time_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(user_wait_time > _user_wait_time) ? 100*(user_wait_time - _user_wait_time)/service_time_fg_delta : 0">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_user_wait_time_pct">Wait Time (%)</Label>
          <ShortName NLSID="wait_bottlenecks_user_wait_time_pct_short">Wait Time %</ShortName>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="user_cpu_time_delta" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="_user_cpu_time > user_cpu_time ? (1/0) : user_cpu_time - _user_cpu_time">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_user_cpu_time_delta">CPU Time Delta (sec)</Label>
          <ShortName NLSID="wait_bottlenecks_user_cpu_time_delta_short">CPU (sec)</ShortName>
        </Display>
      </ColumnDescriptor>

<ColumnDescriptor NAME="wait_time_delta" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP"
                        COMPUTE_EXPR="_user_wait_time > user_wait_time ? (1/0) : user_wait_time - _user_wait_time">
        <Display>
          <Label NLSID="wait_bottlenecks_wait_time_delta">Wait Time Delta (sec)</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="userio_time_delta" TYPE="NUMBER" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP"
                        COMPUTE_EXPR="_userio_time > userio_time ? (1/0) : userio_time - _userio_time">
        <Display>
          <Label NLSID="wait_bottlenecks_wait_time_delta">User I/O Wait Time Delta (sec)</Label>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="active_sessions" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="service_time_fg_delta/__interval"
                        TRANSIENT="TRUE">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_active_sessions">Active Sessions</Label>

</Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="userio_wait_cnt" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="userio_time_delta/__interval">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_userio_wait_cnt">Active Sessions Waiting: I/O</Label>
          <ShortName NLSID="wait_bottlenecks_userio_wait_cnt_short">Sessions: I/O</ShortName>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="user_cpu_time_cnt" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="user_cpu_time_delta/__interval">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_user_cpu_time_cnt">Active Sessions Using CPU</Label>
          <ShortName NLSID="wait_bottlenecks_user_cpu_time_cnt_short">Sessions: CPU</ShortName>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="other_wait_cnt" TYPE="NUMBER"
                        COMPUTE_EXPR="active_sessions - user_cpu_time_cnt - userio_wait_cnt">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_other_wait_cnt">Active Sessions Waiting: Other</Label>
          <ShortName NLSID="wait_bottlenecks_other_wait_cnt_short">Sessions: Other</ShortName>
        </Display>
      </ColumnDescriptor>
      <ColumnDescriptor NAME="avg_user_cpu_time_pct" TYPE="NUMBER" IS_KEY="FALSE"
                        COMPUTE_EXPR="(user_cpu_time_delta/(__interval*cpu_cnt)*100) > 100 ? 100 : (user_cpu_time_delta/(__interval*cpu_cnt)*100)">
        <Display FOR_SUMMARY_UI="TRUE">
          <Label NLSID="wait_bottlenecks_avg_user_cpu_time_pct">Average Instance CPU (%)</Label>
          <ShortName NLSID="wait_bottlenecks_avg_user_cpu_time_pct_short">Instance CPU (%)</ShortName>
        </Display>
      </ColumnDescriptor>

</TableDescriptor>

<QueryDescriptor FETCHLET_ID="SQL">
      <Property NAME="STATEMENT" SCOPE="GLOBAL">
<![CDATA[
DECLARE
  local_write_wait_time          NUMBER := NULL;
  net_reset_to_client_time       NUMBER := NULL;
  net_reset_to_dblink_time       NUMBER := NULL;
  enqueue_dml_time               NUMBER := NULL;
  enqueue_row_lock_time          NUMBER := NULL;
  enqueue_userdef_time           NUMBER := NULL;
  log_file_sync_time             NUMBER := NULL;
  buffer_busy_waits_time         NUMBER := NULL;
  latch_cache_buffer_chains_time NUMBER := NULL;
  latch_library_cache_time       NUMBER := NULL;
  library_cache_load_lock_time   NUMBER := NULL;
  library_cache_lock_time        NUMBER := NULL;
  library_cache_pin_time         NUMBER := NULL;
  pipe_put_time                  NUMBER := NULL;
  row_cache_lock_time            NUMBER := NULL;
  enqueue_hw_time                NUMBER := NULL;
  enqueue_st_time                NUMBER := NULL;
  enqueue_alloc_itl_time         NUMBER := NULL;
  free_buffer_waits_time         NUMBER := NULL;
  latch_redo_copy_time           NUMBER := NULL;
  latch_shared_pool_time         NUMBER := NULL;
  log_buffer_space_time          NUMBER := NULL;
  log_file_switch_arch_time      NUMBER := NULL;
  log_file_switch_ckpt_time      NUMBER := NULL;
  log_file_switch_complete_time  NUMBER := NULL;
  log_switch_arch_time           NUMBER := NULL;
  write_complete_waits_time      NUMBER := NULL;
  net_msg_to_client_time         NUMBER := NULL;
  net_msg_to_dblink_time         NUMBER := NULL;
  net_more_from_client_time      NUMBER := NULL;
  net_more_from_dblink_time      NUMBER := NULL;
  net_more_to_client_time        NUMBER := NULL;
  net_more_to_dblink_time        NUMBER := NULL;
  db_file_scattered_read_time    NUMBER := NULL;
  db_file_sequential_read_time   NUMBER := NULL;
  db_file_single_write_time      NUMBER := NULL;
  direct_path_read_time          NUMBER := NULL;
  direct_path_read_lob_time      NUMBER := NULL;
  direct_path_write_time         NUMBER := NULL;
  direct_path_write_lob_time     NUMBER := NULL;
  latch_free_time                NUMBER := NULL;
  enqueue_time                   NUMBER := NULL;
  user_wait_time                 NUMBER := NULL;
  user_cpu_time                  NUMBER := NULL;
  userio_time                    NUMBER := NULL;
  cpu_cnt                        NUMBER       := :1;
  timed_statistics               VARCHAR2(16) := :2;

TYPE userio_type IS TABLE OF VARCHAR2(64);
  userio userio_type := userio_type('BFILE read', 'buffer read retry', 'db file parallel read', 'db file scattered read', 'db file sequential read', 'db file single write', 'direct path read', 'direct path read (lob)', 'direct path write', 'direct path write (lob)' );

TYPE        data_cursor_type IS REF CURSOR;
  data_cursor data_cursor_type;

BEGIN

IF timed_statistics = 'TRUE' THEN

----
    -- initialize the time breakdown accumulators
    ----
    user_wait_time := 0;
    userio_time := 0;

----
    -- get CPU time (total)
    ----
    SELECT NVL(value, 0)/100
      INTO user_cpu_time
      FROM v$sysstat
     WHERE statistic# = (SELECT statistic#
                           FROM v$statname
                          WHERE name = 'CPU used when call started');

----
    -- get wait time (total)
    -- deduct idle waits and purely background waits
    ----
    FOR event_time_pair IN
      (SELECT event, time_waited/100 time_waited
         FROM v$system_event
        WHERE event NOT IN
             ('ARCH random i/o',
              'ARCH sequential i/o',
              'KXFX: execution message dequeue - Slaves',
              'LGWR random i/o',
              'LGWR sequential i/o',
              'LGWR wait for redo copy',
              'Null event',
              'PL/SQL lock timer',
              'PX Deq Credit: need buffer',
              'PX Deq: Execute Reply',
              'PX Deq: Execution Msg',
              'PX Deq: Index Merge Close',
              'PX Deq: Index Merge Execute',
              'PX Deq: Index Merge Reply',
              'PX Deq: Join ACK',
              'PX Deq: Msg Fragment',
              'PX Deq: Par Recov Change Vector',
              'PX Deq: Par Recov Execute',
              'PX Deq: Par Recov Reply',
              'PX Deq: Parse Reply',
              'PX Deq: Table Q Normal',
              'PX Deq: Table Q Sample',
              'PX Deq: Txn Recovery Reply',
              'PX Deq: Txn Recovery Start',
              'PX Deque wait',
              'PX Idle Wait',
              'Queue Monitor Shutdown Wait',
              'Queue Monitor Slave Wait',
              'Queue Monitor Wait',
              'RFS random i/o',
              'RFS sequential i/o',
              'RFS write',
              'SQL*Net message from client',
              'SQL*Net message from dblink',
              'STREAMS apply coord waiting for slave message',
              'STREAMS apply coord waiting for some work to finish',
              'STREAMS apply slave idle wait',
              'STREAMS capture process filter callback wait for ruleset',
              'STREAMS fetch slave waiting for txns',
              'WMON goes to sleep',
              'async disk IO',
              'client message',
              'control file parallel write',
              'control file sequential read',
              'control file single write',
              'db file single write',
              'db file parallel write',
              'dispatcher timer',
              'gcs log flush sync',
              'gcs remote message',
              'ges reconfiguration to start',
              'ges remote message',
              'io done',
              'jobq slave wait',
              'lock manager wait for remote message',
              'log file parallel write',
              'log file sequential read',
              'log file single write',
              'parallel dequeue wait',
              'parallel recovery coordinator waits for cleanup of slaves',
              'parallel query dequeue',
              'parallel query idle wait - Slaves',
              'pipe get',
              'pmon timer',
              'queue messages',
              'rdbms ipc message',
              'recovery read',
              'single-task message',
              'slave wait',
              'smon timer',
              'statement suspended, wait error to be cleared',
              'unread message',
              'virtual circuit',
              'virtual circuit status',
              'wait for activate message',
              'wait for transaction',
              'wait for unread message on broadcast channel',
              'wait for unread message on multiple broadcast channels',
              'wakeup event for builder',
              'wakeup event for preparer',
              'wakeup event for reader',
              'wakeup time manager'))
    LOOP

IF event_time_pair.event = 'SQL*Net break/reset to client' THEN
        net_reset_to_client_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'SQL*Net break/reset to dblink' THEN
        net_reset_to_dblink_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'SQL*Net message to client' THEN
        net_msg_to_client_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'SQL*Net message to dblink' THEN
        net_msg_to_dblink_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'SQL*Net more data from client' THEN
        net_more_from_client_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'SQL*Net more data from dblink' THEN
        net_more_from_dblink_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'SQL*Net more data to client' THEN
        net_more_to_client_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'SQL*Net more data to dblink' THEN
        net_more_to_dblink_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'buffer busy waits' THEN
        buffer_busy_waits_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'db file scattered read' THEN
        db_file_scattered_read_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'db file sequential read' THEN
        db_file_sequential_read_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'db file single write' THEN
        db_file_single_write_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'direct path read' THEN
        direct_path_read_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'direct path read (lob)' THEN
        direct_path_read_lob_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'direct path write' THEN
        direct_path_write_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'direct path write (lob)' THEN
        direct_path_write_lob_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'enqueue: DML - contention' THEN
        enqueue_dml_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'enqueue: HW, Segment High Water Mark - contention' THEN
        enqueue_hw_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'enqueue: ST, Space Transaction - contention' THEN
        enqueue_st_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'enqueue: TM,TX, Transaction - row lock contention' THEN
        enqueue_row_lock_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'enqueue: TX mode 4, Transaction - allocate ITL entry' THEN
        enqueue_alloc_itl_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'enqueue: UL: User-defined - contention' THEN
        enqueue_userdef_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event LIKE 'enqueue%' THEN
        enqueue_time := NVL(enqueue_time, 0) + event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'free buffer waits' THEN
        free_buffer_waits_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'latch: cache buffers chains' THEN
        latch_cache_buffer_chains_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'latch: library cache' THEN
        latch_library_cache_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'latch: redo copy' THEN
        latch_redo_copy_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'latch: shared pool' THEN
        latch_shared_pool_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event LIKE 'latch%' THEN
        latch_free_time := NVL(latch_free_time, 0) + event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'library cache load lock' THEN
        library_cache_load_lock_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'library cache lock' THEN
        library_cache_lock_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'library cache pin' THEN
        library_cache_pin_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'local write wait' THEN
        local_write_wait_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'log buffer space' THEN
        log_buffer_space_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'log file switch (archiving needed)' THEN
        log_file_switch_arch_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'log file switch (checkpoint incomplete)' THEN
        log_file_switch_ckpt_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'log file switch completion' THEN
        log_file_switch_complete_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'log file sync' THEN
        log_file_sync_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'log switch/archive' THEN
        log_file_switch_arch_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'pipe put' THEN
        pipe_put_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'row cache lock' THEN
        row_cache_lock_time := event_time_pair.time_waited;
      ELSIF event_time_pair.event = 'write complete waits' THEN
        write_complete_waits_time := event_time_pair.time_waited;
      END IF;

----
      -- add to the accumulated wait time
      ----
      user_wait_time := user_wait_time + event_time_pair.time_waited;

-- compute the user io wait time
      FOR i IN userio.FIRST .. userio.LAST
      LOOP
        IF userio(i) = event_time_pair.event THEN
          userio_time := userio_time + event_time_pair.time_waited;
        END IF;
      END LOOP;
    END LOOP;

-- open the cursor to return
    OPEN data_cursor FOR
      SELECT local_write_wait_time,
             net_reset_to_client_time,
             net_reset_to_dblink_time,
             enqueue_dml_time,
             enqueue_row_lock_time,
             enqueue_userdef_time,
             log_file_sync_time,
             buffer_busy_waits_time,
             latch_cache_buffer_chains_time,
             latch_library_cache_time,
             library_cache_load_lock_time,
             library_cache_lock_time,
             library_cache_pin_time,
             pipe_put_time,
             row_cache_lock_time,
             enqueue_hw_time,
             enqueue_st_time,
             enqueue_alloc_itl_time,
             free_buffer_waits_time,
             latch_redo_copy_time,
             latch_shared_pool_time,
             log_buffer_space_time,
             log_file_switch_arch_time,
             log_file_switch_ckpt_time,
             log_file_switch_complete_time,
             log_switch_arch_time,
             write_complete_waits_time,
             net_msg_to_client_time,
             net_msg_to_dblink_time,
             net_more_from_client_time,
             net_more_from_dblink_time,
             net_more_to_client_time,
             net_more_to_dblink_time,
             db_file_scattered_read_time,
             db_file_sequential_read_time,
             db_file_single_write_time,
             direct_path_read_time,
             direct_path_read_lob_time,
             direct_path_write_time,
             direct_path_write_lob_time,
             latch_free_time,
             enqueue_time,
             user_wait_time,
             user_cpu_time,
             userio_time,
             cpu_cnt

FROM dual;

ELSE

FROM dual
       WHERE 0 = 1;

END IF;

:3 := data_cursor;

END;
]]>
      </Property>
      <Property NAME="SQLINPARAM1" SCOPE="INSTANCE">CPUCount</Property>
      <Property NAME="SQLINPARAM2" SCOPE="INSTANCE">TimedStatistics</Property>
      <Property NAME="SQLOUTPARAMPOS" SCOPE="GLOBAL">3</Property>
      <Property NAME="SQLOUTPARAMTYPE" SCOPE="GLOBAL">SQL_CURSOR</Property>
      <Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
      <Property NAME="Port" SCOPE="INSTANCE">Port</Property>
      <Property NAME="SID" SCOPE="INSTANCE" OPTIONAL="TRUE">SID</Property>
      <Property NAME="UserName" SCOPE="INSTANCE">UserName</Property>
      <Property NAME="password" SCOPE="INSTANCE">password</Property>
      <Property NAME="Role" SCOPE="INSTANCE" OPTIONAL="TRUE">Role</Property>
    </QueryDescriptor>
  </Metric>

<Metric NAME="dumpFull" TYPE="TABLE">
		<Display>
			<Label NLSID="dump">Dump Area</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="dumpType" TYPE="STRING" IS_KEY="TRUE">
				<Display>
					<Label NLSID="dump_dumpType">Type of Dump Area</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="dumpDir" TYPE="STRING" IS_KEY="FALSE">
				<Display>
					<Label NLSID="dump_dumpDir">Dump Area Directory</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="dumpTotal" TYPE="NUMBER" IS_KEY="FALSE">
				<Display>
					<Label NLSID="dump_dumpTotal">Total Dump Area (KB)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="dumpUsed" TYPE="NUMBER" IS_KEY="FALSE">
				<Display>
					<Label NLSID="dump_dumpUsed">Dump Area Used (KB)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="dumpUsedPercent" TYPE="NUMBER" IS_KEY="FALSE">
				<Display>
					<Label NLSID="dump_dumpUsedPercent">Dump Area Used (%)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="dumpAvail" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="dumpTotal - dumpUsed">
				<Display>
					<Label NLSID="dump_dumpAvail">Free Dump Area (KB)</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="OSLineToken">
			<Property NAME="perlBin" SCOPE="SYSTEMGLOBAL">perlBin</Property>
			<Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
			<Property NAME="background_dump_dest" SCOPE="INSTANCE">background_dump_dest</Property>
			<Property NAME="core_dump_dest" SCOPE="INSTANCE">core_dump_dest</Property>
			<Property NAME="user_dump_dest" SCOPE="INSTANCE">user_dump_dest</Property>
			<Property NAME="command" SCOPE="GLOBAL">
             %perlBin%/perl %scriptsDir%/db/dbdumpfull.pl %background_dump_dest% %core_dump_dest% %user_dump_dest%
      </Property>
			<Property NAME="startsWith" SCOPE="GLOBAL">em_result=</Property>
			<Property NAME="delimiter" SCOPE="GLOBAL">|</Property>
			<Property NAME="ENVEM_TARGET_NAME" SCOPE="INSTANCE">NAME</Property>
			<Property NAME="ENVEM_TARGET_ROLE" SCOPE="INSTANCE" OPTIONAL="TRUE">Role</Property>
			<Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
			<Property NAME="Port" SCOPE="INSTANCE">Port</Property>
			<Property NAME="SID" SCOPE="INSTANCE">SID</Property>
			<Property NAME="ENVEM_TARGET_ADDRESS" SCOPE="GLOBAL">(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%MachineName%)(Port=%Port%))(CONNECT_DATA=(SID=%SID%)))
      </Property>
			<Property NAME="ENVEM_TARGET_ORACLE_HOME" SCOPE="INSTANCE">OracleHome</Property>
		</QueryDescriptor>
	</Metric>
     
	<Metric NAME="archFull" TYPE="TABLE">
		<Display>
			<Label NLSID="arch">Archive Area</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="archDir" TYPE="STRING" IS_KEY="TRUE">
				<Display>
					<Label NLSID="arch_archDir">Archive Area Destination</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="archTotal" TYPE="NUMBER" IS_KEY="FALSE">
				<Display>
					<Label NLSID="arch_archTotal">Total Archive Area (KB)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="archUsed" TYPE="NUMBER" IS_KEY="FALSE">
				<Display>
					<Label NLSID="arch_archUsed">Archive Area Used (KB)</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="archUsedPercent" TYPE="NUMBER" IS_KEY="FALSE">
				<Display>
					<Label NLSID="arch_archUsedPercent">Archive Area Used (%)</Label>
					<ShortName NLSID="arch_archUsedPercent_short">Archive Area %</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="archAvail" TYPE="NUMBER" IS_KEY="FALSE" COMPUTE_EXPR="archTotal - archUsed">
				<Display>
					<Label NLSID="arch_archAvail">Free Archive Area (KB)</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="OSLineToken">
			<Property NAME="perlBin" SCOPE="SYSTEMGLOBAL">perlBin</Property>
			<Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
			<Property NAME="command" SCOPE="GLOBAL">
             %perlBin%/perl %scriptsDir%/db/dbarchfull.pl
      </Property>
			<Property NAME="startsWith" SCOPE="GLOBAL">em_result=</Property>
			<Property NAME="delimiter" SCOPE="GLOBAL">|</Property>
			<Property NAME="ENVEM_TARGET_NAME" SCOPE="INSTANCE">NAME</Property>
			<Property NAME="STDINEM_TARGET_USERNAME" SCOPE="INSTANCE">UserName</Property>
			<Property NAME="STDINEM_TARGET_PASSWORD" SCOPE="INSTANCE">password</Property>
			<Property NAME="ENVEM_TARGET_ROLE" SCOPE="INSTANCE" OPTIONAL="TRUE">Role</Property>
			<Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
			<Property NAME="Port" SCOPE="INSTANCE">Port</Property>
			<Property NAME="SID" SCOPE="INSTANCE">SID</Property>
			<Property NAME="ENVEM_TARGET_ADDRESS" SCOPE="GLOBAL">(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%MachineName%)(Port=%Port%))(CONNECT_DATA=(SID=%SID%)))
      </Property>
			<Property NAME="ENVEM_TARGET_ORACLE_HOME" SCOPE="INSTANCE">OracleHome</Property>
		</QueryDescriptor>
	</Metric>

<Metric NAME="Response" TYPE="TABLE">
		<Display>
			<Label NLSID="resp">Response</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="userLogon" TYPE="NUMBER" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="resp_userLogon">User Logon Time (msec)</Label>
					<ShortName NLSID="resp_userLogon_short">Logon Time(ms)</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="Status" TYPE="NUMBER" IS_KEY="FALSE">
				<Display>
					<Label NLSID="resp_status">Status</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="State" TYPE="STRING" IS_KEY="FALSE">
				<Display>
					<Label NLSID="resp_state">State</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="oraerr" TYPE="STRING" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="resp_oraerr">ORA- Error</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="OSLineToken">
			<Property NAME="perlBin" SCOPE="SYSTEMGLOBAL">perlBin</Property>
			<Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
			<Property NAME="command" SCOPE="GLOBAL">
         %perlBin%/perl %scriptsDir%/db/dbresp.pl
      </Property>
			<Property NAME="startsWith" SCOPE="GLOBAL">em_result=</Property>
			<Property NAME="delimiter" SCOPE="GLOBAL">|</Property>
			<Property NAME="ENVEM_TARGET_NAME" SCOPE="INSTANCE">NAME</Property>
			<Property NAME="STDINEM_TARGET_USERNAME" SCOPE="INSTANCE">UserName</Property>
			<Property NAME="STDINEM_TARGET_PASSWORD" SCOPE="INSTANCE">password</Property>
			<Property NAME="ENVEM_TARGET_ROLE" SCOPE="INSTANCE" OPTIONAL="TRUE">Role</Property>
			<Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
			<Property NAME="Port" SCOPE="INSTANCE">Port</Property>
			<Property NAME="SID" SCOPE="INSTANCE">SID</Property>
			<Property NAME="ENVEM_TARGET_ORACLE_HOME" SCOPE="INSTANCE">OracleHome</Property>
			<Property NAME="ENVEM_TARGET_ADDRESS" SCOPE="GLOBAL">(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=%MachineName%)(Port=%Port%))(CONNECT_DATA=(SID=%SID%)))
      </Property>
		</QueryDescriptor>
	</Metric>
        
	<Metric NAME="Database_Resource_Usage" TYPE="TABLE">
		<ValidIf>
			<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
		</ValidIf>
		<Display>
			<Label NLSID="resource_usage">Database Limits</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="lock_usage" TYPE="NUMBER" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="lock_usage_name">Lock Limit Usage (%)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="process_usage" TYPE="NUMBER" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="process_usage">Process Limit Usage (%)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="session_usage" TYPE="NUMBER" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="session_usage">Session Limit Usage (%)</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="user_limit" TYPE="NUMBER" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="user_limit">User Limit Usage (%)</Label>

</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="SQL">
			<Property NAME="transpose" SCOPE="GLOBAL">TRUE</Property>
			<Property NAME="STATEMENT" SCOPE="GLOBAL"><![CDATA[
     SELECT usage
     FROM (select RESOURCE_NAME name, 100*DECODE(initial_allocation,' UNLIMITED',0, current_utilization /
             initial_allocation) usage
           from v$resource_limit
           where LTRIM(limit_value) != '0' and LTRIM(initial_allocation) != '0'
             and resource_name in ('dml_locks', 'processes', 'sessions')
           union all
             select  'user'  name
                ,100* DECODE(sessions_max,0,0,sessions_current/sessions_max)  usage
             from v$license
           )
     order by name
]]></Property>
			<Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
			<Property NAME="Port" SCOPE="INSTANCE">Port</Property>
			<Property NAME="SID" SCOPE="INSTANCE">SID</Property>
			<Property NAME="UserName" SCOPE="INSTANCE">UserName</Property>
			<Property NAME="password" SCOPE="INSTANCE">password</Property>
			<Property NAME="Role" SCOPE="INSTANCE" OPTIONAL="TRUE">Role</Property>
		</QueryDescriptor>
	</Metric>
        
 	<Metric NAME="alertLog" TYPE="TABLE">
		<ValidIf>
			<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2;10gR1;10gR2;10gR203"/>
		</ValidIf>
		<Display>
			<Label NLSID="alertLog">Alert Log</Label>
		</Display>
		<TableDescriptor>
                        <ColumnDescriptor NAME="alertTime" TYPE="STRING" IS_TIMESTAMP="TRUE" TRANSIENT="TRUE" HELP="NO_HELP">
                                <Display>
                                        <Label NLSID="alert_time">Alert Time</Label>
                                </Display>
                        </ColumnDescriptor>
			<ColumnDescriptor NAME="timeLine" TYPE="STRING" IS_KEY="TRUE">
				<Display>
					<Label NLSID="alertLog_timeLine">Time/Line Number</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="genericErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display>
					<Label NLSID="alertLog_genericErrStack">Generic Alert Log Error</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="archiveHungErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display>
					<Label NLSID="alertLog_archiveHungErrStack">Archiver Hung Alert Log Error</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="blockCorruptErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display>
					<Label NLSID="alertLog_blockCorruptErrStack">Data Block Corruption Alert Log Error</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sessTerminateErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display>
					<Label NLSID="alertLog_sessTerminateErrStack">Session Terminated Alert Log Error</Label>
				</Display>
			</ColumnDescriptor>
      <ColumnDescriptor NAME="mediaFailureErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
        <Display>
          <Label NLSID="alertLog_mediaFailureErrStack">Media Failure Alert Log Error</Label>
        </Display>
      </ColumnDescriptor>
			<ColumnDescriptor NAME="traceFileName" TYPE="STRING" IS_KEY="FALSE">
				<Display>
					<Label NLSID="alertLog_traceFileName">Alert Log Error Trace File</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="errCodes" TYPE="STRING" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display>
					<Label NLSID="alertLog_errCodes">Witnessed Error Codes</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="alertLogName" TYPE="STRING" IS_KEY="FALSE">
				<Display>
					<Label NLSID="alertLog_fileName">Alert Log Name</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="OSLineToken">
			<Property NAME="perlBin" SCOPE="SYSTEMGLOBAL">perlBin</Property>
			<Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
			<Property NAME="startsWith" SCOPE="GLOBAL">em_result=</Property>
			<Property NAME="delimiter" SCOPE="GLOBAL">|</Property>
                        <Property NAME="log_file_absolute" SCOPE="INSTANCE">alert_log_file</Property>
                        <Property NAME="log_timestamp_format" SCOPE="GLOBAL"><![CDATA[(\w+) (\w+)( |  )31 023:059:059 02037]]></Property>
			<Property NAME="background_dump_dest" SCOPE="INSTANCE">background_dump_dest</Property>
			<Property NAME="user_dump_dest" SCOPE="INSTANCE">user_dump_dest</Property>
			<Property NAME="limitSwitch" SCOPE="USER">limitSwitch</Property>
			<Property NAME="ignorePattern" SCOPE="USER" OPTIONAL="TRUE">ignorePattern</Property>
			<Property NAME="command" SCOPE="GLOBAL">
%perlBin%/perl %scriptsDir%/alertlog.pl %log_file_absolute% '%log_timestamp_format%' 'ORA' %background_dump_dest% %user_dump_dest% %limitSwitch% %ignorePattern%
                        </Property>
                        <Property NAME="ConvertFromCharset" SCOPE="INSTANCE" OPTIONAL="TRUE">ConvertFromCharset</Property>
                        <Property NAME="needCharsetConvert" SCOPE="INSTANCE" OPTIONAL="TRUE">needCharsetConvert</Property>

<Property NAME="ENVEM_TARGET_GUID" SCOPE="INSTANCE">GUID</Property>
			<Property NAME="ENVEM_TARGET_ORACLE_HOME" SCOPE="INSTANCE">OracleHome</Property>
			<Property NAME="ENVEM_TARGET_ORACLE_SID" SCOPE="INSTANCE">SID</Property>
                        <Property NAME="ENVEM_AGENT_STATE_DIR" SCOPE="SYSTEMGLOBAL">agentStateDir</Property>
                        <Property NAME="ENVEM_ALERTLOG_ERROR_TYPES" SCOPE="GLOBAL">4</Property>
                        <Property NAME="ENVEM_ALERTLOG_ERROR_TYPE1" SCOPE="GLOBAL">00257,16038</Property>
                        <Property NAME="ENVEM_ALERTLOG_ERROR_TYPE2" SCOPE="GLOBAL">01157,01578,27048</Property>
                        <Property NAME="ENVEM_ALERTLOG_ERROR_TYPE3" SCOPE="GLOBAL">00603</Property>
                        <Property NAME="ENVEM_ALERTLOG_ERROR_TYPE4" SCOPE="GLOBAL">01242,01243</Property>		                   
 		</QueryDescriptor>
	</Metric>
    
	<Metric NAME="alertLogStatus" TYPE="TABLE">
		<ValidIf>
			<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2;10gR1;10gR2;10gR203"/>
		</ValidIf>
		<Display>
			<Label NLSID="alertLogStatus">Alert Log Error Status</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="genericErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="alertLogStatus_genericErrors">Generic Alert Log Error Status</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="archiveHungErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="alertLogStatus_archiveHungErrors">Archiver Hung Alert Log Error Status</Label>

</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="blockCorruptErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="alertLogStatus_blockCorruptErrors">Data Block Corruption Alert Log Error Status</Label>
					<ShortName NLSID="alertLogStatus_blockCorruptErrors_sht">Data Block Corruption Error Status</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sessTerminateErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="alertLogStatus_sessTerminateErrors">Session Terminated Alert Log Error Status</Label>
					<ShortName NLSID="alertLogStatus_sessTerminateErrors_sht">Session Terminated Error Status</ShortName>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="mediaFailureErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="alertLogStatus_mediaFailureErrors">Media Failure Alert Log Error Status</Label>
					<ShortName NLSID="alertLogStatus_mediaFailureErrors_sht">Media Failure Error Status</ShortName>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<ExecutionDescriptor>
			<GetTable NAME="alert_log_errors" METRIC_NAME="alertLog" USE_CACHE="TRUE"/>
			<GetView NAME="generic_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="genericErrStack"/>
				<Filter COLUMN_NAME="genericErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="generic_alert_log_rollup" FROM_TABLE="generic_alert_log_errors">
				<AggregateColumn NAME="genericErrors" COLUMN_NAME="genericErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="archive_hung_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="archiveHungErrStack"/>
				<Filter COLUMN_NAME="archiveHungErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="archive_hung_alert_log_rollup" FROM_TABLE="archive_hung_alert_log_errors">
				<AggregateColumn NAME="archiveHungErrors" COLUMN_NAME="archiveHungErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="block_corrupt_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="blockCorruptErrStack"/>
				<Filter COLUMN_NAME="blockCorruptErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="block_corrupt_alert_log_rollup" FROM_TABLE="block_corrupt_alert_log_errors">
				<AggregateColumn NAME="blockCorruptErrors" COLUMN_NAME="blockCorruptErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="sess_terminate_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="sessTerminateErrStack"/>
				<Filter COLUMN_NAME="sessTerminateErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="sess_terminate_alert_log_rollup" FROM_TABLE="sess_terminate_alert_log_errors">
				<AggregateColumn NAME="sessTerminateErrors" COLUMN_NAME="sessTerminateErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="media_failure_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="mediaFailureErrStack"/>
				<Filter COLUMN_NAME="mediaFailureErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="media_failure_alert_log_rollup" FROM_TABLE="media_failure_alert_log_errors">
				<AggregateColumn NAME="mediaFailureErrors" COLUMN_NAME="mediaFailureErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<JoinTables NAME="alertLogStatus">
				<Table NAME="generic_alert_log_rollup"/>
				<Table NAME="archive_hung_alert_log_rollup"/>
				<Table NAME="block_corrupt_alert_log_rollup"/>
				<Table NAME="sess_terminate_alert_log_rollup"/>
				<Table NAME="media_failure_alert_log_rollup"/>
			</JoinTables>
		</ExecutionDescriptor>
	</Metric>

<Metric NAME="adrAlertLogError" TYPE="TABLE" USAGE_TYPE="HIDDEN_COLLECT" HELP="NO_HELP">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR1;11gR2"/>
    </ValidIf>
		<TableDescriptor>
			<ColumnDescriptor NAME="timeLine" TYPE="STRING" IS_KEY="TRUE"/>
			<ColumnDescriptor NAME="errorCategory" TYPE="STRING" IS_KEY="FALSE"/>

<ColumnDescriptor NAME="genericInternalErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="sessTerminateErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="internalSqlErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="accessViolationErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="redoLogCorruptErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="fileAccessErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="inconsistentDbStateErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="oraBlockCorruptErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="deadlockErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="outOfMemoryErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="clusterErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			
			<ColumnDescriptor NAME="genericIncidentErrStack" TYPE="STRING" IS_KEY="FALSE"/>

<ColumnDescriptor NAME="dataFailureErrStack" TYPE="STRING" IS_KEY="FALSE"/>

<ColumnDescriptor NAME="archiveHungErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="blockCorruptErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="mediaFailureErrStack" TYPE="STRING" IS_KEY="FALSE"/>
			
			<ColumnDescriptor NAME="genericOperationalErrStack" TYPE="STRING" IS_KEY="FALSE"/>

<ColumnDescriptor NAME="traceFileName" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="errCodes" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="alertLogName" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="impact" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="incidentId" TYPE="STRING" IS_KEY="FALSE"/>
			<ColumnDescriptor NAME="numberOfFailures" TYPE="STRING" IS_KEY="FALSE"/>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="OSLineToken">
			<Property NAME="perlBin" SCOPE="SYSTEMGLOBAL">perlBin</Property>
			<Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
			<Property NAME="startsWith" SCOPE="GLOBAL">em_result=</Property>
			<Property NAME="delimiter" SCOPE="GLOBAL">|</Property>
			<Property NAME="AdrHome" SCOPE="INSTANCE">AdrHome</Property>
			<Property NAME="limitSwitch" SCOPE="USER">limitSwitch</Property>
			<Property NAME="command" SCOPE="GLOBAL">
				%perlBin%/perl %scriptsDir%/alertlogAdr.pl %AdrHome% %limitSwitch%
			</Property>
			<Property NAME="ConvertFromCharset" SCOPE="INSTANCE">ConvertFromCharset</Property>
			<Property NAME="needCharsetConvert" SCOPE="INSTANCE">needCharsetConvert</Property>

<Property NAME="ENVEM_TARGET_GUID" SCOPE="INSTANCE">GUID</Property>
			<Property NAME="ENVEM_AGENT_STATE_DIR" SCOPE="SYSTEMGLOBAL">agentStateDir</Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPES" SCOPE="GLOBAL">17</Property>
			
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE1" SCOPE="GLOBAL"><![CDATA[incident,type=["']INCIDENT_ERROR["'],group=["']Generic Internal Error["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE2" SCOPE="GLOBAL"><![CDATA[incident,type=["']INCIDENT_ERROR["'],group=["']Session Terminated["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE3" SCOPE="GLOBAL"><![CDATA[incident,type=["']INCIDENT_ERROR["'],group=["']Internal SQL Error["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE4" SCOPE="GLOBAL"><![CDATA[incident,type=["']INCIDENT_ERROR["'],group=["']Access Violation["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE5" SCOPE="GLOBAL"><![CDATA[incident,type=["']INCIDENT_ERROR["'],group=["']Redo Log Corruption["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE6" SCOPE="GLOBAL"><![CDATA[incident,type=["']INCIDENT_ERROR["'],group=["']File Access Error["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE7" SCOPE="GLOBAL"><![CDATA[incident,type=["']INCIDENT_ERROR["'],group=["']Inconsistent DB State["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE8" SCOPE="GLOBAL"><![CDATA[incident,type=["']INCIDENT_ERROR["'],group=["']Data Block Corruption["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE9" SCOPE="GLOBAL"><![CDATA[incident,type=["']INCIDENT_ERROR["'],group=["']Deadlock["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE10" SCOPE="GLOBAL"><![CDATA[incident,type=["']INCIDENT_ERROR["'],group=["']Out of Memory["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE11" SCOPE="GLOBAL"><![CDATA[incident,type=["']INCIDENT_ERROR["'],group=["']Cluster Error["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE12" SCOPE="GLOBAL"><![CDATA[incident,level=["'][12]["'],type=["']INCIDENT_ERROR["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE13" SCOPE="GLOBAL"><![CDATA[dataFailure,type=["']ERROR["'],group=["']DRA["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE14" SCOPE="GLOBAL"><![CDATA[operational,type=["']ERROR["'],group=["']Archiver Hung["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE15" SCOPE="GLOBAL"><![CDATA[operational,type=["']ERROR["'],group=["']Data Block Corruption["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE16" SCOPE="GLOBAL"><![CDATA[operational,type=["']ERROR["'],group=["']Media Failure["']]]></Property>
			<Property NAME="ENVEM_ALERTLOG_ERROR_TYPE17" SCOPE="GLOBAL"><![CDATA[operational,level=["'][12]["'],type=["']ERROR["']]]></Property>
 		</QueryDescriptor>
	</Metric>

<Metric NAME="adrAlertLogIncidentError" TYPE="TABLE">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR1;11gR2"/>
    </ValidIf>
		<Display>
			<Label NLSID="adrAlertLogIncidentError">Incident</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="timeLine" TYPE="STRING" IS_KEY="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_timeLine">Time/Line Number</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="genericIncidentErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_genericIncidentErrStack">Generic Incident</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="genericInternalErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_genericInternalErrStack">Generic Internal Error</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sessTerminateErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_sessTerminateErrStack">Session Terminated</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="internalSqlErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_internalSqlErrStack">Internal SQL Error</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="accessViolationErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_accessViolationErrStack">Access Violation</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="redoLogCorruptErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_redoLogCorruptErrStack">Redo Log Corruption</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="fileAccessErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_fileAccessErrStack">File Access Error</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="inconsistentDbStateErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_inconsistentDbStateErrStack">Inconsistent DB State</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="oraBlockCorruptErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_oraBlockCorruptErrStack">Oracle Data Block Corruption</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="deadlockErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_deadlockErrStack">Deadlock</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="outOfMemoryErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_outOfMemoryErrStack">Out of Memory</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="clusterErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_clusterErrStack">Cluster Error</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="traceFileName" TYPE="STRING" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_traceFileName">Alert Log Error Trace File</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="errCodes" TYPE="STRING" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_errCodes">Witnessed Error Codes</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="alertLogName" TYPE="STRING" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_fileName">Alert Log Name</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="impact" TYPE="STRING" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_impact">Impact</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="incidentId" TYPE="STRING" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_incidentId">Incident ID</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<ExecutionDescriptor>
			<GetTable NAME="alert_log_errors" METRIC_NAME="adrAlertLogError" USE_CACHE="TRUE"/>
			<GetView NAME="alert_log_incident_errors" FROM_TABLE="alert_log_errors">
				<Filter COLUMN_NAME="errorCategory" OPERATOR="EQ">incident</Filter>
			</GetView>
			<GetView NAME="alert_log_incident_errors_1" FROM_TABLE="alert_log_incident_errors">
				<Column NAME="timeLine"/>
				<Column NAME="genericIncidentErrStack"/>
				<Column NAME="genericInternalErrStack"/>
				<Column NAME="sessTerminateErrStack"/>
				<Column NAME="internalSqlErrStack"/>
				<Column NAME="accessViolationErrStack"/>
				<Column NAME="redoLogCorruptErrStack"/>
				<Column NAME="fileAccessErrStack"/>
				<Column NAME="inconsistentDbStateErrStack"/>
				<Column NAME="oraBlockCorruptErrStack"/>
				<Column NAME="deadlockErrStack"/>
				<Column NAME="outOfMemoryErrStack"/>
				<Column NAME="clusterErrStack"/>
				<Column NAME="traceFileName"/>
				<Column NAME="errCodes"/>
				<Column NAME="alertLogName"/>
				<Column NAME="impact"/>
				<Column NAME="incidentId"/>
			</GetView>
		</ExecutionDescriptor>
	</Metric>

<Metric NAME="adrAlertLogOperationalError" TYPE="TABLE">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR1;11gR2"/>
    </ValidIf>
		<Display>
			<Label NLSID="adrAlertLogOperationalError">Operational Error</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="timeLine" TYPE="STRING" IS_KEY="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_timeLine">Time/Line Number</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="genericOperationalErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_genericOperationalErrStack">Generic Operational Error</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="archiveHungErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_archiveHungErrStack">Archiver Hung</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="blockCorruptErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_blockCorruptErrStack">Data Block Corruption</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="mediaFailureErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_mediaFailureErrStack">Media Failure</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="traceFileName" TYPE="STRING" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_traceFileName">Alert Log Error Trace File</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="errCodes" TYPE="STRING" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_errCodes">Witnessed Error Codes</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="alertLogName" TYPE="STRING" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_fileName">Alert Log Name</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<ExecutionDescriptor>
			<GetTable NAME="alert_log_errors" METRIC_NAME="adrAlertLogError" USE_CACHE="TRUE"/>
			<GetView NAME="alert_log_operational_errors" FROM_TABLE="alert_log_errors">
				<Filter COLUMN_NAME="errorCategory" OPERATOR="EQ">operational</Filter>
			</GetView>
			<GetView NAME="alert_log_operational_errors_1" FROM_TABLE="alert_log_operational_errors">
				<Column NAME="timeLine"/>
				<Column NAME="genericOperationalErrStack"/>
				<Column NAME="archiveHungErrStack"/>
				<Column NAME="blockCorruptErrStack"/>
				<Column NAME="mediaFailureErrStack"/>
				<Column NAME="traceFileName"/>
				<Column NAME="errCodes"/>
				<Column NAME="alertLogName"/>
			</GetView>
		</ExecutionDescriptor>
	</Metric>

<Metric NAME="adrAlertLogDataFailure" TYPE="TABLE">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR1;11gR2"/>
    </ValidIf>
		<Display>
			<Label NLSID="adrAlertLogDataFailure">Data Failure</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="timeLine" TYPE="STRING" IS_KEY="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_timeLine">Time/Line Number</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="dataFailureErrStack" TYPE="STRING" STATELESS_ALERTS="TRUE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_dataFailureErrStack">Data Failure Detected</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="numberOfFailures" TYPE="STRING" IS_KEY="FALSE" TRANSIENT="TRUE" HELP="NO_HELP">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_numberOfFailures">Number of Failures</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="alertLogName" TYPE="STRING" IS_KEY="FALSE">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLog_fileName">Alert Log Name</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<ExecutionDescriptor>
			<GetTable NAME="alert_log_errors" METRIC_NAME="adrAlertLogError" USE_CACHE="TRUE"/>
			<GetView NAME="alert_log_data_failures" FROM_TABLE="alert_log_errors">
				<Filter COLUMN_NAME="errorCategory" OPERATOR="EQ">dataFailure</Filter>
			</GetView>
			<GetView NAME="alert_log_data_failures_1" FROM_TABLE="alert_log_data_failures">
				<Column NAME="timeLine"/>
				<Column NAME="dataFailureErrStack"/>
				<Column NAME="numberOfFailures"/>
				<Column NAME="alertLogName"/>
			</GetView>
		</ExecutionDescriptor>
	</Metric>

<Metric NAME="adrAlertLogIncidentErrorStatus" TYPE="TABLE">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR1;11gR2"/>
    </ValidIf>
		<Display>
			<Label NLSID="adrAlertLogIncidentErrorStatus">Incident Status</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="genericIncidentErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_genericIncidentErrors">Generic Incident Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="genericInternalErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_genericInternalErrors">Generic Internal Error Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sessTerminateErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_sessTerminateErrors">Session Terminated Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="internalSqlErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_internalSqlErrors">Internal SQL Error Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="accessViolationErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_accessViolationErrors">Access Violation Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="redoLogCorruptErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_redoLogCorruptErrors">Redo Log Corruption Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="fileAccessErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_fileAccessErrors">File Access Error Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="inconsistentDbStateErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_inconsistentDbStateErrors">Inconsistent DB State Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="oraBlockCorruptErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_oraBlockCorruptErrors">Oracle Data Block Corruption Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="deadlockErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_deadlockErrors">Deadlock Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="outOfMemoryErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_outOfMemoryErrors">Out of Memory Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="clusterErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_clusterErrors">Cluster Error Status</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<ExecutionDescriptor>
			<GetTable NAME="alert_log_errors" METRIC_NAME="adrAlertLogIncidentError" USE_CACHE="TRUE"/>
			<GetView NAME="generic_incident_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="genericIncidentErrStack"/>
				<Filter COLUMN_NAME="genericIncidentErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="generic_incident_alert_log_rollup" FROM_TABLE="generic_incident_alert_log_errors">
				<AggregateColumn NAME="genericIncidentErrors" COLUMN_NAME="genericIncidentErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="generic_internal_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="genericInternalErrStack"/>
				<Filter COLUMN_NAME="genericInternalErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="generic_internal_alert_log_rollup" FROM_TABLE="generic_internal_alert_log_errors">
				<AggregateColumn NAME="genericInternalErrors" COLUMN_NAME="genericInternalErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="sess_terminate_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="sessTerminateErrStack"/>
				<Filter COLUMN_NAME="sessTerminateErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="sess_terminate_alert_log_rollup" FROM_TABLE="sess_terminate_alert_log_errors">
				<AggregateColumn NAME="sessTerminateErrors" COLUMN_NAME="sessTerminateErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="internal_sql_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="internalSqlErrStack"/>
				<Filter COLUMN_NAME="internalSqlErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="internal_sql_alert_log_rollup" FROM_TABLE="internal_sql_alert_log_errors">
				<AggregateColumn NAME="internalSqlErrors" COLUMN_NAME="internalSqlErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="access_violation_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="accessViolationErrStack"/>
				<Filter COLUMN_NAME="accessViolationErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="access_violation_alert_log_rollup" FROM_TABLE="access_violation_alert_log_errors">
				<AggregateColumn NAME="accessViolationErrors" COLUMN_NAME="accessViolationErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="redo_log_corrupt_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="redoLogCorruptErrStack"/>
				<Filter COLUMN_NAME="redoLogCorruptErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="redo_log_corrupt_alert_log_rollup" FROM_TABLE="redo_log_corrupt_alert_log_errors">
				<AggregateColumn NAME="redoLogCorruptErrors" COLUMN_NAME="redoLogCorruptErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="file_access_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="fileAccessErrStack"/>
				<Filter COLUMN_NAME="fileAccessErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="file_access_alert_log_rollup" FROM_TABLE="file_access_alert_log_errors">
				<AggregateColumn NAME="fileAccessErrors" COLUMN_NAME="fileAccessErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="inconsistent_db_state_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="inconsistentDbStateErrStack"/>
				<Filter COLUMN_NAME="inconsistentDbStateErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="inconsistent_db_state_alert_log_rollup" FROM_TABLE="inconsistent_db_state_alert_log_errors">
				<AggregateColumn NAME="inconsistentDbStateErrors" COLUMN_NAME="inconsistentDbStateErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="ora_block_corrupt_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="oraBlockCorruptErrStack"/>
				<Filter COLUMN_NAME="oraBlockCorruptErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="ora_block_corrupt_alert_log_rollup" FROM_TABLE="ora_block_corrupt_alert_log_errors">
				<AggregateColumn NAME="oraBlockCorruptErrors" COLUMN_NAME="oraBlockCorruptErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="deadlock_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="deadlockErrStack"/>
				<Filter COLUMN_NAME="deadlockErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="deadlock_alert_log_rollup" FROM_TABLE="deadlock_alert_log_errors">
				<AggregateColumn NAME="deadlockErrors" COLUMN_NAME="deadlockErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="out_of_memory_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="outOfMemoryErrStack"/>
				<Filter COLUMN_NAME="outOfMemoryErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="out_of_memory_alert_log_rollup" FROM_TABLE="out_of_memory_alert_log_errors">
				<AggregateColumn NAME="outOfMemoryErrors" COLUMN_NAME="outOfMemoryErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="cluster_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="clusterErrStack"/>
				<Filter COLUMN_NAME="clusterErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="cluster_alert_log_rollup" FROM_TABLE="cluster_alert_log_errors">
				<AggregateColumn NAME="clusterErrors" COLUMN_NAME="clusterErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<JoinTables NAME="adrAlertLogIncidentErrorStatus">
				<Table NAME="generic_incident_alert_log_rollup"/>
				<Table NAME="generic_internal_alert_log_rollup"/>
				<Table NAME="sess_terminate_alert_log_rollup"/>
				<Table NAME="internal_sql_alert_log_rollup"/>
				<Table NAME="access_violation_alert_log_rollup"/>
				<Table NAME="redo_log_corrupt_alert_log_rollup"/>
				<Table NAME="file_access_alert_log_rollup"/>
				<Table NAME="inconsistent_db_state_alert_log_rollup"/>
				<Table NAME="ora_block_corrupt_alert_log_rollup"/>
				<Table NAME="deadlock_alert_log_rollup"/>
				<Table NAME="out_of_memory_alert_log_rollup"/>
				<Table NAME="cluster_alert_log_rollup"/>
			</JoinTables>
		</ExecutionDescriptor>
	</Metric>

<Metric NAME="adrAlertLogOperationalErrorStatus" TYPE="TABLE">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR1;11gR2"/>
    </ValidIf>
		<Display>
			<Label NLSID="adrAlertLogOperationalErrorStatus">Operational Error Status</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="genericOperationalErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_genericOperationalErrors">Generic Operational Error Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="archiveHungErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_archiveHungErrors">Archiver Hung Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="blockCorruptErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_blockCorruptErrors">Data Block Corruption Status</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="mediaFailureErrors" TYPE="NUMBER">
				<Display FOR_SUMMARY_UI="TRUE">
					<Label NLSID="adrAlertLogStatus_mediaFailureErrors">Media Failure Status</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<ExecutionDescriptor>
			<GetTable NAME="alert_log_errors" METRIC_NAME="adrAlertLogOperationalError" USE_CACHE="TRUE"/>
			<GetView NAME="generic_operational_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="genericOperationalErrStack"/>
				<Filter COLUMN_NAME="genericOperationalErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="generic_operational_alert_log_rollup" FROM_TABLE="generic_operational_alert_log_errors">
				<AggregateColumn NAME="genericOperationalErrors" COLUMN_NAME="genericOperationalErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="archive_hung_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="archiveHungErrStack"/>
				<Filter COLUMN_NAME="archiveHungErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="archive_hung_alert_log_rollup" FROM_TABLE="archive_hung_alert_log_errors">
				<AggregateColumn NAME="archiveHungErrors" COLUMN_NAME="archiveHungErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="block_corrupt_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="blockCorruptErrStack"/>
				<Filter COLUMN_NAME="blockCorruptErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="block_corrupt_alert_log_rollup" FROM_TABLE="block_corrupt_alert_log_errors">
				<AggregateColumn NAME="blockCorruptErrors" COLUMN_NAME="blockCorruptErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<GetView NAME="media_failure_alert_log_errors" FROM_TABLE="alert_log_errors">
				<Column NAME="mediaFailureErrStack"/>
				<Filter COLUMN_NAME="mediaFailureErrStack" OPERATOR="ISNOTNULL"/>
			</GetView>
			<GroupBy NAME="media_failure_alert_log_rollup" FROM_TABLE="media_failure_alert_log_errors">
				<AggregateColumn NAME="mediaFailureErrors" COLUMN_NAME="mediaFailureErrStack" OPERATOR="COUNT"/>
			</GroupBy>
			<JoinTables NAME="adrAlertLogOperationalErrorStatus">
				<Table NAME="generic_operational_alert_log_rollup"/>
				<Table NAME="archive_hung_alert_log_rollup"/>
				<Table NAME="block_corrupt_alert_log_rollup"/>
				<Table NAME="media_failure_alert_log_rollup"/>
			</JoinTables>
		</ExecutionDescriptor>
	</Metric>

<Metric NAME="alertLogContent" TYPE="TABLE" USAGE_TYPE="HIDDEN"
      HELP="NO_HELP">
		<Display>
			<Label NLSID="alertLogContent">Alert Log Content</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="alertLogContent" TYPE="STRING" IS_KEY="FALSE">
				<Display>
					<Label NLSID="alertLog_content">Content</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="OS">
			<Property NAME="perlBin" SCOPE="SYSTEMGLOBAL">perlBin</Property>
			<Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
			<Property NAME="startsWith" SCOPE="GLOBAL">em_result=</Property>
			<Property NAME="SID" SCOPE="INSTANCE">SID</Property>
			<Property NAME="OracleHome" SCOPE="INSTANCE">OracleHome</Property>
			<Property NAME="GetDumpDestination" SCOPE="INSTANCE">background_dump_dest</Property>
			<Property NAME="ConvertFromCharset" SCOPE="INSTANCE" OPTIONAL="TRUE">ConvertFromCharset</Property>
			<Property NAME="needCharsetConvert" SCOPE="INSTANCE" OPTIONAL="TRUE">needCharsetConvert</Property>
			<Property NAME="sizeToView" SCOPE="USER">sizeToView</Property>
                        <Property NAME="startTime" SCOPE="USER" OPTIONAL="TRUE">startTime</Property>
                        <Property NAME="endTime" SCOPE="USER" OPTIONAL="TRUE">endTime</Property>
			<Property NAME="command" SCOPE="GLOBAL">
         %perlBin%/perl %scriptsDir%/alertlogViewer.pl %OracleHome% %GetDumpDestination% %SID% %sizeToView% %startTime% %endTime%
      </Property>
		</QueryDescriptor>
	</Metric>

<Metric NAME="adrAlertLogContent" TYPE="TABLE" USAGE_TYPE="HIDDEN"
      HELP="NO_HELP">
    <ValidIf>
      <CategoryProp NAME="VersionCategory" CHOICES="11gR1;11gR2"/>
    </ValidIf>
    <TableDescriptor>
      <ColumnDescriptor NAME="logContent" TYPE="STRING" IS_KEY="FALSE"/>
    </TableDescriptor>
    <QueryDescriptor FETCHLET_ID="OS">
      <Property NAME="perlBin" SCOPE="SYSTEMGLOBAL">perlBin</Property>
      <Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
      <Property NAME="startsWith" SCOPE="GLOBAL">em_result=</Property>
      <Property NAME="ConvertFromCharset" SCOPE="INSTANCE" OPTIONAL="TRUE">ConvertFromCharset</Property>
      <Property NAME="needCharsetConvert" SCOPE="INSTANCE" OPTIONAL="TRUE">needCharsetConvert</Property>
      <Property NAME="ENVEM_TARGET_GUID" SCOPE="INSTANCE">GUID</Property>
      <Property NAME="ENVEM_AGENT_STATE_DIR" SCOPE="SYSTEMGLOBAL">agentStateDir</Property>
      <Property NAME="AdrHome" SCOPE="INSTANCE">AdrHome</Property>
      <Property NAME="ARGS" SCOPE="USER" OPTIONAL="TRUE">ARGS</Property>
      <Property NAME="STDINLARGE_ARGS" SCOPE="USER" OPTIONAL="TRUE">LARGE_ARGS</Property>
      <Property NAME="command" SCOPE="GLOBAL">
        %perlBin%/perl %scriptsDir%/alertlogAdrViewer.pl %AdrHome% "%ARGS%"
      </Property>
    </QueryDescriptor>
  </Metric>

<Metric NAME="UserBlock" TYPE="TABLE">
        <ValidIf>
            <CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
            <CategoryProp NAME="MetricScope" CHOICES="DB"/>
        </ValidIf>
        <Display>
            <Label NLSID="userBlock">User Block</Label>
        </Display>
        <TableDescriptor>
            <ColumnDescriptor NAME="sid" TYPE="STRING" IS_KEY="TRUE">
                <Display>
                    <Label NLSID="userBlock_blocking_sid">Blocking Session ID</Label>
                </Display>
            </ColumnDescriptor>
            <ColumnDescriptor NAME="count" TYPE="NUMBER" IS_KEY="FALSE">
                <Display>
                    <Label NLSID="userBlock_count">Blocking Session Count</Label>
                </Display>
            </ColumnDescriptor>
        </TableDescriptor>
        <QueryDescriptor FETCHLET_ID="SQL">
            <Property NAME="STATEMENT" SCOPE="GLOBAL"><![CDATA[
      SELECT blocking_sid, SUM(num_blocked) num_blocked
        FROM (SELECT id1, id2,
                     MAX(DECODE(block, 1, sid, 0)) blocking_sid,
                     SUM(DECODE(request, 0, 0, 1)) num_blocked
                FROM v$lock
               WHERE block = 1
                  OR request > 0
               GROUP BY id1, id2)
       GROUP BY blocking_sid
]]></Property>
            <Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
            <Property NAME="Port" SCOPE="INSTANCE">Port</Property>
            <Property NAME="SID" SCOPE="INSTANCE">SID</Property>
            <Property NAME="UserName" SCOPE="INSTANCE">UserName</Property>
            <Property NAME="password" SCOPE="INSTANCE">password</Property>
            <Property NAME="Role" SCOPE="INSTANCE" OPTIONAL="TRUE">Role</Property>
        </QueryDescriptor>
    </Metric>
    
  	<Metric NAME="UserAudit" TYPE="TABLE">
		<Display>
			<Label NLSID="user_audit">User Audit</Label>
		</Display>
		<TableDescriptor>
			<ColumnDescriptor NAME="username" TYPE="STRING" IS_KEY="FALSE">
				<Display>
					<Label NLSID="userAudit_username">Audited User</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="machine" TYPE="STRING" IS_KEY="FALSE">
				<Display>
					<Label NLSID="userAudit_machine">Audited User Host</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="Session Count" TYPE="NUMBER" IS_KEY="FALSE">
				<Display>
					<Label NLSID="userAudit_session_count">Audited User Session Count</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="Username_machine" TYPE="STRING" IS_KEY="TRUE">
				<Display>
					<Label NLSID="userAudit_username_machine">Username_Machine</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="SQL">
			<Property NAME="STATEMENT" SCOPE="GLOBAL"><![CDATA[
            select uname, mname, TO_CHAR(count(uname)) , concat(concat(uname,'_'), mname) username_machine from 
            (select trim(chr(0) from trim(username)) uname, trim(chr(0) from trim(machine)) mname
            from v$session where type <> 'BACKGROUND' and username is not null )
            group by uname, mname
      ]]></Property>
			<Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
			<Property NAME="Port" SCOPE="INSTANCE">Port</Property>
			<Property NAME="SID" SCOPE="INSTANCE">SID</Property>
			<Property NAME="UserName" SCOPE="INSTANCE">UserName</Property>
			<Property NAME="password" SCOPE="INSTANCE">password</Property>
			<Property NAME="Role" SCOPE="INSTANCE" OPTIONAL="TRUE">Role</Property>
		</QueryDescriptor>
	</Metric>
    
 	<Metric NAME="mgmt_sql_metric_helper" TYPE="RAW">
		<ValidIf>
			<CategoryProp NAME="MCPkg" CHOICES="1;3"/>
			<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
		</ValidIf>
		<Display>
			<Label NLSID="mgmt_sql_metric_helper">mgmt_sql_metric_helper</Label>
		</Display>
		<TableDescriptor TABLE_NAME="mgmt_sql_metric_helper" SKIP_COLLTIME_PK="TRUE" SKIP_METRIC_COLUMN="TRUE">
			<ColumnDescriptor NAME="snap_time" COLUMN_NAME="snap_time" TYPE="STRING" IS_DATE="TRUE" IS_KEY="FALSE">
				<Display>
					<Label NLSID="mgmt_sql_metric_helper_data_available">Data Available</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="SQL">
			<Property NAME="STATEMENT" SCOPE="GLOBAL"><![CDATA[
DECLARE
        TYPE        data_cursor_type IS REF CURSOR;
        data_cursor data_cursor_type;
BEGIN
  OPEN data_cursor FOR
    SELECT to_char(NVL(MAX(s.snap_time), sysdate), 'YYYY-MM-DD HH24:MI:SS')
      FROM perfstat.stats$snapshot s, v$database d, v$instance i
      WHERE s.dbid = d.dbid and s.instance_number = i.instance_number;
  :1 := data_cursor;
END;
]]></Property>
			<Property NAME="SQLOUTPARAMPOS" SCOPE="GLOBAL">1</Property>
			<Property NAME="SQLOUTPARAMTYPE" SCOPE="GLOBAL">SQL_CURSOR</Property>
			<Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
			<Property NAME="Port" SCOPE="INSTANCE">Port</Property>
			<Property NAME="SID" SCOPE="INSTANCE">SID</Property>
			<Property NAME="UserName" SCOPE="INSTANCE">UserName</Property>
			<Property NAME="password" SCOPE="INSTANCE">password</Property>
			<Property NAME="Role" SCOPE="INSTANCE" OPTIONAL="TRUE">Role</Property>
		</QueryDescriptor>
	</Metric>
	<Metric NAME="mgmt_sql_summary" TYPE="RAW" HELP="NO_HELP">
		<ValidIf>
			<CategoryProp NAME="MCPkg" CHOICES="1;3"/>
			<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
		</ValidIf>
		<Display>
			<Label NLSID="mgmt_sql_summary">mgmt_sql_summary</Label>
		</Display>
		<TableDescriptor TABLE_NAME="mgmt_sql_summary" SKIP_COLLTIME_COLUMN="TRUE" SKIP_COLLTIME_PK="TRUE" SKIP_METRIC_COLUMN="TRUE">
			<ColumnDescriptor NAME="snap_id" COLUMN_NAME="snap_id" IS_KEY="TRUE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_summary_snap_id">Snap ID</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="collection_timestamp" COLUMN_NAME="collection_timestamp" TYPE="STRING" IS_DATE="TRUE" IS_KEY="FALSE">
				<Display>
					<Label NLSID="mgmt_sql_summary_collection_timestamp">Collection Timestamp</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sql" COLUMN_NAME="sql_text" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_summary_sql">SQL Statement</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="piece" COLUMN_NAME="piece" IS_KEY="TRUE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_piece">Piece</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sharableMem" COLUMN_NAME="sharable_mem" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_sharableMem">Sharable Memory</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="sorts" COLUMN_NAME="sorts" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_sorts">Sorts</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="modName" COLUMN_NAME="module" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_summary_mod">Module</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="loadedVers" COLUMN_NAME="loaded_versions" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_loadedVers">Loaded Versions</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="executions" COLUMN_NAME="executions" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_executions">Executions</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="loads" COLUMN_NAME="loads" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_loads">Loads</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="invalidations" COLUMN_NAME="invalidations" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_invalidations">Invalidations</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="parseCalls" COLUMN_NAME="parse_calls" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_parseCalls">Parse Calls</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="diskReads" COLUMN_NAME="disk_reads" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_diskReads">Disk Reads</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="bufferGets" COLUMN_NAME="buffer_gets" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_bufferGets">Buffer Gets</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="rowsProc" COLUMN_NAME="rows_processed" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_rowsProc">Rows Processed</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="cmdType" COLUMN_NAME="command_type" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_cmdType">Command Type</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="address" COLUMN_NAME="address" IS_KEY="TRUE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_summary_address">Address</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="hashValue" COLUMN_NAME="hash_value" IS_KEY="TRUE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_hashValue">Hash Value</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="versionCount" COLUMN_NAME="version_count" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_versionCount">Sql Version Count</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="cpuTime" COLUMN_NAME="cpu_time" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_cpuTime">CPU Time</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="elapsedTime" COLUMN_NAME="elapsed_time" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_elapsedTime">Elapsed Time</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="outlineSid" COLUMN_NAME="outline_sid" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_outlineSid">Outline SID</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="outlineCat" COLUMN_NAME="outline_category" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_summary_outlineCat">Outline Category</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="planId" COLUMN_NAME="plan_hash_value" IS_KEY="TRUE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_planId">Plan Hash Value</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="optimizerMode" COLUMN_NAME="optimizer_mode" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_summary_optimizerMode">Optimizer Mode</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="optimizerCost" COLUMN_NAME="optimizer_cost" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_summary_optimizerCost">Optimizer Cost </Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="SQL">
			<Property NAME="STATEMENT" SCOPE="GLOBAL"><![CDATA[
DECLARE
  TYPE                t_statistics_cursor_type IS REF CURSOR;
  v_stat_cursor_8i    t_statistics_cursor_type;
  v_stat_cursor_9i    t_statistics_cursor_type;
  v_db_version        VARCHAR2(10);
  db_version_min_8i   CONSTANT VARCHAR2(10) := '08.1.5.0.0';
  db_version_9i       CONSTANT VARCHAR2(10) := '09.0.0.0.0';
  db_version_92       CONSTANT VARCHAR2(10) := '09.2.0.0.0';
  v_dbid              NUMBER := 0;
  v_instance_number   NUMBER := 0;
  c_interval          NUMBER := 24;
  v_snap_id           NUMBER;
  v_snap_time         DATE;
  v_snap_time_dis     varchar2(50);
  v_snap_level        NUMBER;
  v_b_snap_id         NUMBER := -1;
  v_b_snap_time       DATE;
  v_b_snap_level      NUMBER := -1;
  v_e_snap_id         NUMBER := -1;
  v_e_snap_time       DATE   := sysdate;
  v_e_snap_time_dis   varchar2(50) := to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS');
  v_e_snap_level      NUMBER := -1;
  v_time_interval     NUMBER := -1;
  v_current_interval  NUMBER := -1;
  v_total_disk_reads  NUMBER := -1;
  v_total_buf_gets    NUMBER := -1;
  v_e_total_disk_reads  NUMBER := -1;
  v_e_total_buf_gets    NUMBER := -1;
  v_b_total_disk_reads  NUMBER := 0;
  v_b_total_buf_gets    NUMBER := 0;
  v_b_cpu_time        NUMBER := -1;
  v_e_cpu_time        NUMBER := -1;
  v_b_parse_calls     NUMBER := -1;
  v_e_parse_calls     NUMBER := -1;
  v_b_executions      NUMBER := -1;
  v_e_executions      NUMBER := -1;
  v_pect_cpu_time     NUMBER := -1;
  v_pect_parse_calls  NUMBER := -1;
  v_pect_executions   NUMBER := -1;
  v_sql_stmt_8        Varchar2(2000);
  v_sql_stmt_90       varchar2(3500);
  v_sql_stmt_92       varchar2(3500);
  v_pect_disk_reads NUMBER := -1;
  v_pect_buf_gets   NUMBER := -1;
  c_phy_read_pct NUMBER := :1;
  c_log_read_pct NUMBER := :2;
  c_cpu_time_pct NUMBER := :3;
  c_par_call_pct NUMBER := :4;
  c_exec_pct NUMBER := :5;
  v_startup_time DATE;
  v_e_startup_time DATE;

CURSOR get_snap_ids IS
    SELECT snap_id, snap_time, to_char(snap_time, 'YYYY-MM-DD HH24:MI:SS'), snap_level, startup_time
      FROM perfstat.stats$snapshot
      WHERE dbid = v_dbid and instance_number = v_instance_number order by snap_time desc;

CURSOR get_stat_total_value (p_name IN VARCHAR2,
                               p_snap_id IN NUMBER,
                               p_dbid IN NUMBER,
                               p_instance_number IN NUMBER) IS
    SELECT value
    FROM perfstat.stats$sysstat
    WHERE name = p_name AND snap_id = p_snap_id AND
          dbid = p_dbid AND instance_number = p_instance_number;

BEGIN
  -- --------------------------
  -- Get database version
  -- --------------------------
  SELECT LPAD(version, 10, '0')
    INTO v_db_version
    FROM v$instance;

-- ------------------------------
  -- Find the database ID and instance number
  -- ------------------------------
  SELECT d.dbid, i.instance_number
    INTO v_dbid, v_instance_number
    FROM v$database d, v$instance i;

-- ------------------------------
  -- Pick the latest snapshot and another snapshot where
  -- the interval between them is closest to 24 Hrs.
  -- ------------------------------

OPEN get_snap_ids;
    LOOP
      FETCH get_snap_ids INTO v_snap_id, v_snap_time, v_snap_time_dis, v_snap_level, v_startup_time;
      EXIT WHEN get_snap_ids%NOTFOUND;
      IF v_e_snap_id = -1 THEN
        v_e_snap_id := v_snap_id;
        v_e_snap_time := v_snap_time;
        v_e_snap_time_dis := v_snap_time_dis;
        v_e_snap_level := v_snap_level;
        v_e_startup_time := v_startup_time;
      ELSIF v_b_snap_id = -1 OR
            ABS((v_e_snap_time - v_snap_time) * 24 - c_interval) <
            ABS(v_current_interval - c_interval) THEN
        v_b_snap_id := v_snap_id;
        v_b_snap_time := v_snap_time;
        v_b_snap_level := v_snap_level;
        v_current_interval := (v_e_snap_time - v_b_snap_time) * 24;
        -- dbms_output.put_line('DB v_current_interval : ' || v_current_interval);
      END IF;
    END LOOP;
    CLOSE get_snap_ids;

-- Check if the instance rebounced between two snapshots or there is only one snapshot available
    IF v_b_snap_time IS NULL OR v_e_startup_time > v_b_snap_time THEN
      v_b_snap_id := -1;
      v_b_snap_time := v_e_startup_time;
    END IF;

v_time_interval := v_e_snap_time - v_b_snap_time;
    IF v_time_interval is NULL THEN
      v_time_interval := 1;
    END IF;

IF v_e_snap_id <> -1 THEN
    IF v_db_version >= db_version_9i THEN
      OPEN get_stat_total_value('CPU used when call started', v_e_snap_id, v_dbid, v_instance_number);
      FETCH get_stat_total_value INTO v_e_cpu_time;
      CLOSE get_stat_total_value;
    END IF;

OPEN get_stat_total_value('session logical reads', v_e_snap_id, v_dbid, v_instance_number);
    FETCH get_stat_total_value INTO v_e_total_buf_gets;
    CLOSE get_stat_total_value;

OPEN get_stat_total_value('physical reads', v_e_snap_id, v_dbid, v_instance_number);
    FETCH get_stat_total_value INTO v_e_total_disk_reads;
    CLOSE get_stat_total_value;

OPEN get_stat_total_value('parse count (total)', v_e_snap_id, v_dbid, v_instance_number);
    FETCH get_stat_total_value INTO v_e_parse_calls;
    CLOSE get_stat_total_value;

OPEN get_stat_total_value('execute count', v_e_snap_id, v_dbid, v_instance_number);
    FETCH get_stat_total_value INTO v_e_executions;
    CLOSE get_stat_total_value;
  END IF;

IF v_b_snap_id <> -1 THEN
    IF v_db_version >= db_version_9i THEN
      OPEN get_stat_total_value('CPU used when call started', v_b_snap_id, v_dbid, v_instance_number);
      FETCH get_stat_total_value INTO v_b_cpu_time;
      CLOSE get_stat_total_value;
    END IF;

OPEN get_stat_total_value('session logical reads', v_b_snap_id, v_dbid, v_instance_number);
    FETCH get_stat_total_value INTO v_b_total_buf_gets;
    CLOSE get_stat_total_value;

OPEN get_stat_total_value('physical reads', v_b_snap_id, v_dbid, v_instance_number);
    FETCH get_stat_total_value INTO v_b_total_disk_reads;
    CLOSE get_stat_total_value;

OPEN get_stat_total_value('parse count (total)', v_b_snap_id, v_dbid, v_instance_number);
    FETCH get_stat_total_value INTO v_b_parse_calls;
    CLOSE get_stat_total_value;

OPEN get_stat_total_value('execute count', v_b_snap_id, v_dbid, v_instance_number);
    FETCH get_stat_total_value INTO v_b_executions;
    CLOSE get_stat_total_value;
  END IF;

v_total_disk_reads := v_e_total_disk_reads - v_b_total_disk_reads;
  v_total_buf_gets := v_e_total_buf_gets - v_b_total_buf_gets;

v_pect_disk_reads := c_phy_read_pct * v_total_disk_reads;
  v_pect_buf_gets   := c_log_read_pct * v_total_buf_gets;
  v_pect_cpu_time   := c_cpu_time_pct * (v_e_cpu_time - v_b_cpu_time) * 10000;
  v_pect_parse_calls := c_par_call_pct * (v_e_parse_calls - v_b_parse_calls);
  v_pect_executions := c_exec_pct * (v_e_executions - v_b_executions);

IF v_db_version < db_version_9i THEN -- 8i case
    v_sql_stmt_8 :=
      'select e.snap_id, :end_snap_time_dis, st.sql_text, st.piece, e.sharable_mem, ' ||
      'e.sorts - nvl(b.sorts,0), e.module, e.loaded_versions, ' ||
      'e.executions - nvl(b.executions,0), e.loads - nvl(b.loads,0), ' ||
      'e.invalidations - nvl(b.invalidations,0), ' ||
      'e.parse_calls - nvl(b.parse_calls,0), ' ||
      'e.disk_reads - nvl(b.disk_reads,0), ' ||
      'e.buffer_gets - nvl(b.buffer_gets,0), ' ||
      'e.rows_processed - nvl(b.rows_processed,0), st.command_type, ' ||
      'RAWTOHEX(e.address), e.hash_value, ' ||
      'e.version_count, -1 cpu_time, ' ||
      '-1 elapsed_time, -1 outline_sid, NULL outline_category, -1 plan_hash_value, ' ||
      ''' '' optimizer, 0 cost ' ||
      'from perfstat.stats$sql_summary e, perfstat.stats$sql_summary b, perfstat.stats$sqltext st ' ||
      'where b.snap_id(+) = :b_snap_id ' ||
            ' and b.dbid(+)            = e.dbid ' ||
            ' and b.instance_number(+) = e.instance_number ' ||
            ' and st.piece =0 ' ||
            ' and b.hash_value(+)      = e.hash_value ' ||
            ' and b.address(+)         = e.address ' ||
            ' and b.text_subset(+)     = e.text_subset ' ||
            ' and e.snap_id            = :e_snap_id ' ||
            ' and e.dbid               = :dbid ' ||
            ' and e.instance_number    = :instance_number ' ||
            ' and e.hash_value         = st.hash_value ' ||
            ' and e.text_subset        = st.text_subset ' ||
            ' and e.executions - nvl(b.executions,0) > 0 ' ||
            ' and (e.buffer_gets - nvl(b.buffer_gets,0) >= :pect_buf_gets ' ||
            ' or e.disk_reads - nvl(b.disk_reads,0) >= :pect_disk_reads ' ||
            ' or e.parse_calls - nvl(b.parse_calls,0) >= :pect_parse_calls ' ||
            ' or e.executions - nvl(b.executions,0) >= :pect_executions)' ||
      ' UNION ALL ' ||
      'select :end_snap_id, :snap_time_dis, ''DUMMY_STMT_FOR_SUMMARY_STATISTICS'', -1, -1, ' ||
      '-1, '' '', -1, -1, -1, -1, -1, :total_disk_reads total_disk_reads, ' ||
      ':total_buf_gets total_buffer_gets, -1, -1, ''0'', 0, -1, -1 cpu_time, ' ||
      ':time_interval elapsed_time, -1 outline_sid, ' ||
      'NULL outline_category, -1 plan_id, '' '' optimizer_mode, 0 optimizer_cost ' ||
      'from dual';
    OPEN v_stat_cursor_8i FOR v_sql_stmt_8
      USING v_e_snap_time_dis, v_b_snap_id, v_e_snap_id, v_dbid, v_instance_number,
            v_pect_buf_gets, v_pect_disk_reads, v_pect_parse_calls, v_pect_executions,
            v_e_snap_id, v_e_snap_time_dis, v_total_disk_reads, v_total_buf_gets, v_time_interval;
    :6 := v_stat_cursor_8i;
  ELSIF v_db_version < db_version_92 THEN -- 901 case
    v_sql_stmt_90 :=
      'select e.snap_id, :e_snap_time_dis, st.sql_text, st.piece, e.sharable_mem, ' ||
      'e.sorts - nvl(b.sorts,0), e.module, e.loaded_versions, ' ||
      'e.executions - nvl(b.executions,0), e.loads - nvl(b.loads,0), ' ||
      'e.invalidations - nvl(b.invalidations,0), ' ||
      'e.parse_calls - nvl(b.parse_calls,0), ' ||
      'e.disk_reads - nvl(b.disk_reads,0), ' ||
      'e.buffer_gets - nvl(b.buffer_gets,0), ' ||
      'e.rows_processed - nvl(b.rows_processed,0), st.command_type, ' ||
      'RAWTOHEX(e.address), e.hash_value, ' ||
      'e.version_count, ' ||
      'e.cpu_time - nvl(b.cpu_time,0), ' ||
      'e.elapsed_time -  nvl(b.elapsed_time,0), ' ||
      'e.outline_sid, e.outline_category, nvl(pu.plan_hash_value, -1), ' ||
      'pu.optimizer, pu.cost ' ||
      'from perfstat.stats$sql_summary e, perfstat.stats$sql_summary b, perfstat.stats$sqltext st, ' ||
           '(select u.plan_hash_value,max(u.optimizer) optimizer, max(u.cost) cost, s.hash_value,s.text_subset ' ||
            'from perfstat.stats$sql_plan_usage u, perfstat.stats$sql_summary s ' ||
            'where s.snap_id = :e_snap_id and s.dbid = :dbid and s.instance_number = :instance_number and ' ||
                  'u.hash_value(+) = s.hash_value and u.text_subset(+) = s.text_subset ' ||
            'group by s.hash_value, s.text_subset, u.plan_hash_value) pu ' ||
      'where b.snap_id(+) = :b_snap_id ' ||
            ' and b.dbid(+)            = e.dbid ' ||
            ' and b.instance_number(+) = e.instance_number ' ||
            ' and st.piece =0 ' ||
            ' and b.hash_value(+)      = e.hash_value ' ||
            ' and b.address(+)         = e.address ' ||
            ' and b.text_subset(+)     = e.text_subset ' ||
            ' and e.snap_id            = :end_snap_id ' ||
            ' and e.dbid               = :dbid_2 ' ||
            ' and e.instance_number    = :instance_number_2 ' ||
            ' and e.hash_value         = st.hash_value ' ||
            ' and e.text_subset        = st.text_subset ' ||
            ' and e.hash_value         = pu.hash_value ' ||
            ' and e.text_subset        = pu.text_subset ' ||
            ' and e.executions - nvl(b.executions,0) > 0 ' ||
            ' and (e.disk_reads - nvl(b.disk_reads,0) >= :pect_disk_reads ' ||
            ' or e.cpu_time - nvl(b.cpu_time,0) >= :pect_cpu_time ' ||
            ' or e.parse_calls - nvl(b.parse_calls,0) >= :pect_parse_calls ' ||
            ' or e.executions - nvl(b.executions,0) >= :pect_executions)' ||
      ' UNION ALL ' ||
      'select :e_snap_id_3, :e_snap_time_dis_2, ''DUMMY_STMT_FOR_SUMMARY_STATISTICS'', -1, -1, ' ||
      '-1, '' '', -1, -1, -1, -1, -1, :total_disk_reads total_disk_reads, ' ||
      ':total_buf_gets total_buffer_gets, -1, -1, ''0'', 0, -1, -1 cpu_time, ' ||
      ':time_interval elapsed_time, -1 outline_sid, ' ||
      'NULL outline_category, -1 plan_id, '' '' optimizer_mode, 0 optimizer_cost ' ||
      'from dual';

OPEN v_stat_cursor_9i FOR v_sql_stmt_90
      USING v_e_snap_time_dis, v_e_snap_id, v_dbid, v_instance_number,
            v_b_snap_id, v_e_snap_id, v_dbid, v_instance_number,
            v_pect_disk_reads, v_pect_cpu_time, v_pect_parse_calls, v_pect_executions,
            v_e_snap_id, v_e_snap_time_dis, v_total_disk_reads, v_total_buf_gets, v_time_interval;
    :6 := v_stat_cursor_9i;
  ELSE
    v_sql_stmt_92 :=
      'select e.snap_id, :e_snap_time_dis, st.sql_text, st.piece, e.sharable_mem, ' ||
      'e.sorts - nvl(b.sorts,0), e.module, e.loaded_versions, ' ||
      'e.executions - nvl(b.executions,0), e.loads - nvl(b.loads,0), ' ||
      'e.invalidations - nvl(b.invalidations,0), ' ||
      'e.parse_calls - nvl(b.parse_calls,0), ' ||
      'e.disk_reads - nvl(b.disk_reads,0), ' ||
      'e.buffer_gets - nvl(b.buffer_gets,0), ' ||
      'e.rows_processed - nvl(b.rows_processed,0), st.command_type, ' ||
      'RAWTOHEX(e.address), e.hash_value, ' ||
      'e.version_count, ' ||
      'e.cpu_time - nvl(b.cpu_time,0), ' ||
      'e.elapsed_time -  nvl(b.elapsed_time,0), ' ||
      'e.outline_sid, e.outline_category, nvl(pu.plan_hash_value, -1), ' ||
      'pu.optimizer, pu.cost ' ||
      'from perfstat.stats$sql_summary e, perfstat.stats$sql_summary b, perfstat.stats$sqltext st, ' ||
           '(select u.plan_hash_value,max(u.optimizer) optimizer, max(u.cost) cost, s.hash_value, ' ||
            's.text_subset, max(s.dbid) dbid, max(s.instance_number) instance_number ' ||
            'from perfstat.stats$sql_plan_usage u, perfstat.stats$sql_summary s ' ||
            'where u.snap_id(+) = s.snap_id and u.dbid (+)= s.dbid and u.instance_number (+)= s.instance_number and ' ||
                  's.snap_id = :e_snap_id and s.dbid = :dbid and s.instance_number = :instance_number and ' ||
                  'u.hash_value(+) = s.hash_value and u.text_subset(+) = s.text_subset ' ||
            'group by s.hash_value, s.text_subset, u.plan_hash_value) pu ' ||
      'where b.snap_id(+) = :b_snap_id ' ||
            ' and b.dbid(+)            = e.dbid ' ||
            ' and b.instance_number(+) = e.instance_number ' ||
            ' and st.piece =0 ' ||
            ' and b.hash_value(+)      = e.hash_value ' ||
            ' and b.address(+)         = e.address ' ||
            ' and b.text_subset(+)     = e.text_subset ' ||
            ' and e.snap_id            = :e_snap_id_2 ' ||
            ' and e.dbid               = :dbid_2 ' ||
            ' and e.instance_number    = :instance_number_2 ' ||
            ' and e.hash_value         = st.hash_value ' ||
            ' and e.text_subset        = st.text_subset ' ||
            ' and e.hash_value         = pu.hash_value ' ||
            ' and e.text_subset        = pu.text_subset ' ||
            ' and e.dbid               = pu.dbid ' ||
            ' and e.instance_number    = pu.instance_number ' ||
            ' and e.executions - nvl(b.executions,0) > 0 ' ||
            ' and (e.disk_reads - nvl(b.disk_reads,0) >= :pect_disk_reads ' ||
            ' or e.cpu_time - nvl(b.cpu_time,0) >= :pect_cpu_time ' ||
            ' or e.parse_calls - nvl(b.parse_calls,0) >= :pect_parse_calls ' ||
            ' or e.executions - nvl(b.executions,0) >= :pect_executions)' ||
      ' UNION ALL ' ||
      'select :e_snap_id_3, :e_snap_time_dis_2, ''DUMMY_STMT_FOR_SUMMARY_STATISTICS'', -1, -1, ' ||
      '-1, '' '', -1, -1, -1, -1, -1, :total_disk_reads total_disk_reads, ' ||
      ':total_buf_gets total_buffer_gets, -1, -1, ''0'', 0, -1, -1 cpu_time, ' ||
      ':time_interval elapsed_time, -1 outline_sid, ' ||
      'NULL outline_category, -1 plan_id, '' '' optimizer_mode, 0 optimizer_cost ' ||
      'from dual';

OPEN v_stat_cursor_9i FOR v_sql_stmt_92
      USING v_e_snap_time_dis, v_e_snap_id, v_dbid, v_instance_number, v_b_snap_id,
            v_e_snap_id, v_dbid, v_instance_number, v_pect_disk_reads,
            v_pect_cpu_time, v_pect_parse_calls, v_pect_executions,
            v_e_snap_id, v_e_snap_time_dis, v_total_disk_reads,
            v_total_buf_gets, v_time_interval;
    :6 := v_stat_cursor_9i;
  END IF;
END;
]]></Property>
			<Property NAME="SQLINPARAM1" SCOPE="USER">PHY_READ_PCT</Property>
			<Property NAME="SQLINPARAM2" SCOPE="USER">LOG_READ_PCT</Property>
			<Property NAME="SQLINPARAM3" SCOPE="USER">CPU_TIME_PCT</Property>
			<Property NAME="SQLINPARAM4" SCOPE="USER">PAR_CALL_PCT</Property>
			<Property NAME="SQLINPARAM5" SCOPE="USER">EXEC_PCT</Property>
			<Property NAME="SQLOUTPARAMPOS" SCOPE="GLOBAL">6</Property>
			<Property NAME="SQLOUTPARAMTYPE" SCOPE="GLOBAL">SQL_CURSOR</Property>
			<Property NAME="MachineName" SCOPE="INSTANCE">MachineName</Property>
			<Property NAME="Port" SCOPE="INSTANCE">Port</Property>
			<Property NAME="SID" SCOPE="INSTANCE">SID</Property>
			<Property NAME="UserName" SCOPE="INSTANCE">UserName</Property>
			<Property NAME="password" SCOPE="INSTANCE">password</Property>
			<Property NAME="Role" SCOPE="INSTANCE" OPTIONAL="TRUE">Role</Property>
		</QueryDescriptor>
	</Metric>
	
	<Metric NAME="mgmt_sql_plan" TYPE="RAW" HELP="NO_HELP">
		<ValidIf>
			<CategoryProp NAME="MCPkg" CHOICES="1;3"/>
			<CategoryProp NAME="VersionCategory" CHOICES="pre8;8i;8iR2;9i;9iR2"/>
		</ValidIf>
		<Display>
			<Label NLSID="mgmt_sql_plan">mgmt_sql_plan</Label>
		</Display>
		<TableDescriptor TABLE_NAME="mgmt_sql_plan" SKIP_COLLTIME_COLUMN="TRUE" SKIP_COLLTIME_PK="TRUE" SKIP_METRIC_COLUMN="TRUE">
			<ColumnDescriptor NAME="snap_id" COLUMN_NAME="snap_id" IS_KEY="TRUE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_snap_id">Snap ID</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="collection_timestamp" COLUMN_NAME="collection_timestamp" TYPE="STRING" IS_DATE="TRUE" IS_KEY="FALSE">
				<Display>
					<Label NLSID="mgmt_sql_plan_collection_timestamp">Collection Timestamp</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="planId" COLUMN_NAME="plan_hash_value" IS_KEY="TRUE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_planId">Plan Hash Value</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpOperation" COLUMN_NAME="operation" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpOperation">Explain Plan Operation</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpOptions" COLUMN_NAME="options" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpOptions">Explain Plan Options</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpObjectNode" COLUMN_NAME="object_node" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpObjectNode">Explain Plan Object Node</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpObjectOwner" COLUMN_NAME="object_owner" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpObjectOwner">Explain Plan Object Owner</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpObjectName" COLUMN_NAME="object_name" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpObjectName">Explain Plan Object Name</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpOptimizer" COLUMN_NAME="optimizer" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpOptimizer">Explain Plan Optimizer Mode</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpId" COLUMN_NAME="id" IS_KEY="TRUE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpId">Explain Plan Id</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpParentId" COLUMN_NAME="parent_id" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpParentId">Explain Plan Parent Id</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpPosition" COLUMN_NAME="position" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpPosition">Explain Plan Position</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpCost" COLUMN_NAME="cost" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpCost">Explain Plan Cost</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpCardinality" COLUMN_NAME="cardinality" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpCardinality">Explain Plan Cardinality</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpBytes" COLUMN_NAME="bytes" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpBytes">Explain Plan Bytes</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpOtherTag" COLUMN_NAME="other_tag" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpOtherTag">Explain Plan Other Tag</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpPartitionStart" COLUMN_NAME="partition_start" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpPartitionStart">Explain Plan Partition Start</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpPartitionStop" COLUMN_NAME="partition_stop" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpPartitionStop">Explain Plan Partition Stop</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpPartitionId" COLUMN_NAME="partition_id" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpPartitionId">Explain Plan Partition Id</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpOther" COLUMN_NAME="other" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpOther">Explain Plan Other</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpDistribution" COLUMN_NAME="distribution" IS_KEY="FALSE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpDistribution">Explain Plan Distribution</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpCPUCost" COLUMN_NAME="cpu_cost" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpCPUCost">Explain Plan CPU Cost</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpIOCost" COLUMN_NAME="io_cost" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpIOCost">Explain Plan I-O Cost</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpTempSpace" COLUMN_NAME="temp_space" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpTempSpace">Explain Plan Temporary Space</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpObject#" COLUMN_NAME="object_number" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpObject_num">Explain Plan Object #</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="xpDepth" COLUMN_NAME="depth" IS_KEY="FALSE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_xpDepth">Explain Plan Depth</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="address" COLUMN_NAME="address" IS_KEY="TRUE" TYPE="STRING">
				<Display>
					<Label NLSID="mgmt_sql_plan_address">Address</Label>
				</Display>
			</ColumnDescriptor>
			<ColumnDescriptor NAME="hashValue" COLUMN_NAME="hash_value" IS_KEY="TRUE" TYPE="NUMBER">
				<Display>
					<Label NLSID="mgmt_sql_plan_hashValue">Hash Value</Label>
				</Display>
			</ColumnDescriptor>
		</TableDescriptor>
		<QueryDescriptor FETCHLET_ID="SQL">
			<Property NAME="STATEMENT" SCOPE="GLOBAL"><![CDATA[
DECLARE
  TYPE                t_plan_cursor_type IS REF CURSOR;
  v_plan_cursor_8i    t_plan_cursor_type;
  v_plan_cursor_9i    t_plan_cursor_type;
  v_db_version        VARCHAR2(10);
  db_version_9i       CONSTANT VARCHAR2(10) := '09.0.0.0.0';
  db_version_92       CONSTANT VARCHAR2(10) := '09.2.0.0.0';
  v_dbid              NUMBER := 0;
  v_instance_number   NUMBER := 0;
  c_interval          NUMBER := 24;
  v_snap_id           NUMBER;
  v_snap_time         DATE;
  v_snap_level        NUMBER;
  v_b_snap_id         NUMBER := -1;
  v_b_snap_time       DATE;
  v_b_snap_level      NUMBER := -1;
  v_e_snap_id         NUMBER := -1;
  v_e_snap_time       DATE;
  v_e_snap_level      NUMBER := -1;
  v_current_interval  NUMBER := -1;
  v_total_disk_reads  NUMBER := -1;
  v_total_buf_gets    NUMBER := -1;
  v_sql_stmt_9        varchar2(3500);
  v_e_total_disk_reads  NUMBER := -1;
  v_e_total_buf_gets    NUMBER := -1;
  v_b_total_disk_reads  NUMBER := 0;
  v_b_total_buf_gets    NUMBER := 0;
  v_pect_disk_reads NUMBER := -1;
  v_pect_buf_gets   NUMBER := -1;
  v_snap_time_dis   varchar2(50);
  v_e_snap_time_dis   varchar2(50);
  v_b_cpu_time        NUMBER := -1;
  v_e_cpu_time        NUMBER := -1;
  v_b_parse_calls     NUMBER := -1;
  v_e_parse_calls     NUMBER := -1;
  v_b_executions      NUMBER := -1;
  v_e_executions      NUMBER := -1;
  v_pect_cpu_time     NUMBER := -1;
  v_pect_parse_calls  NUMBER := -1;
  v_pect_executions   NUMBER := -1;
  c_phy_read_pct NUMBER := :1;
  c_log_read_pct NUMBER := :2;
  c_cpu_time_pct NUMBER := :3;
  c_par_call_pct NUMBER := :4;
  c_exec_pct NUMBER := :5;
  v_startup_time DATE;
  v_e_startup_time DATE;

BEGIN
  -- --------------------------
  -- Get database version
  -- --------------------------
  SELECT LPAD(version, 10, '0')
    INTO v_db_version
    FROM v$instance;

IF v_db_version < db_version_9i THEN
    OPEN v_plan_cursor_8i FOR
      SELECT 0 snap_id, to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS'),
             0 plan_hash_value, NULL operation, NULL options, NULL object_node,
             NULL object_owner, NULL object_name, NULL optimizer, 0 id, -1 parent_id,
             0 position, 0 cost, 0 cardinality, 0 bytes, NULL other_tag,
             NULL partition_start, NULL partition_stop, 0 partition_id,
             NULL other, NULL distribution, 0 cpu_cost, 0 io_cost,
             0 temp_space, 0 object#, 0 depth, '0', 0
      FROM dual
      WHERE 0 = 1;
    :6 := v_plan_cursor_8i;
  ELSE
    -- ------------------------------
    -- Find the database ID and instance number
    -- ------------------------------
    SELECT d.dbid, i.instance_number
      INTO v_dbid, v_instance_number
      FROM v$database d, v$instance i;

-- ------------------------------
    -- Pick the latest snapshot and another snapshot where
    -- the interval between them is closest to 24 Hrs.
    -- ------------------------------