Oracle DBMS_ADDM
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Purpose Create and execute an tasks to analyze all instances of a database.
AUTHID CURRENT_USER
Dependencies
DBMS_ADVISOR DBMS_UTILITY PRVT_ADVISOR
DBMS_MANAGEMENT_PACKS DBMS_WORKLOAD_REPLAY PRVT_HDM
DBMS_REPORT DUAL USER_ADVISOR_TASKS
DBMS_SYS_ERROR    
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 (new 12.1)
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 (new 12.1)
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.compar_databases(
base_dbid          IN NUMBER,
base_begin_snap_id IN NUMBER,
base_end_snap_id   IN NUMBER,
comp_dbid          IN NUMBER,
comp_begin_snap_id IN NUMBER,
comp_end_snap_id   IN NUMBER,
report_type        IN VARCHAR2 := 'HTML')
RETURN CLOB;
TBD
 
COMPARE_INSTANCES (new 12.1)
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,
base_instance_id   IN NUMBER,
base_begin_snap_id IN NUMBER,
base_end_snap_id   IN NUMBER,
comp_dbid          IN NUMBER,
comp_instance_id   IN NUMBER,
comp_begin_snap_id IN NUMBER,
comp_end_snap_id   IN NUMBER,
report_type        IN VARCHAR2 := 'HTML')
RETURN CLOB;
TBD
 
COMPARE_REPLAY_REPLAY_REPORT (new 12.1)
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 (new 12.1)
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
DBMS_ADVISOR
DBMS_SQLTUNE
DBMS_WORKLOAD_REPLAY
DBMS_XPLAN
Packages

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-2014 Daniel A. Morgan All Rights Reserved