shortly,
1. write the modified data to the archive redo log file and 2. update control file to indicate the most recent checkpoint
in detail
1. The data set for the update is taken from the DB CACHE.
2. The ‘Pre Change’ data is written to the UNDO CACHE.
3. The ‘Post Update’ data is rewritten to the REDO CACHE as a delta (a piece of data that contains enough information to reconstruct the original data). The ‘Post Update’ data from the UNDO CACHE is also written to the REDO CACHE (alternatively known as the REDO LOG BUFFER).
4. After a COMMIT is issued the LOG WRITER Process (LGWR) writes the REDO CACHE to the REDO LOG FILES.
5. If ARCHIVELOG is enabled then the ARCHIVER Process (ARCH) writes a copy of the REDO LOG FILES to an alternative destination(s) (Up to 10) before the REDO LOGS are reused.
6. The CHECKPOINT Process (CKPT) is called regularly and this ensures that changed data (dirty blocks) are written from the DB CACHE and back to the datafiles. In addition this process updates the CONTROL FILES.
Popular Posts
-
How to create Matrix report / Pivot Report using Oracle BI Publisher Step by step instruction: 1. Make data model using Oracle Reports Dev...
-
Installation Steps: 1. First create a folder named app_server in any directory 2. go to the software to install and double click install...
-
A lot of differences this is my take on them: 8i -> 9i - Real Application Clusters, PL/SQL enhancements, XMLType enhancem...
-
Oracle 10g New Features: Flashback and RMAN Flashback Database - This feature introduces the FLASHBACK DATABASE statement in SQL. I...
-
ORACLE BI PUBLISHER A. Please learn the steps of creating Matrix report from previous video B. Now we will discuss about Position, Sorting...
-
TO DECLARE/SET A VARIABLE VALUE: ------------------------------- <?xdoxslt:set_variable($_XDOCTX, 'variable name', value)?> ...
-
A. Download and install VirtualBox There are possibilities of different versions based on your Operating System. Here we worked with Virtu...
Labels
- (APEX) 5.0 (1)
- answer (1)
- Application Express (1)
- aprosoft (1)
- data type in MYSQL (1)
- data type MSSQL (1)
- datatype in ORACLE (1)
- datatype in POSTGRESQL (1)
- dynamic views (1)
- Eplislon (1)
- Exam (1)
- ferite (1)
- Installation (1)
- Interview (2)
- oracle (4)
- oracle erp (1)
- php (1)
- PL/SQL (1)
- plsql (1)
- Question (1)
- Questions (1)
- windows 8 (1)
Pages All
Powered by Blogger.
Members
PageRank#
this is a test
Search This Blog
এর দ্বারা পোস্ট করা
assad
Wednesday, October 20, 2010