8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: db_info.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/monitoring/db_info.sql -- Author : Tim Hall -- Description : Displays general information about the database. -- Requirements : Access to the v$ views. -- Call Syntax : @db_info -- Last Modified: 15/07/2000 -- ----------------------------------------------------------------------------------- SET PAGESIZE 1000 SET LINESIZE 100 SET FEEDBACK OFF SELECT * FROM v$database; SELECT * FROM v$instance; SELECT * FROM v$version; SELECT a.name, a.value FROM v$sga a; SELECT Substr(c.name,1,60) "Controlfile", NVL(c.status,'UNKNOWN') "Status" FROM v$controlfile c ORDER BY 1; SELECT Substr(d.name,1,60) "Datafile", NVL(d.status,'UNKNOWN') "Status", d.enabled "Enabled", LPad(To_Char(Round(d.bytes/1024000,2),'9999990.00'),10,' ') "Size (M)" FROM v$datafile d ORDER BY 1; SELECT l.group# "Group", Substr(l.member,1,60) "Logfile", NVL(l.status,'UNKNOWN') "Status" FROM v$logfile l ORDER BY 1,2; PROMPT SET PAGESIZE 14 SET FEEDBACK ON