zach14c

Archive timemap

Dec 3rd, 2018
291
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.18 KB | None | 0 0
  1. SELECT name,completion_time,BLOCKS * BLOCK_SIZE/1024/1024 MB
  2.  FROM  v$archived_log
  3.   WHERE completion_time BETWEEN TRUNC(SYSDATE) - 2 AND
  4.         TRUNC(SYSDATE) - 1 AND ROWNUM < 51 ;
Advertisement