Computer Tutorials
Earn Money From Internet
Cheap Freelancers
Ask An Expert
Register Cheap Domain
Data Recovery
Best Mutual Funds
Trading Forex Online
Cheap Web Hosting
Ajax Tutorials
Cheap Cell Phone Plans
Free Mobile Learning
Job Portal
Photoshop Tutorials
Cheap Jewelry
Cheapest Air Travel
Oracle Interview Questions And Answers
|
Page 9 of 95
The Checkpoint (CKPT) process is responsible for signaling DBWR at checkpoints and updating all the data files and control files of the database. 82. What are the functions of SMON ? System Monitor (SMON) performs instance recovery at instance start- up. In a multiple instance system (one that uses the Parallel Server), SMON of one instance can also perform instance recovery for other instance that have failed SMON also cleans up temporary segments that are no longer in use and recovers dead transactions skipped during crash and instance recovery because of file-read or off-line errors. These transactions are eventually recovered by SMON when the tablespace or file is brought back on-line SMON also coalesces free extents within the database to make free space contiguous and easier to allocate. 83. What are functions of PMON ? Process Monitor (PMON) performs process recovery when a user process fails PMON is responsible for cleaning up the cache and Freeing resources that the process was using PMON also checks on dispatcher and server processes and restarts them if they have failed. 84. What is the function of ARCH ? Archiver (ARCH) copies the on-line redo log files to archival storage when they are full. ARCH is active only when a database's redo log is used in ARCHIVELOG mode. 85. What is function of RECO ? RECOver (RECO) is used to resolve distributed transactions that are pending due to a network or system failure in a distributed database. At timed intervals,the local RECO attempts to connect to remote databases and automatically complete the commit or rollback of the local portion of any pending distributed transactions. 86. What is the function of Dispatcher (Dnnn) ? Dispatcher (Dnnn) process is responsible for routing requests from connected user processes to available shared server processes and returning the responses back to the appropriate user processes. 87. How many Dispatcher Processes are created ? Atleast one Dispatcher process is created for every communication protocol in use. 88. What is the function of Lock (LCKn) Process ? Lock (LCKn) are used for inter-instance locking when the ORACLE Parallel Server option is used. 89. What is the maximum number of Lock Processes used ? Though a single LCK process is sufficient for most Parallel Server systems upto Ten Locks (LCK0,....LCK9) are used for inter-instance locking. |