To get information about the database

Following queries can be used to get information about the database

SET LINESIZE 150

SET PAGESIZE 50000

cOL HOST_NAME FOR A25

col LOGINS FOR A20

col STATUS for A15

col
“STARTUP_TIME” FOR A30

col INSTANCE_NAME for
a20

col VERSION for a20

select
INSTANCE_NAME,HOST_NAME,VERSION,LOGINS,STATUS,to_char(STARTUP_TIME,’DD-MON-YYYY
DAY HH24:MI:SS’)

“STARTUP_TIME”
FROM v$instance;

col name for a30

col
“CREATED” for a25

col LOG_MODE for a15

col OPEN_MODE for a15

col DATABASE_ROLE for
a15

select
NAME,to_char(CREATED,’DD-MON-YYYY HH24:MI:SS’)
“CREATED”,LOG_MODE,OPEN_MODE,DATABASE_ROLE from v$database;