Oracle 12cR2 DBMS

Oracle DBMS_ADDM Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"

~ Sen. Tammy Duckworth

Purpose Create and execute an tasks to analyze all instances of a database.

AUTHID CURRENT_USER

Dependencies

DBMS_ADVISOR	DBMS_SYS_ERROR	PRVT_ADVISOR
DBMS_MANAGEMENT_PACKS	DBMS_UTILITY	PRVT_HDM
DBMS_REPORT	DBMS_WORKLOAD_REPLAY	PRVT_SMGUTIL
DBMS_STANDARD	DUAL	USER_ADVISOR_TASKS
DBMS_SWRF_INTERNAL

Documented Partially

First Available 11.1.0.6

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsaddm.sql

Subprograms

ANALYZE_DB	DELETE	GET_REPORT
ANALYZE_INST	DELETE_FINDING_DIRECTIVE	INSERT_FINDING_DIRECTIVE
ANALYZE_PARTIAL	DELETE_PARAMETER_DIRECTIVE	INSERT_PARAMETER_DIRECTIVE
COMPARE_CAPTURE_REPLAY_REPORT	DELETE_SEGMENT_DIRECTIVE	INSERT_SEGMENT_DIRECTIVE
COMPARE_DATABASES	DELETE_SQL_DIRECTIVE	INSERT_SQL_DIRECTIVE
COMPARE_INSTANCES	GET_ASH_QUERY	REAL_TIME_ADDM_REPORT
COMPARE_REPLAY_REPLAY_REPORT

ANALYZE_DB

Create and execute an ADDM task to analyze all instances of a database for a range of snapshots dbms_addm.analyze_db( task_name IN OUT VARCHAR2, begin_snapshot IN NUMBER, end_snapshot IN NUMBER, db_id IN NUMBER := NULL);

SELECT dbid FROM  v$database;

      

      set pagesize 25

      set linesize 121

      col instart_fmt format a20

      break on instart_fmt

      col inst_name format a12 heading 'Instance';

      col db_name format a12 heading 'DB Name';

      col snap_id format 99999990 heading 'Snap Id';

      col snapdat format a18 heading 'Snap Started' just c;

      col lvl format 99 heading 'Snap|Level';

      set heading on;

      break on inst_name on db_name on host on instart_fmt skip 1;

      ttitle off;

      

      SELECT TO_CHAR(s.startup_time,' DD MON "at" HH24:MI:SS') INSTART_FMT,

      di.instance_name INST_NAME, di.db_name DB_NAME, s.snap_id SNAP_ID,

      TO_CHAR(s.end_interval_time,'DD MON YYYY HH24:MI') SNAPDAT,

      s.snap_level LVL

      FROM dba_hist_snapshot s, dba_hist_database_instance di

      WHERE di.dbid = s.dbid

      AND di.instance_number = s.instance_number

      AND di.startup_time = s.startup_time

      ORDER BY snap_id;

      

      set serveroutput on

      

      DECLARE

       tname VARCHAR2(30) := 'UW_TASK1';

      BEGIN

        dbms_addm.analyze_db(tname, 2437, 2504, 1701481905);

        dbms_output.put_line(tname);

      END;

      /

      

      col execution_name format a15

      col finding_name format a30

      col parent format 99

      col impact format 99999999999

      col message format a60

      col more_info format a60

      

      SELECT execution_name, finding_name, parent, impact

      FROM dba_addm_findings

      WHERE task_name = 'UW_TASK1';

      

      SELECT execution_name, finding_name, message

      FROM dba_addm_findings

      WHERE task_name = 'UW_TASK1';

      

      SELECT execution_name, finding_name, more_info

      FROM dba_addm_findings

      WHERE task_name = 'UW_TASK1';

ANALYZE_INST

Create and execute an ADDM task to analyze a specific instance of a database for a range of snapshots dbms_addm.analyze_inst( task_name IN OUT VARCHAR2, begin_snapshot IN NUMBER, end_snapshot IN NUMBER, instance_number IN NUMBER := NULL, db_id IN NUMBER := NULL);

SELECT dbid FROM v$database;

      

      SELECT inst_id

      FROM gv$instance;

      

      set pagesize 25

      set linesize 121

      col instart_fmt format a20

      break on instart_fmt

      col inst_name format a12 heading 'Instance';

      col db_name format a12 heading 'DB Name';

      col snap_id format 99999990 heading 'Snap Id';

      col snapdat format a18 heading 'Snap Started' just c;

      col lvl format 99 heading 'Snap|Level';

      set heading on;

      break on inst_name on db_name on host on instart_fmt skip 1;

      ttitle off;

      

      SELECT TO_CHAR(s.startup_time,' DD MON "at" HH24:MI:SS') INSTART_FMT,

      di.instance_name INST_NAME, di.db_name DB_NAME, s.snap_id SNAP_ID,

      TO_CHAR(s.end_interval_time,'DD MON YYYY HH24:MI') SNAPDAT,

      s.snap_level LVL

      FROM dba_hist_snapshot s, dba_hist_database_instance di

      WHERE di.dbid = s.dbid

      AND di.instance_number = s.instance_number

      AND di.startup_time = s.startup_time

      ORDER BY snap_id;

      

      set serveroutput on

      

      DECLARE

       tname VARCHAR2(30) := 'UW_TASK2';

      BEGIN

        dbms_addm.analyze_inst(tname, 2387, 2406, 1, 1701481905);

        dbms_output.put_line(tname);

      END;

      /

      

      desc dba_addm_findings

      

      SELECT task_name

      FROM dba_addm_findings;

      

      SELECT task_name

      FROM dba_addm_findings

      WHERE task_name LIKE 'UW%';

      

      col finding_name format a30

      col impact format 99999.99

      

      SELECT execution_name, finding_name, parent, impact, message, more_info

      FROM dba_addm_findings

      WHERE task_name = 'UW_TASK2';

      

      desc dba_addm_tasks

      

      SELECT DISTINCT task_name, advisor_name

      FROM dba_addm_tasks;

      

      col advisor_name format a15

      col how_created format a15

      

      SELECT advisor_name, status, how_created, system_task, requested_analysis, actual_analysis

      FROM dba_addm_tasks

      WHERE task_name = 'UW_TASK2';

ANALYZE_PARTIAL

Create and execute an ADDM task to analyze a partial list of instances for a range of snapshots dbms_addm.analyze_partial( task_name IN OUT VARCHAR2, instance_numbers IN VARCHAR2, begin_snapshot IN NUMBER, end_snapshot IN NUMBER, db_id IN NUMBER := NULL);

SELECT dbid FROM  v$database;

      

      SELECT inst_id

      FROM gv$instance;

      

      set pagesize 25

      set linesize 121

      col instart_fmt format a20

      break on instart_fmt

      col inst_name format a12 heading 'Instance';

      col db_name format a12 heading 'DB Name';

      col snap_id format 99999990 heading 'Snap Id';

      col snapdat format a18 heading 'Snap Started' just c;

      col lvl format 99 heading 'Snap|Level';

      set heading on;

      break on inst_name on db_name on host on instart_fmt skip 1;

      ttitle off;

      

      SELECT TO_CHAR(s.startup_time,' DD MON "at" HH24:MI:SS') INSTART_FMT,

      di.instance_name INST_NAME, di.db_name DB_NAME, s.snap_id SNAP_ID,

      TO_CHAR(s.end_interval_time,'DD MON YYYY HH24:MI') SNAPDAT,

      s.snap_level LVL

      FROM dba_hist_snapshot s, dba_hist_database_instance di

      WHERE di.dbid = s.dbid

      AND di.instance_number = s.instance_number

      AND di.startup_time = s.startup_time

      ORDER BY snap_id;

      

      set serveroutput on

      

      DECLARE

       tname VARCHAR2(30) := 'UW_TASK3';

       insts VARCHAR2(50) := '1,2,3';

      BEGIN

        dbms_addm.analyze_partial(tname, insts, 2387, 2406);

        dbms_output.put_line(tname);

      END;

      /

COMPARE_CAPTURE_REPLAY_REPORT

Create a report comparing the performance of a capture to a replay dbms_addm.compare_capture_replay_report( replay_id IN NUMBER, report_type IN VARCHAR2 := 'HTML') RETURN CLOB;

TBD

COMPARE_DATABASES

Create a report comparing the performance of a database over two different time periods or the performance of two different databases over two different time periods dbms_addm.compare_databases( base_dbid IN NUMBER := NULL, base_begin_snap_id IN NUMBER, base_end_snap_id IN NUMBER, comp_dbid IN NUMBER := NULL, comp_begin_snap_id IN NUMBER, comp_end_snap_id IN NUMBER, report_type IN VARCHAR2 := 'HTML') RETURN CLOB;

SELECT dbid FROM v$database;

      

      set feedback off

      set heading on

      set linesize 1500

      set termout on

      set trim on

      set trimspool on

      set veri off

      col instart_fmt noprint;

      col inst_name format a12  heading 'Instance';

      col db_name format a12 heading 'DB Name';

      col snap_id format 99999990 heading 'Snap Id';

      col snapdat format a18 heading 'Snap Started' just c;

      col lvl format 99 heading 'Snap|Level';

      break on inst_name on db_name on host on instart_fmt skip 1;

      ttitle off;

      

      SELECT TO_CHAR(s.startup_time,' DD MON "at" HH24:MI:SS') INSTART_FMT,

      di.instance_name INST_NAME, di.db_name DB_NAME, s.snap_id SNAP_ID,

      TO_CHAR(s.end_interval_time,'DD MON YYYY HH24:MI') SNAPDAT,

      s.snap_level LVL

      FROM dba_hist_snapshot s, dba_hist_database_instance di

      WHERE di.dbid = s.dbid

      AND di.instance_number  = s.instance_number

      AND di.startup_time     = s.startup_time

      ORDER BY snap_id;

      

      set pagesize  999

      set linesize 161

      

      spool /home/oracle/compare_db.html br>
      

      SELECT dbms_addm.compare_databases(1984521206, 4502, 4532, 768045447, 4472, 4502, 'HTML')

      FROM dual;

      

      spool off

-- open the file in a browser and you will discover it is unreadable except in OEM

COMPARE_INSTANCES

Create a report comparing the performance of a single instance over two different time periods or the performance of two different instances over two different time periods dbms_addm.compare_instances( base_dbid IN NUMBER := NULL, base_instance_id IN NUMBER, base_begin_snap_id IN NUMBER, base_end_snap_id IN NUMBER, comp_dbid IN NUMBER := NULL, comp_instance_id IN NUMBER, comp_begin_snap_id IN NUMBER, comp_end_snap_id IN NUMBER, report_type IN VARCHAR2 := 'HTML') RETURN CLOB;

SELECT dbid FROM v$database;

      

      set feedback off

      set heading on

      set linesize 1500

      set termout on

      set trim on

      set trimspool on

      set veri off

      col instart_fmt noprint;

      col inst_name format a12  heading 'Instance';

      col db_name format a12 heading 'DB Name';

      col snap_id format 99999990 heading 'Snap Id';

      col snapdat format a18 heading 'Snap Started' just c;

      col lvl format 99 heading 'Snap|Level';

      break on inst_name on db_name on host on instart_fmt skip 1;

      ttitle off;

      

      SELECT TO_CHAR(s.startup_time,' DD MON "at" HH24:MI:SS') INSTART_FMT,

      di.instance_name INST_NAME, di.db_name DB_NAME,
      s.snap_id SNAP_ID,

      TO_CHAR(s.end_interval_time,'DD MON YYYY HH24:MI') SNAPDAT,

      s.snap_level LVL

      FROM dba_hist_snapshot s, dba_hist_database_instance di

      WHERE di.dbid = s.dbid

      AND di.instance_number  = s.instance_number

      AND di.startup_time     = s.startup_time

      ORDER BY snap_id;

      

      set 999

      set linesize 161

      

      spool /home/oracle/compare_db.html

      

      SELECT dbms_addm.compare_instances(1984521206, 1, 4502, 4532, 1984521206, 2, 4472, 4502, 'HTML')

      FROM dual;

      

      spool off

-- open the file in a browser and you will discover it is unreadable except in OEM

COMPARE_REPLAY_REPLAY_REPORT

Create a report comparing the the performance of two replays dbms_addm.compare_replay_replay_report( replay_id1 IN NUMBER, replay_id2 IN NUMBER, report_type IN VARCHAR2 := 'HTML') RETURN CLOB

TBD

DELETE

Delete an ADDM task dbms_addm.delete(task_name IN VARCHAR2);

exec dbms_addm.delete('UW_TASK1');

DELETE_FINDING_DIRECTIVE

Delete an ADDM directive dbms_addm.delete_finding_directive(task_name IN VARCHAR2, dir_name IN VARCHAR2);

SELECT task_name, directive_name, description

      FROM dba_addm_task_directives;

DELETE_PARAMETER_DIRECTIVE

Delete an ADDM directive dbms_addm.delete_parameter_directive(task_name IN VARCHAR2, dir_name IN VARCHAR2);

TBD

DELETE_SEGMENT_DIRECTIVE

Delete an ADDM directive dbms_addm.delete_segment_directive(task_name IN VARCHAR2, dir_name IN VARCHAR2);

TBD

DELETE_SQL_DIRECTIVE

Delete an ADDM directive dbms_addm.delete_sql_directive(task_name IN VARCHAR2, dir_name IN VARCHAR2);

TBD

GET_ASH_QUERY

Retrieves the SQL text of an ASH query for a finding dbms_addm.get_ash_query(task_name IN VARCHAR2, finding_id IN NUMBER) RETURN VARCHAR2;

-- first run the ANALYZE_DB demo above over a range that has "real" work

SELECT finding_id, finding_name, message

      FROM dba_advisor_findings

      WHERE task_name = 'UW_TASK1';

      

      SELECT dbms_addm.get_ash_query('UW_TASK1', 1) FROM dual;

      

      col task_name format a25

      col message format a50

     

      SELECT task_name, finding_id, finding_name, message

      FROM dba_advisor_findings;

     

      SELECT dbms_addm.get_ash_query('ADDM:2495529197_1_25', 1) FROM dual;

      SELECT dbms_addm.get_ash_query('ADDM:2495529197_1_3',  1) FROM dual;

GET_REPORT

Returns the ADDM report dbms_addm.get_report(task_name IN VARCHAR2) RETURN CLOB;

SELECT task_name

      FROM dba_advisor_tasks;

      

      set long 1000000

      set serveroutput on

      

      DECLARE

       rptlob CLOB;

      BEGIN

        rptlob := dbms_addm.get_report('UW_TASK1');

        dbms_output.put_line(rptlob);

      END;

      /

      

      SELECT * FROM TABLE(dbms_xplan.display_cursor('1tkztbrcvfcdw'));

INSERT_FINDING_DIRECTIVE

Insert a directive filtering a finding, either for a task or system wide dbms_addm.insert_finding_directive( task_name IN VARCHAR2, dir_name IN VARCHAR2, finding_name IN VARCHAR2, min_active_sessions IN NUMBER := 0, min_perc_impact IN NUMBER := 0);

TBD

INSERT_PARAMETER_DIRECTIVE

Insert a directive filtering a recommendations to change a system parameter dbms_addm.insert_parameter_directive( task_name IN VARCHAR2, dir_name IN VARCHAR2, parameter_name IN VARCHAR2);

TBD

INSERT_SEGMENT_DIRECTIVE

Insert a directive filtering recommendations to run the segment advisor

Overload 1 dbms_addm.insert_segment_directive( task_name IN VARCHAR2, dir_name IN VARCHAR2, owner_name IN VARCHAR2, object_name IN VARCHAR2 := NULL, sub_object_name IN VARCHAR2 := NULL);

TBD

Overload 2 dbms_addm.insert_segment_directive( task_name IN VARCHAR2, dir_name IN VARCHAR2, object_number IN NUMBER);

TBD

INSERT_SQL_DIRECTIVE

Insert a directive filtering SQL recommendations, either for a task or system wide dbms_addm.inset_sql_directive( task_name IN VARCHAR2, dir_name IN VARCHAR2, sql_id IN VARCHAR2, min_active_sessions IN NUMBER := 0, min_response_time IN NUMBER := 0);

TBD

REAL_TIME_ADDM_REPORT

Returns a real-time ADDM report for the previous 5 minutes dbms_addm.real_time_addm_report RETURN CLOB;

spool c:\temp\realtime_addm.html

      

      SELECT dbms_addm.real_time_addm_report

      FROM dual;

      

      spool off

      

      -- open the report in a browser

      REAL_TIME_ADDM_REPORT

      --------------------------------------------------------------------------------

      <report db_version="12.1.0.0.2" cpu_cores="1" hyperthread="Y" con_id="1" con_nam

      e="CDB$ROOT" timezone_offset="-28800"><report_id><![CDATA[/orarep/rtaddm/main]]>

      </report_id><sql_data><report_metadata instance_number="0" date_format="HH24:MI:

      SS MM/DD/YYYY" start_time="11:01:00 11/12/2012" report_time="11:06:40 11/12/2012

      "/><system_config><database dbid="2607574650" name="ORABETA" log_mode="NOARCHIVE

      LOG" open_mode="READ WRITE" role="PRIMARY" force_log="NO" platform="Microsoft Wi

      ndows x86 64-bit" flashback_on="NO" unique_name="orabeta" version="12.1.0.0.2"/>

      <instances><instance number="1" name="orabeta" host="PERRITO4" version="12.1.0.0

      .2" startup_time="00:26:07 11/02/2012" status="OPEN" logins="ALLOWED" shutdown_p

      ending="NO" role="PRIMARY_INSTANCE" active="NORMAL"/></instances></system_config

      ><hangs><sessions/><blockers/><hang_info/></hangs><metrics><metric_names>

      <map na

      me="User Transaction Per Sec" unit="Transactions Per Second" id="1"/><map name="

      Logons Per Sec" unit="Logons Per Second" id="2"/><map name="User Commits Per Sec

      " unit="Commits Per Second" id="3"/><map name="User Rollbacks Per Sec" unit="Rol

      lbacks Per Second" id="4"/><map name="Network Traffic Volume Per Sec" unit="Byte

      s Per Second" id="5"/><map name="CPU Usage Per Sec" unit="CentiSeconds Per Secon

      d" id="6"/><map name="Physical Read Total Bytes Per Sec" unit="Bytes Per Second"

      id="7"/><map name="GC CR Block Received Per Second" unit="Blocks Per Second" id

      ="8"/><map name="GC Current Block Received Per Second" unit="Blocks Per Second"

      id="9"/><map name="Global Cache Average CR Get Time" unit="CentiSeconds Per Get"

      id="10"/><map name="Global Cache Average Current Get Time" unit="CentiSeconds P

      er Get" id="11"/><map name="Global Cache Blocks Lost" unit="Blocks" id="12"/><ma

      p name="Current Logons Count" unit="Logons" id="13"/><map name="Current Open Cur

      sors Count" unit="Cursors" id="14"/><map name="Process Limit %" unit="% Processe

      s/Limit" id="15"/><map name="Session Limit %" unit="% Sessions/Limit" id="16"/><

      map name="Executions Per Sec" unit="Executes Per Second" id="17"/><map name="Dat

      abase Time Per Sec" unit="CentiSeconds Per Second" id="18"/><map name="Physical

      Write Total Bytes Per Sec" unit="Bytes Per Second" id="19"/><map name="Host CPU

      Utilization (%)" unit="% Busy/(Idle+Busy)" id="20"/><map name="Current OS Load"

      unit="Number Of Processes" id="21"/><map name="Average Synchronous Single-Block

      Read Latency" unit="Milliseconds" id="22"/><map name="Background CPU Usage Per S

      ec" unit="CentiSeconds Per Second" id="23"/><map name="Total PGA Allocated" unit

      ="bytes" id="24"/><map name="Run Queue Per Sec" unit="Processes" id="25"/><map n

      ame="VM in bytes Per Sec" unit="bytes per sec" id="26"/><map name="VM out bytes

      Per Sec" unit="bytes per sec" id="27"/></metric_names><data><m i="1" v=".057" ma

      =".217" mi="0" id="1"/><m i="1" v=".05" ma=".067" mi=".017" id="2"/><m i="1" v="

      .057" ma=".217" mi="0" id="3"/><m i="1" v="0" ma="0" mi="0" id="4"/><m i="1" v="

      120.648" ma="603.241" mi="0" id="5"/><m i="1" v=".25" ma="1.251" mi="0" id="6"/>

      <m i="1" v="151363.556" ma="429730.792" mi="73925.134" id="7"/><m i="1" v="0" ma

      ="0" mi="0" id="8"/><m i="1" v="0" ma="0" mi="0" id="9"/><m i="1" v="0" ma="0" m

      i="0" id="10"/><m i="1" v="0" ma="0" mi="0" id="11"/><m i="1" v="0" ma="0" mi="0

      " id="12"/><m i="1" v="31" ma="31" mi="31" id="13"/><m i="1" v="38.2" ma="39" mi

      ="38" id="14"/><m i="1" v="16.667" ma="16.667" mi="16.667" id="15"/><m i="1" v="

      9.11" ma="9.11" mi="9.11" id="16"/><m i="1" v="5.86" ma="13.424" mi="1.019" id="

      17"/><m i="1" v=".234" ma="1.167" mi="0" id="18"/><m i="1" v="28119.005" ma="807

      71.381" mi="10951.872" id="19"/><m i="1" v="28.358" ma="34.552" mi="26.368" id="

      20"/><m i="1" v="0" ma="0" mi="0" id="21"/><m i="1" v=".686" ma=".72" mi=".622"

      id="22"/><m i="1" v="4.73" ma="22.975" mi=".13" id="23"/><m i="1" v="138761011.2

      " ma="144580608" mi="137306112" id="24"/><m i="1" v="0" ma="0" mi="0" id="25"/><

      m i="1" v="0" ma="0" mi="0" id="26"/><m i="1" v="0" ma="0" mi="0" id="27"/></dat

      a></metrics><ash_data sampling_ratio="1" avg_active_sessions=".0023" secs="340">

      <op><m i="2" n="INSERT"/><m i="3" n="SELECT"/></op><sid><m v="1_121_1" i="1"/><m

      v="1_249_4039" i="2"/><m v="1_356_1" i="3"/><m v="1_360_1" i="4"/><m v="__" i="

      5"/></sid><evt><m c="CPU" e="CPU" i="1"/><m c="System I/O" e="control file seque

      ntial read" i="2"/><m c="Other" e="oracle thread bootstrap" i="3"/></evt><servic

      e><m h="165959219" n="SYS$BACKGROUND" i="1"/></service><program><m v="ORACLE.EXE

      (CKPT)" i="1"/><m v="ORACLE.EXE (M000)" i="2"/><m v="ORACLE.EXE (PSP0)" i="3"/>

      <m v="ORACLE.EXE (MMON)" i="4"/></program><module><m v="MMON_SLAVE" i="1"/><m v=

      "__" i="2"/></module><action><m v="Auto-Flush Slave Action" i="1"/><m v="__" i="

      2"/></action><sql><m f="0" o="0" s="null" i="1"/><m f="0" o="3" s="fkc81h2686aqc

      " i="2"/><m f="10912680319128283320" o="2" s="0v30sznmzmnbv" i="3"/></sql><data>

      <a>247,1,0,5,5,2,0,1,1,2,2,2,0</a><a>247,1,0,5,5,1,0,1,1,2,2,2,0</a><a>0,2,0,5,5

      ,3,5,2,1,1,1,1,0</a><a>1,2,0,5,5,3,5,2,1,1,1,1,0</a><a>2,2,0,5,5,3,5,2,1,1,1,1,0

      </a><a>3,2,0,5,5,3,5,2,1,1,1,1,0</a><a>4,2,0,5,5,3,5,2,1,1,1,1,0</a><a>5,2,0,5,5

      ,3,5,2,1,1,1,1,0</a><a>6,2,0,5,5,3,5,2,1,1,1,1,0</a><a>7,2,0,5,5,3,5,2,1,1,1,1,0

      </a><a>8,2,0,5,5,3,5,2,1,1,1,1,0</a><a>9,2,0,5,5,3,5,2,1,1,1,1,0</a><a>11,2,0,5,

      5,2,1,2,1,1,1,1,0</a><a>11,2,0,5,5,1,1,2,1,1,1,1,0</a><a>4,3,0,5,5,2,0,3,1,2,2,1

      ,0</a><a>22,3,0,5,5,2,0,3,1,2,2,1,0</a><a>38,3,0,5,5,2,0,3,1,2,2,1,0</a><a>54,3,

      0,5,5,2,0,3,1,2,2,1,0</a><a>71,3,0,5,5,2,0,3,1,2,2,1,0</a><a>90,3,0,5,5,2,0,3,1,

      2,2,1,0</a><a>107,3,0,5,5,2,0,3,1,2,2,1,0</a><a>124,3,0,5,5,2,0,3,1,2,2,1,0</a><

      a>142,3,0,5,5,2,0,3,1,2,2,1,0</a><a>160,3,0,5,5,2,0,3,1,2,2,1,0</a><a>178,3,0,5,

      5,2,0,3,1,2,2,1,0</a><a>195,3,0,5,5,2,0,3,1,2,2,1,0</a><a>212,3,0,5,5,2,0,3,1,2,

      2,1,0</a><a>231,3,0,5,5,2,0,3,1,2,2,1,0</a><a>248,3,0,5,5,2,0,3,1,2,2,1,0</a><a>

      266,3,0,5,5,2,0,3,1,2,2,1,0</a><a>283,3,0,5,5,2,0,3,1,2,2,1,0</a><a>301,3,0,5,5,

      2,0,3,1,2,2,1,0</a><a>318,3,0,5,5,2,0,3,1,2,2,1,0</a><a>335,3,0,5,5,2,0,3,1,2,2,

      1,0</a><a>4,3,0,5,5,1,0,3,1,2,2,1,0</a><a>22,3,0,5,5,1,0,3,1,2,2,1,0</a><a>38,3,

      0,5,5,1,0,3,1,2,2,1,0</a><a>54,3,0,5,5,1,0,3,1,2,2,1,0</a><a>71,3,0,5,5,1,0,3,1,

      2,2,1,0</a><a>90,3,0,5,5,1,0,3,1,2,2,1,0</a><a>107,3,0,5,5,1,0,3,1,2,2,1,0</a><a

      >124,3,0,5,5,1,0,3,1,2,2,1,0</a><a>142,3,0,5,5,1,0,3,1,2,2,1,0</a><a>160,3,0,5,5

      ,1,0,3,1,2,2,1,0</a><a>178,3,0,5,5,1,0,3,1,2,2,1,0</a><a>195,3,0,5,5,1,0,3,1,2,2

      ,1,0</a><a>212,3,0,5,5,1,0,3,1,2,2,1,0</a><a>231,3,0,5,5,1,0,3,1,2,2,1,0</a><a>2

      48,3,0,5,5,1,0,3,1,2,2,1,0</a><a>266,3,0,5,5,1,0,3,1,2,2,1,0</a><a>283,3,0,5,5,1

      ,0,3,1,2,2,1,0</a><a>301,3,0,5,5,1,0,3,1,2,2,1,0</a><a>318,3,0,5,5,1,0,3,1,2,2,1

      ,0</a><a>335,3,0,5,5,1,0,3,1,2,2,1,0</a><a>14,4,0,5,5,2,27,4,1,2,2,3,0</a><a>14,

      4,0,5,5,1,27,4,1,2,2,3,0</a></data></ash_data><osstat_pit><stat i="1" name="NUM_

      CPUS" v="4"/><stat i="1" name="NUM_CPU_CORES" v="1"/><stat i="1" name="PHYSICAL_

      MEMORY_BYTES" v="8467496960"/></osstat_pit><memory><mem i="1" n="pga" v="1463500

      80"/><mem i="1" n="shared pool" v="809064624"/><mem i="1" n="fixed_sga" v="23850

      40"/><mem i="1" n="large pool" v="16777216"/><mem i="1" n="shared_io_pool" v="13

      4217728"/><mem i="1" n="SP free" v="63350608"/><mem i="1" n="buffer_cache" v="14

      76395008"/><mem i="1" n="log_buffer" v="19771392"/><mem i="1" n="java pool" v="1

      6777216"/></memory><resize_ops><a i="1" t="GROW" m="DEFERRED" c="7" p="Y"/></res

      ize_ops><parameters><p n="event" i="1"/><p n="active_instance_count" i="1"/><p n

      ="max_dispatchers" i="1"/><p n="timed_statistics" i="0">TRUE</p><p n="timed_os_s

      tatistics" i="0">0</p><p n="db_8k_cache_size" i="0">0</p><p n="db_keep_cache_siz

      e" i="0">0</p><p n="dispatchers" i="0">(PROTOCOL=TCP) (SERVICE=orabetaXDB)</p><p

      n="processes" i="0">300</p><p n="sessions" i="0">472</p><p n="cpu_count" i="0">

      4</p><p n="db_recycle_cache_size" i="0">0</p><p n="cluster_database_instances" i

      ="0">1</p><p n="statistics_level" i="0">TYPICAL</p><p n="shared_pool_size" i="0"

      >0</p><p n="java_pool_size" i="0">0</p><p n="sga_target" i="0">2550136832</p><p

      n="memory_max_target" i="0">0</p><p n="db_2k_cache_size" i="0">0</p><p n="db_blo

      ck_buffers" i="0">0</p><p n="db_4k_cache_size" i="0">0</p><p n="db_writer_proces

      ses" i="0">1</p><p n="log_buffer" i="0">19070976</p><p n="db_block_checking" i="

      0">FALSE</p><p n="open_cursors" i="0">300</p><p n="pga_aggregate_target" i="0">8

      46200832</p><p n="_enable_pluggable_database" i="0">TRUE</p><p n="streams_pool_s

      ize" i="0">0</p><p n="db_block_size" i="0">8192</p><p n="db_16k_cache_size" i="0

      ">0</p><p n="compatible" i="0">12.0.0.0.0</p><p n="db_file_multiblock_read_count

      " i="0">128</p><p n="cluster_database" i="0">FALSE</p><p n="sga_max_size" i="0">

      2550136832</p><p n="large_pool_size" i="0">0</p><p n="db_block_checksum" i="0">T

      YPICAL</p><p n="db_32k_cache_size" i="0">0</p><p n="undo_management" i="0">AUTO<

      /p><p n="memory_target" i="0">0</p><p n="db_cache_size" i="0">0</p><p n="cursor_

      sharing" i="0">EXACT</p><p n="gcs_server_processes" i="0">0</p></parameters></sq

      l_data><report_repository_summary><fdg id="2" impact="0"/></report_repository_su

      mmary></report>