SQL> SELECT FILE_NAME,AUTOEXTENSIBLE,MAXBYTES /1024/1024/1024 "SIZE IN GB" FROM DBA_DATA_FILES WHERE TABLESPACE_NAME IN (SYSTEM','SYSAUX','UNDOTBS1','TEMP','TEMP1');
FILE_NAME AUT SIZE IN GB
-------------------------------------------------------- ------------ --------------
/u01/app/oracle/oradata/PDT003/undotbs01.dbf YES 8
..
...
SQL> select to_char(begin_time, 'DD-MON-RR HH24:MI') begin_time,to_char(end_time, 'DD-MON-RR HH24:MI') end_time, tuned_undoretention from v$undostat order by end_time;
BEGIN_TIME END_TIME TUNED_UNDORETENTION
------------------------ ------------------------ -------------------
16-SEP-15 01:03 16-SEP-15 01:13 1879
16-SEP-15 01:13 16-SEP-15 01:23 2421
16-SEP-15 01:23 16-SEP-15 01:33 1262
16-SEP-15 01:33 16-SEP-15 01:43 1864
16-SEP-15 01:43 16-SEP-15 01:53 2426
16-SEP-15 01:53 16-SEP-15 02:03 1864
16-SEP-15 02:03 16-SEP-15 02:13 1829
16-SEP-15 02:13 16-SEP-15 02:23 2432
16-SEP-15 02:23 16-SEP-15 02:33 1261
16-SEP-15 02:33 16-SEP-15 02:43 1862
16-SEP-15 02:43 16-SEP-15 02:53 2438
..
..
16-SEP-15 12:03 16-SEP-15 12:13 1836
16-SEP-15 12:13 16-SEP-15 12:23 1736
16-SEP-15 12:23 16-SEP-15 12:33 1135
16-SEP-15 12:33 16-SEP-15 12:43 1842
16-SEP-15 12:43 16-SEP-15 12:53 1134
16-SEP-15 12:53 16-SEP-15 13:03 1735
16-SEP-15 13:03 16-SEP-15 13:13 1847
16-SEP-15 13:13 16-SEP-15 13:23 1736
16-SEP-15 13:23 16-SEP-15 13:33 1132
16-SEP-15 13:33 16-SEP-15 13:43 1852
16-SEP-15 13:43 16-SEP-15 13:53 1133
16-SEP-15 13:53 16-SEP-15 14:03 1735
16-SEP-15 14:03 16-SEP-15 14:13 1858
16-SEP-15 14:13 16-SEP-15 14:23 1733
16-SEP-15 14:23 16-SEP-15 14:25 1793