location of redologfiles ,datafiles
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: location of redologfiles ,datafiles

  1. #1
    Join Date
    Jan 2001
    Posts
    60
    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
    html code is off

  2. #2
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    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\
    Thanks
    Kishore Kumar

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    <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]

  4. #4
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    look into --

    v$log
    v$logfile
    dba_data_files
    dba_users


    - Rajeev


  5. #5
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    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.

  6. #6
    Join Date
    Jan 2001
    Posts
    318
    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;
    Sonali

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width