Redo log files: v$log, v$logfile, v$log_history
Datafiles: dba_data_files, v$datafile
Users: dba_users
-
There are many DPT and DDV. You can find details on them if you refer to the Reference Manual in the Client docs.