|
|
|
Database File Information
| select |
'Archived Log Directory', value |
| from |
sys.v_$parameter |
| where |
name = 'log_archive_dest' |
| UNION |
|
| select |
'Control Files', value |
| from |
sys.v_$parameter |
| where |
name = 'control_files' |
| UNION |
|
| select |
'Datafile', name |
| from |
sys.v_$datafile |
| UNION |
|
| select |
'LogFile Member', member |
| from |
sys.v_$logfile, |
| UNION |
|
| Select |
‘Tempfile’,file_name |
| From |
dba_temp_files; |
|
