QUERY TO CHECK DATA FILES LOCATION:
-----------------------------------
select name from v$datafile;

QUERY TO CHECK CONTROLFILE LOCATION:
------------------------------------
select name from v$controlfile;

QUERY TO CHECK LOGFILE LOCATION:
--------------------------------
select member from v$logfile;

QUERY TO CHECK ARCHIVELOG LOCATION:
-----------------------------------
SELECT THREAD#,SEQUENCE#,NAME FROM V$ARCHIVED_LOG;

QUERY TO CHECK TABLESPACES IN DATABASE:
---------------------------------------
select tablespace_name, status from dba_tablespaces;