1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| SQL> SELECT SEG.SNAP_ID, SNA.BEGIN_INTERVAL_TIME, SEG.SPACE_USED_TOTAL, SEG.SPACE_USED_DELTA, SEG.SPACE_ALLOCATED_TOTAL, SEG.SPACE_ALLOCATED_DELTA
FROM DBA_HIST_SEG_STAT SEG, DBA_HIST_SEG_STAT_OBJ OBJ, DBA_HIST_SNAPSHOT SNA
WHERE SEG.OBJ# = OBJ.OBJ# AND
SEG.SNAP_ID = SNA.SNAP_ID AND
OBJ.OBJECT_NAME = upper('VWQueue1_161') AND
OBJ.OWNER = 'GAD_ATF_ADMIN' AND
TO_DATE(TO_CHAR(SNA.BEGIN_INTERVAL_TIME, 'DD/MM/YYYY')) > '01/04/2018'
ORDER BY SNAP_ID;
2 3 4 5 6 7 8
SNAP_ID BEGIN_INTERVAL_TIME SPACE_USED_TOTAL SPACE_USED_DELTA SPACE_ALLOCATED_TOTAL SPACE_ALLOCATED_DELTA
---------- ------------------------------ ---------------- ---------------- --------------------- ---------------------
40313 02/04/18 07:00:24,387 -1889968 46449 0 0
40314 02/04/18 07:30:25,545 -1882759 7209 0 0
40316 02/04/18 08:30:27,766 -1880711 2048 0 0
40317 02/04/18 09:00:28,861 -1871454 9257 0 0
40318 02/04/18 09:30:30,019 -1865228 6226 0 0
40319 02/04/18 10:00:31,105 -1832214 33014 0 0
40320 02/04/18 10:30:32,275 -1809604 22610 0 0
40321 02/04/18 11:00:33,389 -1771347 38257 0 0
40322 02/04/18 11:30:34,526 -1759960 11387 0 0
40323 02/04/18 12:00:35,628 -1728093 31867 0 0
40324 02/04/18 12:30:36,760 -1704336 23757 0 0
40325 02/04/18 13:00:37,909 -1686805 17531 0 0
40326 02/04/18 13:30:39,157 -1666161 20644 0 0
40327 02/04/18 14:00:40,250 -1643469 22692 0 0 |
Partager