Temp tablespace used/free in 11g/Force Online Redo Log Clear

SQL> select * from dba_temp_free_space;

TABLESPACE_NAME                TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE
------------------------------ --------------- --------------- ----------
TEMP1                               2122317824      2122317824 2107637760
TEMP2                               1887436800      1887436800 1869611008


select TABLESPACE_NAME,TABLESPACE_SIZE/1024/1024 SizeMB,(TABLESPACE_SIZE-FREE_SPACE)/1024/1024 UsedMB,FREE_SPACE/1024/1024 FreeMB,Round((FREE_SPACE)*100/TABLESPACE_SIZE) "% Free",Round((TABLESPACE_SIZE-FREE_SPACE)*100/TABLESPACE_SIZE) "% Used" from dba_temp_free_space;



SQL> set linesize 200
SQL> select TABLESPACE_NAME,TABLESPACE_SIZE/1024/1024 SizeMB,(TABLESPACE_SIZE-FREE_SPACE)/1024/1024 UsedMB,FREE_SPACE/1024/1024 FreeMB,Round((FREE_SPACE)*100/TABLESPACE_SIZE) "% Free",Round((TABLESPACE_SIZE-FREE_SPACE)*100/TABLESPACE_SIZE) "% Used" from dba_temp_free_space;

TABLESPACE_NAME                    SIZEMB     USEDMB     FREEMB     % Free     % Used
------------------------------ ---------- ---------- ---------- ---------- ----------
TEMP1                                2024         16       2008         99          1
TEMP2                                1800         17       1783         99          1

Force Online Redo Log Clear:

Now we will run an additional clause so as to force the CLEAR on our Online Redo Log. This will clear our online redo log but the corrupted log will not be recovered.

SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 4 UNRECOVERABLE DATAFILE;
Database altered.