SQL commands to check the tablespace,controlfiles,redologfiles,datafiles.

 SQL commands to check the tablespace,controlfiles,redologfiles,datafiles.



SQL> select *from v$tablespace;--to check the tablespace



SQL>select name from v$controlfile;-to check the controlfile

SQL>select member from v$logfile;-to check the redologfile

SQL>select name from v$datafile;-to check the datafile