Screenshots I

Following screenshots represent data which is available from APPM repository (postgres database). This data is periodically collected and stored into the APPM repository by APPM collector. Thus, all data presented here is available even when the Oracle database is not accessible.

dashboard Dashboard
ASH of databases on same host/pdb/cluster ASH ASH
Active Session History for specific database ash_compare_sql ASH Compare
Compare ASH and sql between different periods and/or databases lio_top_sql LIO & Top SQL
Amount of LIO per instance and top SQL statements temp_and_plan Temp TS & Top Execution Plans
Top 20 execution plans based on ASH. session_profile Session Profiling
What session was doing every second sql_execution_plan SQL execution plan
execution plan details sql_ash_plan SQL ASH plan
Which execution plan performed best? blocked_sessions Blocked Sessions
How many and which sessions were blocked by who? response_time_compare Response time compare
Comparing database response time for two periods/databases transactions Transactions
Amount of redo, undo, commits, rollbacks, ... Physical I/O Physical I/O
Amount of MB/s, IOPS and Total GB written/read CPU Usage CPU Usage
CPU Usage (I/O, User, System) and swapping db_time DB Time
Comparing DB Time between two periods sql_net SQL*Net
Amount of MB sent/recieved by clients or db links