SQL statement used for Oracle management query _ MySQL

SQL statements for Oracle management and query

Tablespace and capacity:

Select tablespace_name, sum (bytes)/1024/1024/1024 from dba_data_files group by tablespace_name;

Free space of the tablespace:

Select tablespace_name, sum (bytes) from dba_free_space group by tablespace_name;

System tablespace:

Select tablespace_name from dba_tablespaces;

System data file:

Select file_name from dba_data_files;

System Control file:

Select value from v $ parameter where name = 'control _ files ';

System redo log files:

Select member from v $ logfile;

Archive log files:

Select value from v $ parameter where name = 'Log _ archive_dest'