T. de respuesta para Discos:
NSTANCE_NUMBER BEGIN_TIME average(ms) maxval(ms)
--------------- ---------------- ----------- ----------
2 18-JUN-14 00:59 ,94 2,08
2 18-JUN-14 01:59 ,93 2,46
2 18-JUN-14 03:00 1,37 2,4
2 18-JUN-14 03:59 1,51 5,01
2 18-JUN-14 04:59 1,27 5,36
2 18-JUN-14 05:59 ,94 1,72
2 18-JUN-14 06:59 1,35 5,6
2 18-JUN-14 07:59 1,83 2,72
2 18-JUN-14 09:00 2,04 5,59
2 18-JUN-14 09:59 1,82 2,43
T, respuestas SQL:
INSTANCE_NUMBER BEGIN_TI HORA METRIC_NAME Tiempo Respuesta(s)
--------------- -------- -------- ------------------------- -------------------
2 18/06/14 00 SQL Response Time (secs) ,1
2 18/06/14 01 SQL Response Time (secs) ,05
2 18/06/14 02 SQL Response Time (secs) ,06
2 18/06/14 03 SQL Response Time (secs) 2,47
2 18/06/14 04 SQL Response Time (secs) 1,27
2 18/06/14 05 SQL Response Time (secs) 1,15
2 18/06/14 06 SQL Response Time (secs) 2,08
2 18/06/14 07 SQL Response Time (secs) ,07
2 18/06/14 08 SQL Response Time (secs) ,06
2 18/06/14 09 SQL Response Time (secs) ,06
2 18/06/14 10 SQL Response Time (secs) ,06
T. Respuesta TRansacciones:
NSTANCE_NUMBER BEGIN_TI HORA METRIC_NAME Tiempo Respuesta(s)
--------------- -------- ---- ------------------------------ -------------------
2 18/06/14 00 Response Time Per Txn (secs) 2,37
2 18/06/14 01 Response Time Per Txn (secs) 1,31
2 18/06/14 02 Response Time Per Txn (secs) 1,65
2 18/06/14 03 Response Time Per Txn (secs) 68,58
2 18/06/14 04 Response Time Per Txn (secs) 33,41
2 18/06/14 05 Response Time Per Txn (secs) 32,25
2 18/06/14 06 Response Time Per Txn (secs) 73,39
2 18/06/14 07 Response Time Per Txn (secs) 1,59
2 18/06/14 08 Response Time Per Txn (secs) 1,39
2 18/06/14 09 Response Time Per Txn (secs) 1,48
2 18/06/14 10 Response Time Per Txn (secs) 1,44
TPS:
INSTANCE_NUMBER SNAP_ID DATETIME Commits/s Rollbacks/s TX/s
--------------- ---------- --------------- ---------- ----------- ----------
2 16989 18-06-14 01 7,42 0 7,42
2 16990 18-06-14 02 5,06 0 5,06
2 16991 18-06-14 03 4,04 0 4,04
2 16992 18-06-14 04 3,54 0 3,55
2 16993 18-06-14 05 3,6 0 3,6
2 16994 18-06-14 06 4,4 0 4,4
2 16995 18-06-14 07 8,06 0 8,06
2 16996 18-06-14 08 18,95 0 18,95
2 16997 18-06-14 09 33,87 0 33,87
2 16998 18-06-14 10 37,73 0 37,73
OBS:
siempre debemos estar monitoreando estas variables en nuestro entorno Oracle