Thursday, 3 April 2014

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