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
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>

Related Topics
Built-in Functions
Built-in Packages
DBMS_ADVISOR
DBMS_SQLTUNE
DBMS_WORKLOAD_REPLAY
DBMS_XPLAN
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved