Dear Readers, In this article, we will see the following Oracle : Redolog Files. Redo log Files are Recovery options whenever Database crashes or Down. LGWR will take care of redo content that needs to be written to redolog files, Based on SCN a record… Read More
Dear Readers, In this article, we will see the following Internal mechanism of Buffer Cache. Buffer cache management : 👉 Locating free blocks (Data to write) 👉 Finding data blocks (Data to read) 👉 Managing LRU lists (Flushing least recently used blocks) 👉 Cleaning dirty… Read More
Dear Readers, In this article, we will see the following Log Miner Configuration for Oracle Database. We can easily track history of activity on a database from archived redolog files using log miner. 1. ENABLE SUPPLEMENTAL LOGGING FOR THE DATABASE
|
1 |
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; |
|
1 2 3 4 |
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE; SUPPLEME -------- YES |
2. CHECK THE… Read More
