DBA Tables needs to know To know the database properties and parameters. Show parameter <Parameter name> Select * from v$parameters; – Parameres Select name from v$controlfile; – Control file Select * from v$logfile; – Members info Select * from v$log; – Log size Archive log list; – Archive details Sql> select * from v$sgastat – SGA size Sql> select * from v$pgastat; – PGA size sql> select * from v$tablespace; – Tablespace size sql> select * from dba_tablespaces; – Tablespace size sql> select * from v$datafile; – Datafile size sql> select * from dba_data_files; – Datafile size Rename data file Code Offline tablespace alter tablespace <ts name>…