spool c:\temp\realtime_addm.html
SELECT dbms_addm.real_time_addm_report
FROM dual;
REAL_TIME_ADDM_REPORT
--------------------------------------------------------------------------------
<report db_version="18.0.0.0.0" cpu_cores="2" hyperthread="Y" con_id="1" con_name="CDB$ROOT" timezone_offset="-21600" packs="2">
<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="13:29:00 12/29/2018" report_time="13:34:05 12/29/2018"/>
<system_config>
<database dbid="1262297360" name="ORABASE1" log_mode="ARCHIVELOG" open_mode="READ WRITE" role="PRIMARY" force_log="YES" platform="Microsoft Windows x86 64-bit" flashback_on="NO" unique_name="orabase18" version="18.0.0.0.0"/>
<instances>
<instance number="1" name="orabase18" host="PERRITO5" version="18.0.0.0.0" startup_time="08:38:59 12/23/2018" status="OPEN" logins="ALLOWED" shutdown_pending="NO" role="PRIMARY_INSTANCE" active="NORMAL"/>
</instances>
</system_config>
<hangs>
<sessions/>
<blockers/>
<hang_info/>
</hangs>
<metrics>
<metric_names>
<map name="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 PerSec" unit="Rollbacks Per Second" id="4"/>
<map name="Network Traffic Volume Per Sec" unit="Bytes Per Second" id="5"/>
<map name="CPU Usage Per Sec" unit="CentiSeconds Per Second" 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 Per Get" id="11"/>
<map name="Global Cache Blocks Lost" unit="Blocks" id="12"/>
<map name="Current Logons Count" unit="Logons" id="13"/>
<map name="Current Open Cursors Count" unit="Cursors" id="14"/>
<map name="Process Limit %" unit="% Processes/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="Database 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 SynchronousSingle-Block Read Latency" unit="Milliseconds" id="22"/>
<map name="Background CPU Usage Per Sec" 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 name="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=".003" ma=".017" mi="0" id="1"/>
<m i="1" v=".053" ma=".067" mi=".05" id="2"/>
<m i="1" v=".003" ma=".017" mi="0" id="3"/>
<m i="1" v="0" ma="0" mi="0" id="4"/>
<m i="1" v="35.77" ma="111.533" mi="0" id="5"/>
<m i="1" v=".25" ma=".807" mi="0" id="6"/>
<m i="1" v="136916.69" ma="137949.867" mi="135219.2" 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" mi="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="52" ma="52" mi="52" id="13"/>
<m i="1" v="152" ma="152" mi="152" id="14"/>
<m i="1" v="19.688" ma="19.688" mi="19.688" id="15"/>
<m i="1" v="15.278" ma="15.278" mi="15.278" id="16"/>
<m i="1" v="1.5" ma="2.816" mi=".483" id="17"/>
<m i="1" v=".258" ma=".848" mi="0" id="18"/>
<m i="1" v="64191.959" ma="235876.574" mi="17996.8" id="19"/>
<m i="1" v="12.38" ma="14.024" mi="10.158" id="20"/>
<m i="1" v="0" ma="0" mi="0" id="21"/>
<m i="1" v=".137" ma=".181" mi=".106" id="22"/>
<m i="1" v=".182" ma=".391" mi=".026" id="23"/>
<m i="1" v="616312627.2" ma="616496128" mi="615578624" 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"/>
</data>
</metrics>
<ash_data sampling_ratio="1" avg_active_sessions=".0026" secs="305">
<op/>
<sid>
<m v="1_138_25879" i="1"/><m v="1_13_40619" i="2"/>
<m v="1_150_42740" i="3"/><m v="1_1_54911" i="4"/>
<m v="1_262_7170" i="5"/>
<m v="1_4_2388" i="6"/><m v="1_8_30958" i="7"/>
<m v="__" i="8"/>
</sid>
<evt>
<m c="Other" e="oracle thread bootstrap" i="2"/>
<m c="System I/O" e="log file parallel write" i="3"/>
<m c="System I/O" e="control file sequential read" i="4"/>
<m c="CPU" e="CPU" i="1"/>
</evt>
<service>
<m h="165959219" n="SYS$BACKGROUND" i="1"/>
</service><program>
<m v="ORACLE.EXE (TT00)" i="2"/>
<m v="ORACLE.EXE (MZ00)" i="3"/>
<m v="ORACLE.EXE (AQPC)" i="4"/>
<m v="ORACLE.EXE (MMON)" i="5"/>
<m v="ORACLE.EXE (LGWR)" i="6"/>
<m v="ORACLE.EXE (CJQ0)" i="7"/>
<m v="ORACLE.EXE (PSP0)" i="1"/>
</program>
<module>
<m v="MMON_SLAVE" i="2"/>
<m v="__" i="1"/>
</module>
<action>
<m v="DDE asyncaction" i="2"/><m v="__" i="1"/>
</action>
<sql>
<m f="0" o="0" s="null" i="1"/>
</sql>
<data>
<a>281,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>268,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>251,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>238,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>215,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>189,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>176,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>159,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>146,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>129,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>99,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>86,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>67,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>55,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>38,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>25,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>8,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>298,1,0,8,8,1,12,7,1,1,1,1,0</a>
<a>167,2,0,8,8,1,3,4,1,1,1,2,0</a>
<a>227,2,0,8,8,1,3,4,1,1,1,1,0</a>
<a>47,3,0,8,8,1,1,3,1,2,2,4,0</a>
<a>274,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>257,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>240,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>223,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>206,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>189,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>172,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>155,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>139,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>122,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>121,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>105,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>88,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>71,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>54,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>37,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>20,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>3,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>291,4,0,8,8,1,1,1,1,1,1,1,0</a>
<a>227,5,0,8,8,1,19,2,1,1,1,4,0</a>
<a>167,5,0,8,8,1,19,2,1,1,1,1,0</a>
<a>300,6,0,8,8,1,2,6,1,1,1,3,0</a>
<a>240,6,0,8,8,1,2,6,1,1,1,1,0</a>
<a>120,6,0,8,8,1,2,6,1,1,1,1,0</a>
<a>59,6,0,8,8,1,2,6,1,1,1,1,0</a>
<a>107,7,0,8,8,1,25,5,1,1,1,2,0</a>
</data>
</ash_data>
<osstat_pit>
<stat i="1" name="NUM_CPUS" v="4"/>
<stat i="1" name="NUM_CPU_CORES" v="2"/>
<stat i="1" name="PHYSICAL_MEMORY_BYTES" v="17028427776"/>
</osstat_pit>
<memory>
<mem i="1" n="pga" v="632880128"/>
<mem i="1"n="shared_io_pool" v="167772160"/>
<mem i="1" n="shared pool" v="561620936"/>
<mem i="1" n="java pool" v="16777216"/>
<mem i="1" n="log_buffer" v="7741440"/>
<mem i="1" n="buffer_cache" v="2332033024"/>
<mem i="1" n="SP free" v="42358840"/>
<mem i="1" n="large pool" v="33554432"/>
<mem i="1" n="fixed_sga" v="9032800"/></memory>
<resize_ops/>
<parameters>
<p n="active_instance_count" i="1"/>
<p n="event" i="1"/>
<p n="max_dispatchers" i="1"/>
<p n="timed_os_statistics" i="0">0</p>
<p n="shared_pool_size" i="0">0</p>
<p n="db_2k_cache_size" i="0">0</p>
<p n="db_8k_cache_size" i="0">0</p>
<p n="db_32k_cache_size" i="0">0</p>
<p n="db_keep_cache_size" i="0">16777216</p>
<p n="timed_statistics" i="0">TRUE</p>
<p n="large_pool_size" i="0">0</p>
<p n="db_file_multiblock_read_count" i="0">128</p>
<p n="statistics_level" i="0">TYPICAL</p>
<p n="sessions" i="0">504</p>
<p n="db_block_buffers" i="0">0</p>
<p n="db_block_size" i="0">8192</p>
<p n="compatible" i="0">18.0.0</p>
<p n="sga_max_size" i="0">3170893824</p>
<p n="gcs_server_processes" i="0">0</p>
<p n="db_cache_size" i="0">0</p>
<p n="cluster_database_instances" i="0">1</p>
<p n="db_block_checking" i="0">FALSE</p>
<p n="cursor_sharing" i="0">EXACT</p>
<p n="processes" i="0">320</p>
<p n="memory_target" i="0">0</p>
<p n="memory_max_target" i="0">0</p>
<p n="log_buffer" i="0">7405568</p>
<p n="cpu_count" i="0">4</p>
<p n="java_pool_size" i="0">0</p>
<p n="db_recycle_cache_size" i="0">16777216</p>
<p n="open_cursors" i="0">300</p>
<p n="pga_aggregate_target" i="0">1054867456</p>
<p n="sga_target" i="0">3170893824</p>
<p n="db_block_checksum" i="0">TYPICAL</p>
<p n="db_4k_cache_size" i="0">0</p>
<p n="undo_management" i="0">AUTO</p>
<p n="dispatchers" i="0">(PROTOCOL=TCP) (SERVICE=orabase18XDB)</p>
<p n="streams_pool_size" i="0">0</p>
<p n="db_16k_cache_size" i="0">0</p>
<p n="db_writer_processes" i="0">1</p>
<p n="cluster_database" i="0">FALSE</p>
</parameters>
</sql_data>
</report>
SQL> SPOOL OFF
-- open the report in a text editor |