When the data in a oracle database needs to be changed, it has to be done quickly. Accessing the data files on disk is slow and so, all changes in the Oracle database are carried out in the buffer cache and are only written to files at a later point by the DBWR. The buffer …
Oracle is a multi user system and as such, multiple processes need to access the database at the same time to perform both reads and writes. Each one needs to get a consistent view of the data – one that does not change during a tranaction. Oracle ensures that the data that a process gets …
In Oracle, the Undo records allow data that is being modified to be accessed. Oracle uses row level locking to prevent two processes from trying to update the same data at the same time. Only the rows being modified are locked. This means that the rest of the table can still be modified while a …
The Users server process is the process that handles the users requests to the oracle database. When the user requests a add, update or delete of data in the database, the server process modifies the data from the buffer cache, not the actual data files. The DBWR (Database Writer) process is the only process that …
Reading from the Oracle RDMS is done by the users server process Once a query is submitted, the users server process first determines if data is in the buffer cache of the SGA (System Global Area) memory area. If the data is not already in the buffer cache, Oracle reads the data from the data …