mfadmin – Page 2075

PMON,”It monitors all the other background processes. When a server or dispatcher process terminates abnormally, it performs process recover.Cleans up the database buffer cache and freeing resources that were allocated for client process. It releases the resources held by failed user process, rolls back the transaction that caused the process to fail, and releases the row and table level locks held by the failed user process. PMON rolls back the transaction that caused the process to fail

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.PMON,”It monitors all the other[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.SMON Is in charge of[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.DBWN writes modified buffers in[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.LGWR Manages the redo log[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.CKPT -updates the control file[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Physical storage Data filescontrol filesOnline[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Logical Storage data blocksextentssegmentstablespaces

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Extents,”-An extent is a specific[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Data blocks,”-At the finest level[…]

Average Rating 0 out of 5 stars. 0 votes.You must log in to submit a review.Segments,”-A set of extents allocated[…]