Hi
I am new to dba ,i am learning it

I want to know using DPT & DDV TO FIND

location of -- redo logfiles and data files

status of logfiles ,data files

names of users currently in data base using ddv

which are all the tables we geneally use to find this type of files and some important tables in regular usage and what for .

Thanks
lnreddy