Oracle Instance Bilgisi

Oracle veritabanı bilgisini almak için v$database tablosu sorgulanabilir.

Bu tablodan bulunabilecek bilgilerden bazlar aşağıdaki gibidir.

select *from v$database;
   Column                                   Veritipi                            Açıklama

OPEN_MODE

VARCHAR2(10)

Open mode information: MOUNTED READ WRITE READ ONLY

LOG_MODE

VARCHAR2(12)

Archive log mode: NOARCHIVELOG ARCHIVELOG MANUAL

CHECKPOINT_CHANGE#	NUMBER	Last SCN checkpointed
ARCHIVE_CHANGE#	NUMBER	Database force archiving SCN. Any redo log with a start SCN below this will be forced to archive out.
CONTROLFILE_TYPE	VARCHAR2(7)	Type of control file: STANDBY - Indicates that the database is in standby mode CLONE - Indicates a clone database BACKUP | CREATED - Indicates the database is being recovered using a backup or created control file CURRENT - database is available for general