SQL Monitor Report

SQL Monitoring Report

 . 1 .

.

.
Elapsed Queuing Time Cpu Sql Cpu Time IO Time Application Wait Time Concurrency Wait Time Cluster Wait Time Other Wait Time Fetch Calls Buffer Gets PL/SQL Time Java Time Cell Offload
Efficiency Read Requests Read Bytes Write Requests Write Bytes progress_Disp progress_Nodisp done
width:%;

.

.

 pxtype_S1 pxtype_S2 pxtype_QC Set 1 Set 2 QC


Name Position Type Value
s17a s17b


SQL Text

Global Information: s9 executing
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:
PL/SQL Entry Ids:
PL/SQL Ids (Obj/Sub):
DOP Downgrade:
Fetch Calls:
Buffer Gets IO Requests Cell Offload
Efficiency		 Database Time Wait Activity


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

PX Processes Drill-Down
Instance Name Type Group# Server# Buffer Gets IO Requests Cell Offload
Efficiency		 Database Time Wait Events


Instance Drill-Down
Instance Process Names Buffer Gets IO Requests Cell Offload
Efficiency		 Database Time Wait Events
0
width:% 0.9 0.8 0.6
activity div_ width:%

.
0% % % %
width:%
width:%

.
1
width:% width:%

.
active_period active_period_now active_period_10s active_period_60s active_period % width:%

.

width:% width:%

.

.

SQL Plan Monitoring Details (Plan Hash Value=)
Id Operation Name Estimated
Rows		 Cost Active Period
(s)		 Execs Rows Memory Memory
(Max) 		Temp Temp
(Max) 		IO Requests Cell Offload
Efficiency		 CPU Activity Wait Activity Progress
s17a s17b #F5F5F5 #F1F5DD noright noright pxtype_QC noright pxtype_S1 noright pxtype_S2 noright pxtype_QC

.

 noleft noleft pxtype_QC noleft pxtype_S1 noleft pxtype_S2 noleft pxtype_QC Not yet executed Never executed PX Coordinator PX Set 1 PX Set 2 Serial Execution

.

.

.