1. Redo Log Usage col MEMBER format a40 SELECT l.group#, l.bytes/(1024*1024) AS "MEGA", l.status, f.member FROM v$log l, v$logfile f WHERE l.group# = f.group#; 2. DATA Tablespace Usage SELECT A.TABLESPACE_NAME AS "TABLESPACE" , A.BYTES / 1024 / 1024 AS "TOTAL(MB)" , (A.BYTES - NVL(B.FREEBYTES,0)) / 1024 / 1024 AS "Used(MB)" , NVL(B.FREEBYTES,0) / 1024 / 1024 AS "Free(MB)" , ROUND(NVL(B.FREEBYTES..