which process write error/message in atert log file ? which process perform rollback ?

Each server and background process can write to an associated trace file. When an internal error is detected by a process, it dumps information about the error to its trace file. Some of the information written to a trace file is intended for the database administrator, while other information is for Oracle Worldwide Support. Trace … continue reading


which process writes previous image to undo tablespace?

server process..Sounds like a trick question. I do not think there is (or can be) such a process. Every server process has to write undo information by itself as it updates the database blocks in the buffer cache. This cannot be deferred to a background operation.  

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube