Important Database commands

SQL>Show parameter spfile;

SQL>

SQL>create pfile from Spfile;

SQL>select name from v$controlfile;

SQL>select name from v$datafile;

SQL>select name from v$tempfile;

SQL>select name from v$logfile;

SQL>archive log list;

SQL>select name,open_mode from v$database;

SQL>show parameter spfile;

SQL> show parameter DB_RECOVERY_FILE_DEST;

Find table spaces in Database

SQL>select name from v$tablespace