Screenshots II

Following screenshots represent data and actions available using active SQL*Net connection to the monitored Oracle Database. Thus, all data presented here reflects current (and not historic/sampled) state of the database.

Sessions

Sessions
All currently active sessions

Session info

Session info
Basic info regarding specific session

Blocked sessions

Blocked sessions
Who is blocking who and which SQL are blockers running.

Session trace

Session trace
Ability to run SQL Trace without ssh/rdp access to the server.

Transactions

Transactions
Currently active transactions and amount of data that they changed.

Tablespaces

Tablespaces
Usage of each tablespace/datafile, calculated also with autoextend limits

SQL Trace

SQL Trace
List of trace files and ability to start a trace using on-logon trigger.

SQL Patches

SQL Patches
List of SQL patches with their applied hints

SQL Patch

SQL Patch
Ability to create SQL Patch using graphical interface.

SQL Baseline

SQL Baseline
Ability to create SQL Baseline with single click.

Alert Log

Alert Log
Access to alert log without need for ssh/rdp.

Databases

Databases
List of databases registered with APPM repository.

PGA Usage

PGA Usage
Memory summary and per-process PGA usage. SQL exec plan

SQL exec plan

SQL Execution Plan
... as obtained from SGA.