SQL Monitor Report

SQL Monitoring Report

. 1 .

.


Elapsed
Time(s)
Queuing
Time(s)
Cpu
Time(s)
Sql Cpu Time IO
Waits(s)
Application
Waits(s)
Concurrency
Waits(s)
Cluster
Waits(s)
Other
Waits(s)
Fetch
Calls
Buffer
Gets
Reads Writes PL/SQL
Time(s)
Java
Time(s)
Cell
Offload
Read
Reqs
Read
Bytes
Write
Reqs
Write
Bytes
Set 1 Set 2 QC



Name Position Type Value
row tcell



SQL Text


Global Information
Status :
Instance ID :
Session:
Session:
Session:
SQL ID :
SQL Execution ID:
Execution Started:
First Refresh Time:
Last Refresh Time:
Duration:
Duration (Queued) :
Module/Action:
Module/Action:
Module/Action:
Service:
Program:
PLSQL Entry Ids (Object/Subprogram):
PLSQL Current Ids (Object/Subprogram) :
DOP Downgrade:
Fetch Calls:

row tcell

Parallel Execution Details (DOP= , Servers Requested= , Servers Allocated= )
Instances :

Instance Name Type Group# Server# Wait Events
(sample #)
row tcell
Instance Drill-Down
Instance Process Names Wait Events
row tcell
0 0

SQL Plan Monitoring Details (Plan Hash Value=) row
Id Operation Name Rows
(Estim)
Cost Time
Active(s)
Start
Active
Execs Rows
(Actual)
Read
Reqs
Read
Bytes
Write
Reqs
Write
Bytes
Cell
Offload
Mem Mem
(Max)
Temp Temp
(Max)
Activity
(%)
Activity Detail
(# samples)
Progress