1) Archive Generation Pattern
1 2011-08-29 40 0 4 4 0 2 0 0 2 0 0 0 2 12 6 0 0 2 0 0 0 0 2 2 2
2 2011-08-29 14 0 2 0 0 2 0 0 0 0 0 0 0 4 2 0 0 2 0 0 0 0 0 0 2
1 2011-08-30 32 0 2 2 0 0 2 0 0 0 2 0 0 14 4 0 0 0 2 0 0 0 0 2 2
2 2011-08-30 14 0 0 2 2 0 0 0 0 0 0 0 0 6 2 0 0 0 0 0 0 0 0 0 2
1 2011-08-31 36 0 4 2 2 2 0 0 0 2 0 0 0 12 6 0 0 2 0 0 0 2 0 0 2
2 2011-08-31 12 0 0 2 0 0 0 0 0 2 0 0 0 4 2 0 0 0 0 0 0 0 0 0 2
1 2011-09-01 34 0 2 2 0 0 2 0 0 0 2 0 0 2 0 0 0 2 0 0 2 0 0 18 2
2 2011-09-01 16 0 0 4 0 0 0 0 0 0 0 0 2 0 0 0 0 0 2 0 0 0 0 6 2
1 2011-09-02 38 0 2 6 2 0 0 0 2 0 0 0 2 0 0 0 2 0 0 0 2 0 0 18 2
2 2011-09-02 14 0 0 2 2 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 6 2
1 2011-09-03 32 0 2 2 0 0 2 0 0 0 2 0 0 0 2 0 0 0 2 0 0 0 0 18 2
2 2011-09-03 16 0 0 2 2 0 0 0 0 0 0 2 0 0 0 0 2 0 0 0 0 0 0 6 2
1 2011-09-04 36 0 4 2 2 2 0 0 2 0 0 0 0 2 0 0 0 0 2 0 0 0 0 18 2
2 2011-09-04 14 0 2 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 6 2
1 2011-09-05 34 0 2 2 0 0 2 0 0 0 2 0 2 0 0 0 2 0 0 0 0 2 0 18 2
2 2011-09-05 16 0 0 2 2 0 0 0 0 0 0 2 0 0 0 2 0 0 0 0 0 0 0 6 2
2) Lets analyze the Delta Change during the Bad time when Archive generation is high
a) 29-Aug-11 (10am to 1pm)
SELECT to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time,
dhsso.object_name,
sum(db_block_changes_delta)
FROM dba_hist_seg_stat dhss,
dba_hist_seg_stat_obj dhsso,
dba_hist_snapshot dhs
WHERE dhs.snap_id = dhss.snap_id
AND dhs.instance_number = dhss.instance_number
AND dhss.obj# = dhsso.obj#
AND dhss.dataobj# = dhsso.dataobj#
AND begin_interval_time BETWEEN to_date('2011_08_29 10','YYYY_MM_DD HH24')
AND to_date('2011_08_29 13','YYYY_MM_DD HH24')
GROUP BY to_char(begin_interval_time,'YYYY_MM_DD HH24:MI'),
dhsso.object_name order by sum(db_block_changes_delta)
SNAP_TIME OBJECT_NAME SUM(DB_BLOCK_CHANGES_DELTA)
---------------- ------------------------------ ---------------------------
2011_08_29 10:24 WMS_TXN_CONTEXT_TEMP 136672
2011_08_29 12:30 WRH$_SQL_PLAN 163200
2011_08_29 12:30 WRH$_SYSMETRIC_HISTORY_INDEX 203840
2011_08_29 10:25 MO_GLOB_ORG_ACCESS_TMP 270208
2011_08_29 10:25 PO_SESSION_GT_N2 303536
2011_08_29 11:30 FND_CONFLICTS_DOMAIN 571488
2011_08_29 12:30 FND_CONFLICTS_DOMAIN 582512
2011_08_29 10:25 FND_CONFLICTS_DOMAIN 629840
2011_08_29 10:25 ZX_TRX_HEADERS_GT 659568
2011_08_29 12:30 I_WRI$_OPTSTAT_TAB_ST 72265344
2011_08_29 12:30 I_WRI$_OPTSTAT_TAB_OBJ#_ST 84655424
2011_08_29 12:30 WRI$_OPTSTAT_TAB_HISTORY 85934352
b) 30-Aug-11 (11am to 1pm)
SELECT to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time,
dhsso.object_name,
sum(db_block_changes_delta)
FROM dba_hist_seg_stat dhss,
dba_hist_seg_stat_obj dhsso,
dba_hist_snapshot dhs
WHERE dhs.snap_id = dhss.snap_id
AND dhs.instance_number = dhss.instance_number
AND dhss.obj# = dhsso.obj#
AND dhss.dataobj# = dhsso.dataobj#
AND begin_interval_time BETWEEN to_date('2011_08_30 11','YYYY_MM_DD HH24')
AND to_date('2011_08_30 13','YYYY_MM_DD HH24')
GROUP BY to_char(begin_interval_time,'YYYY_MM_DD HH24:MI'),
dhsso.object_name order by sum(db_block_changes_delta)
SNAP_TIME OBJECT_NAME SUM(DB_BLOCK_CHANGES_DELTA)
---------------- ------------------------------ ---------------------------
2011_08_30 11:30 FND_CONCURRENT_REQUESTS 31280
2011_08_30 12:30 FND_CONCURRENT_QUEUES 32832
2011_08_30 11:29 FND_CONCURRENT_REQUESTS 36240
2011_08_30 12:30 FND_CONCURRENT_REQUESTS 38320
2011_08_30 12:30 WRH$_SYSMETRIC_HISTORY 60480
2011_08_30 12:30 WRH$_BG_EVENT_SUMMARY 72240
2011_08_30 12:30 WRH$_SQL_PLAN_PK 181376
2011_08_30 12:30 WRH$_SQL_PLAN 211968
2011_08_30 12:30 FND_CONFLICTS_DOMAIN 577952
2011_08_30 11:30 FND_CONFLICTS_DOMAIN 587280
2011_08_30 12:30 I_WRI$_OPTSTAT_TAB_ST 68203584
2011_08_30 12:30 I_WRI$_OPTSTAT_TAB_OBJ#_ST 79671760
2011_08_30 12:30 WRI$_OPTSTAT_TAB_HISTORY 80881696
c) 31-Aug-11 (11am to 1pm)
SELECT to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time,
dhsso.object_name,
sum(db_block_changes_delta)
FROM dba_hist_seg_stat dhss,
dba_hist_seg_stat_obj dhsso,
dba_hist_snapshot dhs
WHERE dhs.snap_id = dhss.snap_id
AND dhs.instance_number = dhss.instance_number
AND dhss.obj# = dhsso.obj#
AND dhss.dataobj# = dhsso.dataobj#
AND begin_interval_time BETWEEN to_date('2011_08_31 11','YYYY_MM_DD HH24')
AND to_date('2011_08_31 13','YYYY_MM_DD HH24')
GROUP BY to_char(begin_interval_time,'YYYY_MM_DD HH24:MI'),
dhsso.object_name order by sum(db_block_changes_delta)
SNAP_TIME OBJECT_NAME SUM(DB_BLOCK_CHANGES_DELTA)
---------------- ------------------------------ ---------------------------
2011_08_31 12:30 FND_CONCURRENT_PROCESSES 20480
2011_08_31 12:30 MGMT_CURRENT_METRICS_PK 21728
2011_08_31 12:30 FND_CONCURRENT_QUEUES 21760
2011_08_31 11:30 MGMT_CURRENT_METRICS_PK 23664
2011_08_31 11:30 FND_CONCURRENT_QUEUES 23808
2011_08_31 12:30 WRH$_BG_EVENT_SUMMARY 77056
2011_08_31 12:30 WRH$_ENQUEUE_STAT 82176
2011_08_31 12:30 WRH$_SQL_PLAN 194304
2011_08_31 12:30 WRH$_SYSMETRIC_HISTORY_INDEX 233280
2011_08_31 12:30 WRH$_SYSMETRIC_HISTORY 237120
2011_08_31 12:30 FND_CONFLICTS_DOMAIN 573760
2011_08_31 11:30 FND_CONFLICTS_DOMAIN 578416
2011_08_31 12:30 I_WRI$_OPTSTAT_TAB_ST 70738272
2011_08_31 12:30 I_WRI$_OPTSTAT_TAB_OBJ#_ST 82630016
2011_08_31 12:30 WRI$_OPTSTAT_TAB_HISTORY 83876576
On 5-Sep archive generation is high at night between 9pm to 10pm, below output shows that delta change is maximum on sysaux objects
d) 5-Sep-11 (8pm to 10pm)
SELECT to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time,
dhsso.object_name,
sum(db_block_changes_delta)
FROM dba_hist_seg_stat dhss,
dba_hist_seg_stat_obj dhsso,
dba_hist_snapshot dhs
WHERE dhs.snap_id = dhss.snap_id
AND dhs.instance_number = dhss.instance_number
AND dhss.obj# = dhsso.obj#
AND dhss.dataobj# = dhsso.dataobj#
AND begin_interval_time BETWEEN to_date('2011_09_05 20','YYYY_MM_DD HH24')
AND to_date('2011_09_05 22','YYYY_MM_DD HH24')
GROUP BY to_char(begin_interval_time,'YYYY_MM_DD HH24:MI'),
dhsso.object_name order by sum(db_block_changes_delta)
SNAP_TIME OBJECT_NAME SUM(DB_BLOCK_CHANGES_DELTA)
---------------- ------------------------------ ---------------------------
2011_09_05 21:30 MGMT_CURRENT_METRICS_PK 23776
2011_09_05 20:30 MGMT_CURRENT_METRICS_PK 23952
2011_09_05 20:30 MGMT_METRICS_RAW_PK 25456
2011_09_05 21:30 FND_CONCURRENT_QUEUES 26112
2011_09_05 21:30 SEG$ 27264
2011_09_05 20:30 FND_CONCURRENT_QUEUES 30720
2011_09_05 21:30 MGMT_METRICS_RAW_PK 31728
2011_09_05 21:30 TAB$ 41216
2011_09_05 21:30 ** UNAVAILABLE ** 43552
2011_09_05 21:30 FND_CONFLICTS_DOMAIN 591952
2011_09_05 20:30 FND_CONFLICTS_DOMAIN 601952
2011_09_05 21:30 I_WRI$_OPTSTAT_TAB_ST 26851584
2011_09_05 21:30 I_WRI$_OPTSTAT_TAB_OBJ#_ST 31542784
2011_09_05 21:30 WRI$_OPTSTAT_TAB_HISTORY 31848432
3) Analyze the Delta Change during the Good time when Archive generation is less
We can see in the below output that there is NO Delta Change on Sysaux objects
a) 31-Aug-11 (9am to 10am)
SELECT to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time,
dhsso.object_name,
sum(db_block_changes_delta)
FROM dba_hist_seg_stat dhss,
dba_hist_seg_stat_obj dhsso,
dba_hist_snapshot dhs
WHERE dhs.snap_id = dhss.snap_id
AND dhs.instance_number = dhss.instance_number
AND dhss.obj# = dhsso.obj#
AND dhss.dataobj# = dhsso.dataobj#
AND begin_interval_time BETWEEN to_date('2011_08_31 9','YYYY_MM_DD HH24')
AND to_date('2011_08_31 10','YYYY_MM_DD HH24')
GROUP BY to_char(begin_interval_time,'YYYY_MM_DD HH24:MI'),
dhsso.object_name order by sum(db_block_changes_delta)
SNAP_TIME OBJECT_NAME SUM(DB_BLOCK_CHANGES_DELTA)
---------------- ------------------------------ ---------------------------
2011_08_31 09:30 WRH$_SQL_PLAN 14464
2011_08_31 09:30 FND_CONCURRENT_REQUESTS 19280
2011_08_31 09:30 MGMT_CURRENT_METRICS_PK 22240
2011_08_31 09:30 FND_CONCURRENT_PROCESSES 23808
2011_08_31 09:30 MGMT_METRICS_RAW_PK 24208
2011_08_31 09:30 FND_CONCURRENT_QUEUES 24704
2011_08_31 09:30 COL_USAGE$ 35040
2011_08_31 09:30 MTL_MWB_GTMP 116144
2011_08_31 09:30 FND_CONFLICTS_DOMAIN 578544
b) 5-Sep-11 (11am to 1pm)
SELECT to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time,
dhsso.object_name,
sum(db_block_changes_delta)
FROM dba_hist_seg_stat dhss,
dba_hist_seg_stat_obj dhsso,
dba_hist_snapshot dhs
WHERE dhs.snap_id = dhss.snap_id
AND dhs.instance_number = dhss.instance_number
AND dhss.obj# = dhsso.obj#
AND dhss.dataobj# = dhsso.dataobj#
AND begin_interval_time BETWEEN to_date('2011_09_05 11','YYYY_MM_DD HH24')
AND to_date('2011_09_05 13','YYYY_MM_DD HH24')
GROUP BY to_char(begin_interval_time,'YYYY_MM_DD HH24:MI'),
dhsso.object_name order by sum(db_block_changes_delta)
SNAP_TIME OBJECT_NAME SUM(DB_BLOCK_CHANGES_DELTA)
---------------- ------------------------------ ---------------------------
2011_09_05 11:30 CM_CMPT_DTL_PK 100256
2011_09_05 11:30 CM_CMPT_DTL_U1 101600
2011_09_05 11:30 CM_CMPT_DTL 108704
2011_09_05 11:30 MTL_MWB_GTMP 128224
2011_09_05 11:30 XLA_AE_LINES_GT_U1 132400
2011_09_05 12:29 XLA_AE_HEADERS_GT_N1 138672
2011_09_05 11:30 XLA_EVENTS_GT_U1 162416
2011_09_05 11:30 FND_CONFLICTS_DOMAIN 591248
2011_09_05 12:30 FND_CONFLICTS_DOMAIN 602464
4) Changes during the period of time on I_WRI$_OPTSTAT_TAB_ST, I_WRI$_OPTSTAT_TAB_OBJ#_ST, WRI$_OPTSTAT_TAB_HISTORY objects
Below highlighted output shows the maximum delta changes over the period of time
a) WRI$_OPTSTAT_TAB_HISTORY
SELECT to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time,
sum(db_block_changes_delta)
FROM dba_hist_seg_stat dhss,
dba_hist_seg_stat_obj dhsso,
dba_hist_snapshot dhs
WHERE dhs.snap_id = dhss.snap_id
AND dhs.instance_number = dhss.instance_number
AND dhss.obj# = dhsso.obj#
AND dhss.dataobj# = dhsso.dataobj#
AND dhsso.object_name = 'WRI$_OPTSTAT_TAB_HISTORY'
GROUP BY to_char(begin_interval_time,'YYYY_MM_DD HH24:MI')
order by SNAP_TIME
SNAP_TIME SUM(DB_BLOCK_CHANGES_DELTA)
---------------- ---------------------------
2011_08_29 00:30 264880
2011_08_29 01:30 87024
2011_08_29 02:30 119168
2011_08_29 09:30 2240
2011_08_29 12:29 4144
2011_08_29 12:30 85934352
2011_08_29 13:30 1120
2011_08_30 00:30 48496
2011_08_30 01:30 80304
2011_08_30 02:29 114240
2011_08_30 12:30 80881696
2011_08_31 00:30 31584
2011_08_31 01:30 77616
2011_08_31 02:30 84336
2011_08_31 03:30 42784
2011_08_31 12:30 83876576
2011_08_31 14:30 7280
2011_08_31 17:30 3472
2011_09_01 00:30 47936
2011_09_01 01:30 83888
2011_09_01 02:30 118608
2011_09_01 21:30 52190096
2011_09_01 22:30 34005328
2011_09_02 00:30 47488
2011_09_02 01:30 86800
2011_09_02 02:30 104384
2011_09_02 03:30 18928
2011_09_02 08:30 3584
2011_09_02 21:30 46538800
2011_09_02 22:30 37613184
2011_09_02 23:30 1792
2011_09_03 00:29 40656
2011_09_03 01:29 76720
2011_09_03 02:30 102032
2011_09_03 03:29 28672
2011_09_03 21:30 43885968
2011_09_03 22:30 41041280
2011_09_04 00:30 37296
2011_09_04 01:30 88928
2011_09_04 02:30 82432
2011_09_04 03:30 57344
2011_09_04 10:29 1904
2011_09_04 21:30 38112480
2011_09_04 22:30 45306128
2011_09_05 00:29 29232
2011_09_05 01:30 83328
2011_09_05 02:29 64512
2011_09_05 03:30 70784
2011_09_05 09:30 5600
2011_09_05 10:29 2352
2011_09_05 21:30 31848432
2011_09_05 22:30 51457952
2011_09_05 23:30 1904
2011_09_06 00:30 39648
2011_09_06 01:30 82544
2011_09_06 02:30 105056
2011_09_06 03:30 24416
2011_09_06 09:30 2128
58 rows selected.
b) I_WRI$_OPTSTAT_TAB_OBJ#_ST
SELECT to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time,
sum(db_block_changes_delta)
FROM dba_hist_seg_stat dhss,
dba_hist_seg_stat_obj dhsso,
dba_hist_snapshot dhs
WHERE dhs.snap_id = dhss.snap_id
AND dhs.instance_number = dhss.instance_number
AND dhss.obj# = dhsso.obj#
AND dhss.dataobj# = dhsso.dataobj#
AND dhsso.object_name = 'I_WRI$_OPTSTAT_TAB_OBJ#_ST'
GROUP BY to_char(begin_interval_time,'YYYY_MM_DD HH24:MI')
order by SNAP_TIME
SNAP_TIME SUM(DB_BLOCK_CHANGES_DELTA)
---------------- ---------------------------
2011_08_29 00:30 40992
2011_08_29 01:30 213472
2011_08_29 02:30 114128
2011_08_29 12:30 84655424
2011_08_29 14:29 151536
2011_08_29 14:30 336
2011_08_30 00:30 40432
2011_08_30 01:30 73472
2011_08_30 02:29 113792
2011_08_30 12:30 79671760
2011_08_30 14:30 123088
2011_08_31 00:30 34384
2011_08_31 01:30 73472
2011_08_31 03:30 44576
2011_08_31 12:30 82630016
2011_08_31 16:30 133168
2011_09_01 00:30 44352
2011_09_01 01:30 83888
2011_09_01 03:30 0
2011_09_01 21:30 51699088
2011_09_01 22:30 33228608
2011_09_02 00:30 197680
2011_09_02 01:30 89376
2011_09_02 02:30 139776
2011_09_02 03:30 27888
2011_09_02 16:29 336
2011_09_02 16:30 0
2011_09_02 21:30 46133472
2011_09_02 22:30 36775984
2011_09_03 00:29 40768
2011_09_03 01:29 81872
2011_09_03 02:30 112560
2011_09_03 03:29 28560
2011_09_03 21:30 43523200
2011_09_03 22:30 40145840
2011_09_04 00:30 170912
2011_09_04 01:30 91168
2011_09_04 02:30 81424
2011_09_04 03:30 55216
2011_09_04 13:30 224
2011_09_04 21:30 37803808
2011_09_04 22:30 44384816
2011_09_05 00:29 174832
2011_09_05 01:30 89376
2011_09_05 02:29 67872
2011_09_05 03:30 76496
2011_09_05 15:30 336
2011_09_05 21:30 31542784
2011_09_05 22:30 50534288
2011_09_06 00:30 35392
2011_09_06 01:30 79296
2011_09_06 02:30 113344
2011_09_06 03:30 27888
c) I_WRI$_OPTSTAT_TAB_OBJ#_ST
SELECT to_char(begin_interval_time,'YYYY_MM_DD HH24:MI') snap_time,
sum(db_block_changes_delta)
FROM dba_hist_seg_stat dhss,
dba_hist_seg_stat_obj dhsso,
dba_hist_snapshot dhs
WHERE dhs.snap_id = dhss.snap_id
AND dhs.instance_number = dhss.instance_number
AND dhss.obj# = dhsso.obj#
AND dhss.dataobj# = dhsso.dataobj#
AND dhsso.object_name = 'I_WRI$_OPTSTAT_TAB_OBJ#_ST'
GROUP BY to_char(begin_interval_time,'YYYY_MM_DD HH24:MI')
order by SNAP_TIME
/
SNAP_TIME SUM(DB_BLOCK_CHANGES_DELTA)
---------------- ---------------------------
2011_08_29 00:30 40992
2011_08_29 01:30 213472
2011_08_29 02:30 114128
2011_08_29 12:30 84655424
2011_08_29 14:29 151536
2011_08_29 14:30 336
2011_08_30 00:30 40432
2011_08_30 01:30 73472
2011_08_30 02:29 113792
2011_08_30 12:30 79671760
2011_08_30 14:30 123088
2011_08_31 00:30 34384
2011_08_31 01:30 73472
2011_08_31 03:30 44576
2011_08_31 12:30 82630016
2011_08_31 16:30 133168
2011_09_01 00:30 44352
2011_09_01 01:30 83888
2011_09_01 03:30 0
2011_09_01 21:30 51699088
2011_09_01 22:30 33228608
2011_09_02 00:30 197680
2011_09_02 01:30 89376
2011_09_02 02:30 139776
2011_09_02 03:30 27888
2011_09_02 16:29 336
2011_09_02 16:30 0
2011_09_02 21:30 46133472
2011_09_02 22:30 36775984
2011_09_03 00:29 40768
2011_09_03 01:29 81872
2011_09_03 02:30 112560
2011_09_03 03:29 28560
2011_09_03 21:30 43523200
2011_09_03 22:30 40145840
2011_09_04 00:30 170912
2011_09_04 01:30 91168
2011_09_04 02:30 81424
2011_09_04 03:30 55216
2011_09_04 13:30 224
2011_09_04 21:30 37803808
2011_09_04 22:30 44384816
2011_09_05 00:29 174832
2011_09_05 01:30 89376
2011_09_05 02:29 67872
2011_09_05 03:30 76496
2011_09_05 15:30 336
2011_09_05 21:30 31542784
2011_09_05 22:30 50534288
2011_09_06 00:30 35392
2011_09_06 01:30 79296
2011_09_06 02:30 113344
2011_09_06 03:30 27888
5) SQL Responbile for High Archives
a) sql_id = c64x40vthcrh3
delete from sys.wri$_optstat_tab_history where nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and obj# = nvl(:3, obj#)
b) sql_id = 45bv71pwwj176
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
WRI$_OPTSTAT_TAB_HISTORY
SQL> SELECT to_char(begin_interval_time,'YYYY_MM_DD HH24:MI'),
2 dbms_lob.substr(sql_text,4000,1),
3 dhss.instance_number,
4 dhss.sql_id,executions_delta,rows_processed_delta
5 FROM dba_hist_sqlstat dhss,
6 dba_hist_snapshot dhs,
7 dba_hist_sqltext dhst
8 WHERE upper(dhst.sql_text) LIKE '%WRI$_OPTSTAT_TAB_HISTORY%'
9 AND dhss.snap_id=dhs.snap_id
10 AND dhss.instance_Number=dhs.instance_number
11 AND dhss.sql_id = dhst.sql_id
12 order by EXECUTIONS_DELTA
13 /
TO_CHAR(BEGIN_IN
----------------
DBMS_LOB.SUBSTR(SQL_TEXT,4000,1)
--------------------------------------------------------------------------------
INSTANCE_NUMBER SQL_ID EXECUTIONS_DELTA ROWS_PROCESSED_DELTA
--------------- ------------- ---------------- --------------------
2011_08_29 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10777 10777
2011_08_29 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10777 10777
2011_08_29 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10777 10777
2011_08_29 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10777 10777
2011_08_29 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10777 10777
2011_08_29 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10777 10777
2011_08_29 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 15585 15585
2011_08_29 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 15585 15585
2011_08_29 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 15585 15585
2011_08_29 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 15585 15585
2011_08_29 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 15585 15585
2011_08_29 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 15585 15585
2011_08_29 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5412 5412
2011_08_29 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5412 5412
2011_08_29 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5412 5412
2011_08_29 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5412 5412
2011_08_29 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5412 5412
2011_08_29 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5412 5412
2011_08_29 12:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_08_29 12:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_08_29 12:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_08_29 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 70 70
2011_08_29 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 70 70
2011_08_29 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 70 70
2011_08_29 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 70 70
2011_08_29 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 70 70
2011_08_29 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 70 70
2011_08_29 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 36 36
2011_08_29 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 36 36
2011_08_29 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 36 36
2011_08_29 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 36 36
2011_08_29 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 36 36
2011_08_29 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 36 36
2011_08_29 14:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 38 38
2011_08_29 14:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 38 38
2011_08_29 14:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 38 38
2011_08_29 14:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 38 38
2011_08_29 14:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 38 38
2011_08_29 14:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 38 38
2011_08_29 12:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 34 34
2011_08_29 12:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 34 34
2011_08_29 12:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 34 34
2011_08_29 12:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 34 34
2011_08_29 12:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 34 34
2011_08_29 12:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 34 34
2011_08_30 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 5893 5893
2011_08_30 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 5893 5893
2011_08_30 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 5893 5893
2011_08_30 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 5893 5893
2011_08_30 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 5893 5893
2011_08_30 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 5893 5893
2011_08_30 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15149 15149
2011_08_30 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15149 15149
2011_08_30 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15149 15149
2011_08_30 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15149 15149
2011_08_30 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15149 15149
2011_08_30 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15149 15149
2011_08_30 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10462 10462
2011_08_30 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10462 10462
2011_08_30 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10462 10462
2011_08_30 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10462 10462
2011_08_30 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10462 10462
2011_08_30 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10462 10462
2011_08_30 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 334 334
2011_08_30 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 334 334
2011_08_30 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 334 334
2011_08_30 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 334 334
2011_08_30 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 334 334
2011_08_30 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 334 334
2011_08_30 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 16 15
2011_08_30 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 16 15
2011_08_30 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 16 15
2011_08_30 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 16 15
2011_08_30 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 16 15
2011_08_30 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 16 15
2011_08_30 12:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_08_30 12:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_08_30 12:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_08_31 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4459 4459
2011_08_31 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4459 4459
2011_08_31 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4459 4459
2011_08_31 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4459 4459
2011_08_31 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4459 4459
2011_08_31 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4459 4459
2011_08_31 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 6057 6057
2011_08_31 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 6057 6057
2011_08_31 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 6057 6057
2011_08_31 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 6057 6057
2011_08_31 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 6057 6057
2011_08_31 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 6057 6057
2011_08_31 12:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_08_31 12:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_08_31 12:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_08_31 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 1
2011_08_31 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 1
2011_08_31 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 1
2011_08_31 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 1
2011_08_31 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 1
2011_08_31 12:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 1
2011_08_31 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10319 10319
2011_08_31 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10319 10319
2011_08_31 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10319 10319
2011_08_31 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10319 10319
2011_08_31 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10319 10319
2011_08_31 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10319 10319
2011_08_31 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 11056 11056
2011_08_31 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 11056 11056
2011_08_31 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 11056 11056
2011_08_31 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 11056 11056
2011_08_31 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 11056 11056
2011_08_31 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 11056 11056
2011_08_31 16:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9 9
2011_08_31 16:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9 9
2011_08_31 16:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9 9
2011_08_31 16:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9 9
2011_08_31 16:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9 9
2011_08_31 16:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9 9
2011_08_31 17:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 14 14
2011_08_31 17:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 14 14
2011_08_31 17:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 14 14
2011_08_31 17:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 14 14
2011_08_31 17:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 14 14
2011_08_31 17:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 14 14
2011_08_30 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 13 13
2011_08_30 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 13 13
2011_08_30 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 13 13
2011_08_30 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 13 13
2011_08_30 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 13 13
2011_08_30 14:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
TO_CHAR(BEGIN_IN
----------------
DBMS_LOB.SUBSTR(SQL_TEXT,4000,1)
--------------------------------------------------------------------------------
INSTANCE_NUMBER SQL_ID EXECUTIONS_DELTA ROWS_PROCESSED_DELTA
--------------- ------------- ---------------- --------------------
2 45bv71pwwj176 13 13
2011_09_02 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13984 13984
2011_09_02 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13984 13984
2011_09_02 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13984 13984
2011_09_02 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13984 13984
2011_09_02 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13984 13984
2011_09_02 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13984 13984
2011_09_02 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 2386 2386
2011_09_02 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 2386 2386
2011_09_02 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 2386 2386
2011_09_02 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 2386 2386
2011_09_02 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 2386 2386
2011_09_02 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 2386 2386
2011_09_02 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5051 5051
2011_09_02 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5051 5051
2011_09_02 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5051 5051
2011_09_02 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5051 5051
2011_09_02 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5051 5051
2011_09_02 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 5051 5051
2011_09_01 21:30
TO_CHAR(BEGIN_IN
----------------
DBMS_LOB.SUBSTR(SQL_TEXT,4000,1)
--------------------------------------------------------------------------------
INSTANCE_NUMBER SQL_ID EXECUTIONS_DELTA ROWS_PROCESSED_DELTA
--------------- ------------- ---------------- --------------------
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_01 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_01 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_02 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10510 10510
2011_09_02 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10510 10510
2011_09_02 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10510 10510
2011_09_02 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10510 10510
2011_09_02 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10510 10510
2011_09_02 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10510 10510
2011_09_01 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_01 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_01 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_01 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_01 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_01 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_01 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 6037 6037
2011_09_01 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 6037 6037
2011_09_01 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 6037 6037
2011_09_01 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 6037 6037
2011_09_01 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 6037 6037
2011_09_01 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 6037 6037
2011_09_01 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15528 15528
2011_09_01 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15528 15528
2011_09_01 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15528 15528
2011_09_01 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15528 15528
2011_09_01 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15528 15528
2011_09_01 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 15528 15528
2011_09_01 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10333 10333
2011_09_01 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10333 10333
2011_09_01 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10333 10333
2011_09_01 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10333 10333
2011_09_01 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10333 10333
2011_09_01 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10333 10333
2011_09_02 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_02 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_02 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_03 10:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 61 61
TO_CHAR(BEGIN_IN
----------------
DBMS_LOB.SUBSTR(SQL_TEXT,4000,1)
--------------------------------------------------------------------------------
INSTANCE_NUMBER SQL_ID EXECUTIONS_DELTA ROWS_PROCESSED_DELTA
--------------- ------------- ---------------- --------------------
2011_09_03 10:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 61 61
2011_09_03 10:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 61 61
2011_09_03 10:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 61 61
2011_09_03 10:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 61 61
2011_09_03 10:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 61 61
2011_09_02 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_02 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_02 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_02 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_02 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_02 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_03 01:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10490 10490
2011_09_03 01:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10490 10490
2011_09_03 01:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10490 10490
2011_09_03 01:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10490 10490
2011_09_03 01:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10490 10490
2011_09_03 01:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10490 10490
2011_09_03 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 13245 13245
2011_09_03 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 13245 13245
2011_09_03 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 13245 13245
2011_09_03 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 13245 13245
2011_09_03 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 13245 13245
2011_09_03 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 13245 13245
2011_09_03 03:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3491 3491
2011_09_03 03:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3491 3491
2011_09_03 03:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3491 3491
2011_09_03 03:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3491 3491
2011_09_03 03:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3491 3491
2011_09_03 03:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3491 3491
2011_09_03 13:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 30 30
2011_09_03 13:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 30 30
2011_09_03 13:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 30 30
2011_09_03 13:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 30 30
2011_09_03 13:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 30 30
2011_09_03 13:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 30 30
2011_09_03 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 4749 4749
2011_09_03 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
TO_CHAR(BEGIN_IN
----------------
DBMS_LOB.SUBSTR(SQL_TEXT,4000,1)
--------------------------------------------------------------------------------
INSTANCE_NUMBER SQL_ID EXECUTIONS_DELTA ROWS_PROCESSED_DELTA
--------------- ------------- ---------------- --------------------
2 45bv71pwwj176 4749 4749
2011_09_03 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 4749 4749
2011_09_03 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 4749 4749
2011_09_03 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 4749 4749
2011_09_03 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 4749 4749
2011_09_03 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_03 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_03 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_03 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_03 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_03 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_03 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_03 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_03 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_04 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 7104 7104
2011_09_04 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 7104 7104
2011_09_04 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 7104 7104
2011_09_04 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 7104 7104
2011_09_04 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 7104 7104
2011_09_04 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 7104 7104
2011_09_04 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10249 10249
2011_09_04 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10249 10249
2011_09_04 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10249 10249
2011_09_04 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10249 10249
2011_09_04 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10249 10249
2011_09_04 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10249 10249
2011_09_04 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4325 4325
2011_09_04 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4325 4325
2011_09_04 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4325 4325
2011_09_04 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4325 4325
2011_09_04 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4325 4325
2011_09_04 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4325 4325
2011_09_04 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10357 10357
2011_09_04 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10357 10357
2011_09_04 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10357 10357
2011_09_04 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10357 10357
2011_09_04 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10357 10357
2011_09_04 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10357 10357
2011_09_04 22:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_04 22:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_04 22:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_04 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 0 0
2011_09_04 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 0 0
2011_09_04 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 0 0
2011_09_04 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_04 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_04 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_04 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_04 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_04 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_05 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 4100 4100
2011_09_05 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 4100 4100
2011_09_05 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 4100 4100
2011_09_05 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 4100 4100
2011_09_05 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 4100 4100
2011_09_05 00:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 4100 4100
2011_09_05 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9319 9319
2011_09_05 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9319 9319
2011_09_05 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9319 9319
2011_09_05 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9319 9319
2011_09_05 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9319 9319
2011_09_05 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 9319 9319
2011_09_05 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10237 10237
2011_09_05 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10237 10237
2011_09_05 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10237 10237
2011_09_05 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10237 10237
2011_09_05 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10237 10237
2011_09_05 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 10237 10237
2011_09_05 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 8406 8406
2011_09_05 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 8406 8406
2011_09_05 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 8406 8406
2011_09_05 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 8406 8406
2011_09_05 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 8406 8406
2011_09_05 02:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 8406 8406
2011_09_05 22:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_05 22:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_05 22:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 1 0
2011_09_05 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_05 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_05 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_05 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_05 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_05 22:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 1 0
2011_09_06 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13564 13564
2011_09_06 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13564 13564
2011_09_06 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13564 13564
2011_09_06 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13564 13564
2011_09_06 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13564 13564
2011_09_06 02:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 13564 13564
2011_09_06 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4609 4609
2011_09_06 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4609 4609
2011_09_06 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4609 4609
2011_09_06 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
TO_CHAR(BEGIN_IN
----------------
DBMS_LOB.SUBSTR(SQL_TEXT,4000,1)
--------------------------------------------------------------------------------
INSTANCE_NUMBER SQL_ID EXECUTIONS_DELTA ROWS_PROCESSED_DELTA
--------------- ------------- ---------------- --------------------
1 45bv71pwwj176 4609 4609
2011_09_06 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4609 4609
2011_09_06 00:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 4609 4609
2011_09_06 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 3185 3185
2011_09_06 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 3185 3185
2011_09_06 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 3185 3185
2011_09_06 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 3185 3185
2011_09_06 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 3185 3185
2011_09_06 03:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 3185 3185
2011_09_06 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10783 10783
2011_09_06 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10783 10783
2011_09_06 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10783 10783
2011_09_06 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10783 10783
2011_09_06 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10783 10783
2011_09_06 01:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
1 45bv71pwwj176 10783 10783
2011_09_05 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 0 0
2011_09_05 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 0 0
2011_09_05 21:30
delete from sys.wri$_optstat_tab_history whe
re nvl(:1, savtime) <= savtime and savtime < nvl(:2, savtime+1) and
obj# = nvl(:3, obj#)
1 c64x40vthcrh3 0 0
2011_09_05 23:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3 3
2011_09_05 23:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3 3
2011_09_05 23:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3 3
2011_09_05 23:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3 3
2011_09_05 23:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3 3
2011_09_05 23:30
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 3 3
2011_09_06 11:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 22 22
2011_09_06 11:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 22 22
2011_09_06 11:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 22 22
2011_09_06 11:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 22 22
2011_09_06 11:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 22 22
2011_09_06 11:29
insert into sys.wri$_optstat_tab_history(obj#,rowcnt,blkcnt,avgrln, analyzetime,
samplesize,cachedblk,cachehit,logicalread,savtime,flags) values (:1,:2,:3,:4,:5
,:6,:7,:8,:9,:10,:11)
2 45bv71pwwj176 22 22
342 rows selected.
6) SQL ID Responsible for High Archives
SQL> SELECT distinct dhss.sql_id
2 FROM dba_hist_sqlstat dhss,
dba_hist_snapshot dhs,
3 4 dba_hist_sqltext dhst
5 WHERE upper(dhst.sql_text) LIKE '%WRI$_OPTSTAT_TAB_HISTORY%'
6 AND dhss.snap_id=dhs.snap_id
AND dhss.instance_Number=dhs.instance_number
7 8 AND dhss.sql_id = dhst.sql_id
9 /
SQL_ID
-------------
c64x40vthcrh3
45bv71pwwj176
7) PROGRAM Responsible for High Archives
INSTANCE_NUMBER USER_ID PROGRAM
--------------- ----------- -------------------------------
1 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 44 GLPPOS@ifebapp1 (TNS V1-V3
SELECT instance_number, to_char(sample_time,'yyyy_mm_dd hh24:mi:ss'),
user_id,
program
FROM dba_hist_active_sess_history
WHERE sql_id = '45bv71pwwj176'
INSTANCE_NUMBER TO_CHAR(SAMPLE_TIME USER_ID PROGRAM
--------------- ------------------- ---------- -------------------------------
1 2010_11_23 15:59:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2010_11_23 15:57:45 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2010_12_03 12:31:01 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2010_12_08 12:50:53 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2010_12_08 12:50:53 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2010_12_14 17:34:33 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2010_12_21 08:59:51 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2010_12_22 18:04:03 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2010_12_18 14:22:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_05 13:55:00 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_04 16:04:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2010_12_26 13:08:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2010_12_26 13:07:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2010_12_24 16:07:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_03 17:12:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_03 16:52:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_03 17:28:35 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_22 00:00:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_07 00:01:11 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_14 00:01:03 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_12 00:01:14 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_16 16:19:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_16 16:19:10 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_16 18:30:03 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_12 09:02:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_07 13:49:35 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_10 14:57:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_15 15:23:50 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_23 12:57:12 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_23 12:57:02 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_23 12:56:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_23 12:56:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_23 12:56:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_23 12:56:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_20 13:41:51 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_21 15:48:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_21 15:48:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_23 15:33:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_18 14:52:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_19 13:11:43 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_21 15:39:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_26 18:01:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_29 14:09:41 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_24 14:18:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_24 15:29:15 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_25 15:33:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_25 17:32:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_27 13:24:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_27 13:23:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_27 13:21:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_27 13:07:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_27 13:07:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_27 13:07:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_28 17:13:23 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_28 17:13:13 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_28 17:13:03 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_28 16:42:02 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_01_30 14:53:14 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_02 00:01:31 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_01_30 14:54:24 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_09 00:01:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_09 00:01:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_02_03 12:31:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:54:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:54:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:54:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:54:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:54:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:48:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:48:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:48:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:48:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:47:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:47:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:42:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:42:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:42:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:41:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:41:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:41:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:41:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:41:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:41:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:40:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:40:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:40:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:40:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:40:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:40:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:39:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:39:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:39:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 12:39:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_07 15:06:15 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_09 14:11:44 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_09 14:11:34 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_10 18:08:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_11 13:38:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_11 13:37:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_14 12:13:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_14 13:30:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_15 13:09:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_15 13:09:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_18 00:01:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_18 00:01:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_16 16:47:13 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_18 15:55:13 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_23 00:02:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_23 00:02:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_25 00:02:44 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_25 00:02:34 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_26 00:01:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_26 00:01:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_02_28 17:30:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_02_28 17:30:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_02_28 17:30:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_24 12:31:34 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_24 12:31:24 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_05 16:10:05 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_06 14:12:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_28 13:19:10 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_28 13:19:00 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_28 13:18:50 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_28 13:18:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_28 13:18:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_28 13:18:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_28 13:18:10 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_28 15:36:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_28 15:31:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_02_28 15:31:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_01 17:07:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_01 17:07:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_01 17:07:12 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_03 12:31:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_04 00:01:12 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_04 12:43:15 44 @ifebapp1 (TNS V1-V3)
1 2011_03_04 12:43:05 44 @ifebapp1 (TNS V1-V3)
1 2011_03_04 12:42:55 44 @ifebapp1 (TNS V1-V3)
1 2011_03_04 12:42:45 44 @ifebapp1 (TNS V1-V3)
1 2011_03_04 12:42:35 44 @ifebapp1 (TNS V1-V3)
1 2011_03_04 12:42:25 44 @ifebapp1 (TNS V1-V3)
1 2011_03_04 15:11:11 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_06 12:47:01 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_06 12:46:51 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_11 00:02:11 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_11 00:02:01 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_07 17:00:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_07 17:00:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_08 15:10:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_08 15:10:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_10 12:31:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_10 12:31:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_11 14:10:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_11 14:10:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_19 00:00:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_15 00:01:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_16 00:01:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_16 00:01:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_15 12:31:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_18 00:01:13 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_31 18:37:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 00:01:33 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 00:01:23 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 00:01:13 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_23 13:25:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_23 13:46:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_23 13:46:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_23 13:45:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_24 16:10:13 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_02 13:15:53 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_02 13:17:03 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_02 13:16:53 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_02 13:16:43 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_02 13:16:33 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_02 13:16:23 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_02 13:16:13 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_02 13:16:03 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:10:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:10:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:08:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:08:10 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:08:00 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:07:50 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:07:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:07:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:07:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:07:10 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:07:00 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_30 13:06:50 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:12:55 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:12:45 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:12:35 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:12:25 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:12:15 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:12:05 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:11:55 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:11:45 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:11:35 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:11:25 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:11:15 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:11:05 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:10:55 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:10:45 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:10:35 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:08:05 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:07:55 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 13:07:45 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 14:23:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_30 14:22:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_03_31 14:18:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_31 14:18:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_31 14:18:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_03_31 14:17:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_01 13:30:54 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_01 13:30:44 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_01 13:30:34 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:14:02 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:13:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:13:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:13:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:13:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:13:12 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:13:02 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:12:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:12:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:12:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:12:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:12:12 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:12:02 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:11:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:11:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:11:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 13:11:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 14:36:25 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_03 14:36:15 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_03 17:33:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_03 17:33:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_05 00:01:34 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_05 16:31:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_07 00:01:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_07 00:01:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_07 00:01:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_08 00:01:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_08 00:01:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_09 00:01:35 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_09 00:01:25 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_09 22:47:00 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_09 22:46:50 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_09 22:46:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_09 22:46:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_09 22:45:50 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_09 22:45:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_09 22:45:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_09 22:45:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_09 22:45:10 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_10 00:52:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_10 00:52:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_10 13:48:03 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_14 00:01:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_14 00:01:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_21 16:54:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_11 15:19:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_15 16:48:24 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_19 00:01:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_23 12:30:55 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_26 00:02:05 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_26 00:01:55 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_26 00:01:45 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_25 17:46:30 44 @ifebapp1 (TNS V1-V3)
1 2011_04_25 12:27:25 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_25 12:27:15 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_25 12:27:05 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_25 12:26:55 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_04_25 12:30:55 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_26 00:01:51 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_28 00:01:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_28 00:01:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_29 00:02:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_29 00:01:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_29 00:01:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_29 00:01:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_06 15:49:24 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_06 15:49:14 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_06 15:49:04 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_06 15:48:54 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_05 15:11:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_05 15:10:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_05 15:10:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_05 15:10:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_30 00:02:14 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_30 00:02:04 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_30 00:01:54 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_04_30 00:01:44 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_02 12:31:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_02 12:31:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_02 12:31:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_03 14:08:21 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_03 14:08:11 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_03 14:08:01 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_03 14:07:51 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_04 13:33:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_04 13:33:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_04 13:33:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_04 13:33:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_04 17:13:50 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_04 17:13:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_18 00:01:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_18 00:01:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_14 00:02:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_08 12:50:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_08 12:50:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_08 12:50:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_08 12:50:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_08 12:50:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_08 12:49:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_12 13:55:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_12 15:07:15 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_12 15:07:05 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_12 15:06:55 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_12 15:06:45 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_16 16:48:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_16 16:48:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_16 16:48:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_16 16:47:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_19 00:01:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_19 00:01:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_05_19 00:01:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_04 00:01:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_27 00:02:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_27 00:02:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_27 00:01:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_27 00:01:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_27 00:01:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_09 00:01:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_09 00:01:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_23 16:05:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_25 09:34:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_31 14:36:01 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_31 14:35:51 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_05_31 14:35:41 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_14 16:33:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_14 16:33:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_14 16:33:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_14 16:33:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_14 16:33:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_14 16:33:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_06_16 14:21:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_23 00:02:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_23 00:02:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_23 00:01:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_23 00:01:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_22 08:58:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_22 08:58:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_22 08:58:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_22 08:58:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_06_24 14:06:34 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_28 00:01:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_27 15:12:35 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_06_27 15:12:25 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_05 14:40:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_05 14:40:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_05 14:40:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_05 14:40:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_05 14:40:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_05 14:40:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_05 14:39:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_12 13:13:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_13 15:46:23 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_14 00:01:44 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:53:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:53:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:53:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:53:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:52:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:52:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:52:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:52:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:46:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:46:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:46:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:45:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:45:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:44:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:44:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:44:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:44:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:44:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:44:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:44:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:44:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:44:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:44:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:44:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:43:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:42:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:41:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:40:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:39:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:38:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:38:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:38:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:38:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:38:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_15 12:38:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_19 13:15:23 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_20 13:34:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_21 00:01:25 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_31 14:00:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_31 14:00:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_31 14:00:12 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_31 14:00:12 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_31 10:50:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_31 10:49:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_31 10:49:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_26 10:04:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_26 10:04:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_27 13:07:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_27 13:07:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_27 13:07:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_27 13:07:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_27 13:07:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_27 13:07:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_27 13:06:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_27 13:06:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_27 13:06:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_27 13:06:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_27 16:54:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_27 16:54:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_27 16:54:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_27 16:54:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_29 13:54:51 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_29 13:54:51 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_29 13:54:41 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_29 13:54:41 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_29 14:45:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_07_29 14:45:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_30 13:29:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_30 13:29:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_07_30 13:29:10 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_01 18:58:55 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_01 13:37:41 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_01 13:37:31 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_01 13:37:21 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_01 13:37:11 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_02 13:11:12 44 @ifebapp2 (TNS V1-V3)
2 2011_08_02 13:11:02 44 @ifebapp2 (TNS V1-V3)
2 2011_08_02 13:10:52 44 @ifebapp2 (TNS V1-V3)
2 2011_08_02 13:10:32 44 @ifebapp2 (TNS V1-V3)
2 2011_08_02 13:10:22 44 @ifebapp2 (TNS V1-V3)
2 2011_08_02 13:44:24 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_02 14:50:11 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_02 14:50:01 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:15:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:15:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:15:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:15:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:15:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:15:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:15:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:14:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:14:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:14:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:14:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_03 13:14:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_03 16:35:23 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:18:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:18:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:17:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:17:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:17:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:17:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:17:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:05:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:05:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:05:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:05:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:05:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:04:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:04:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:04:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:04:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:04:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:04:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:03:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:03:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:02:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:02:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:02:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:02:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:02:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:01:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:01:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:01:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:01:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:01:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:01:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:01:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:01:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:01:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:01:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:01:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 13:00:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:59:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:58:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:58:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:58:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:58:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_04 12:58:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_04 13:33:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:23:43 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:23:33 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:23:23 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:23:13 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:23:03 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:02:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:02:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:02:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:02:12 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:02:02 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:01:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:01:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:01:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:01:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:01:12 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:01:12 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:01:02 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:01:02 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:00:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:00:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:00:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:00:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:00:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:00:32 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:00:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_05 13:00:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_05 14:07:31 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_05 14:07:21 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_05 15:39:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:27:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:27:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:27:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:26:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:08:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:08:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:08:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:07:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:07:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:07:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:07:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:07:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:07:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:06:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:06:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:06:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:06:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:06:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:06:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:06:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:05:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:05:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:05:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:05:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:05:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:05:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:05:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:05:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:05:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:05:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:04:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:04:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:04:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:04:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:04:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:04:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:03:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:03:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:03:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:03:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:03:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:03:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:02:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:02:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:02:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:02:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:02:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:02:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:02:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:02:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:01:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:01:47 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:01:37 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:01:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:01:27 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:01:17 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:01:07 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:00:57 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:00:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:00:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_06 13:00:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:07:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:07:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:07:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:07:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:07:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:06:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:06:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:06:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:06:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:06:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:06:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:05:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:05:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:05:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:05:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:05:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:05:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 15:12:23 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 15:12:13 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 15:12:03 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:04:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:04:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:04:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:04:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:04:18 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:04:08 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:03:58 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_07 13:03:48 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_08 11:00:34 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_08 12:53:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:36:21 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:36:11 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:36:01 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:35:51 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:35:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:35:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:35:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:35:10 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:35:00 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:34:50 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:34:40 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:34:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:34:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_09 12:34:10 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_09 16:07:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_13 15:40:53 44 @ifebapp1 (TNS V1-V3)
2 2011_08_11 00:02:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_11 00:02:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_11 00:01:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_12 00:02:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_12 00:02:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_12 00:02:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_13 00:01:14 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_13 00:01:04 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_13 00:00:54 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_17 14:04:54 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_17 14:04:44 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_17 14:04:34 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_17 14:04:24 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_17 14:04:14 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_18 10:04:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_18 11:07:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_18 11:07:39 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_18 11:07:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_19 12:56:56 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_19 12:56:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_19 14:53:02 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_20 14:09:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_20 14:09:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_20 14:09:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_20 14:08:59 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_20 14:08:49 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_23 11:38:38 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_23 11:38:28 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_24 12:55:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_24 12:55:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_24 12:55:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_25 15:46:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_25 15:46:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_25 15:46:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_25 15:46:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_25 18:07:24 0 sqlplus@IFEBPRD1 (TNS V1-V3)
1 2011_08_26 12:59:55 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_26 12:59:45 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_26 12:59:35 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_29 12:58:30 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_29 12:58:20 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_29 14:50:46 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_29 14:50:36 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_29 14:50:26 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_29 14:50:16 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_08_29 14:50:06 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_29 14:50:22 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_29 14:50:12 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_29 14:50:02 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_29 14:49:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_29 14:49:42 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_29 14:45:31 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_29 14:45:21 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_29 14:45:11 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_30 14:40:25 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_31 17:06:33 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_31 17:06:23 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_31 17:06:13 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_31 17:34:24 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_31 17:34:24 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_31 17:34:14 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_31 17:34:04 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_08_31 17:33:54 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_09_01 08:15:52 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_09_03 10:44:51 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_09_03 10:44:51 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_09_03 10:44:41 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_09_03 10:44:41 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_09_03 10:44:31 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_09_03 10:44:31 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_09_03 14:04:11 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_09_03 13:53:21 44 GLPPOS@ifebapp1 (TNS V1-V3)
1 2011_09_03 13:53:10 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_09_06 12:04:29 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_09_06 12:04:19 44 GLPPOS@ifebapp1 (TNS V1-V3)
2 2011_09_06 12:04:09 44 GLPPOS@ifebapp1 (TNS V1-V3)
798 rows selected.
No comments:
Post a Comment