Find physical locations of all Database files

show parameter spfile;
select name from v$controlfile;
select name from v$datafile;
select name from v$tempfile;
select member from v$logfile;
archive log list;

Was this article helpful?

Related Articles

Leave a Comment