Oracle View user Action SQL statements and database logs

--View Log files

Select member from V$logfile;

--View Table space usage

SELECT SUM (bytes)/(1024x768 * 1024x768) as free_space, Tablespace_name
From Dba_free_space 
GROUP bytablespace_name; Selecta.tablespace_name, 
a.bytes total, 
b.bytes used, 
C.bytes Free, 
(b.bytes *)/a.bytes "% used", (c.bytes *)/a.bytes "% free"  
Fromsys.sm$ts_avail A, sys.sm$ts_used B, Sys.sm$ts_free c 
Wherea.tablespace_name = B.tablespace_name 
Anda.tablespace_name = C.tablespace_name; 
!--[If!supportlinebreaknewline]-->--view the rollback segment name and size!--[endif ]-->

select segment_name, 
Tablespace_name, 
R.status, 
(initial_extent/1024) initialextent, 
(next_extent/1024) nextextent, 
Max_extents, 
V.curext curextent 
FROMdba_ Rollback_segs R, V$rollstat v 
WHERE r.segment_id= V.usn (+)  
ORDER bysegment_name;

Oracle View User Action SQL statements and database logs