location of redologfiles ,datafiles

[lnr]

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

[Kishore]

You can find out, by querying dba_data_files view from system user. It depends on which operating system you are using. And by default if you are using NT \orant\database\

[sreddy]

<font face=courier>
spool repallfiles.lst
select rtrim(name) from v$datafile
union
select rtrim(member) from v$logfile
union
select rtrim(name) from v$controlfile;
spool off
</font>

with the exception of parameter files which are in /O_H/dbs dir. As for as locations concerned. follow others posts for rest of details like dba_data_files, V$logfile etc.,

[Edited by sreddy on 01-25-2001 at 02:46 PM]

[rsuri]

look into --

v$log
v$logfile
dba_data_files
dba_users


- Rajeev

[Halo]

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.

[sonaliak]

select file_name,tablespace_name,bytes/1024/1024 Mb
from dba_data_files
union all
select member file_name,'log group '||a.group# tablespace_name
,b.bytes/1024/1024 Mb
from v$logfile a,v$log b
where a.group#=b.group#
union all
select name file_name,'control file' tablespace_name,0 Mb
from v$controlfile
order by 1,2;