Finding most recent nologging operation that occurred in the database....

Going thru my old notes and found this to blog :)

Here is the sql to find most recent "nologging" operation occurred tablespace:

select name, unrecoverable_change#,                

       to_char (unrecoverable_time,'DD-MON-YYYY HH:MI:SS') 

  from v$datafile;