English Русский Contacts Site map Add to favorites
Registration
Login
Master braindump list
New braindumps
Submit a dump
Get latest dump
braindumps.com.ua
flame
3COM (7)
Adobe (1)
BEA (1)
Checkpoint (22)
Cisco (20)
Citrix (21)
CIW (15)
Compaq (0)
CompTIA (51)
CWNA (2)
EMC (2)
Exin (4)
GEJOS (4)
HDI (1)
HP (4)
IBM (13)
Juniper (5)
Linux Prof Institute (LPI) (2)
Lotus (11)
Microsoft (2462)
Network Appliance (2)
Novell (16)
Oracle (422)
PLSQL (1)
PMI (4)
SAS (1)
Sun (87)
Teradata (4)
Login:
Password:
RSS feed

Contacts
Certification links
Links
Authorized users can post comments.
Please log in or sign up.

back to list
Back to main forum
Oracle 9i: Database Fundamentals II 

АвторSubject: Q181
written 12 January 2008 13:03   View profile Jonnik  Edit/Delete  Answer  Answer with quotation
Explanation:
PMON background process cleans up the failed connections. The process monitor 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. Incorrect Answer:
1: The archive copies the online redo log files to archival storage after a log switch has occurred.
2: At specific times, all modified database buffers in the SGA are written to the data files by DBWn. This event is called a checkpoint. The checkpoint process is responsible for signaling DBWn at checkpoints and updating all the data files and control files of the database to indicate the most recent checkpoint.
3: The database writer writes modified blocks from the database buffer cache to the data files.
4: The log writer writes redo log entries to disk. Redo log entries are generated in the redo log buffer of the SGA, and LGWR writes the redo log entries sequentially into an online redo log. If the database has a multiplexed redo log, then LGWR writes the redo log entries to a group of online redo log files.
6: The system monitor performs recovery when a failed instance starts up again. With Real Application Clusters, the SMON process of one instance can perform instance recovery for other instances that have failed. SMON also cleans up temporary segments that are no longer in use and recovers terminated transactions skipped during recovery because of file-read or offline errors. These transactions are eventually recovered by SMON when the table space or file is brought back online. SMON also coalesces free extents in the dictionary managed table spaces to make free space contiguous and easier to allocate.
Reference:
OCP Oracle 9i Database: Fundamentals II Exam Guide, Rama Velpuri, p. 174-175
Chapter 7: Instance and Media Recovery Structures

Current tread:
back to list

Q181 - Go to question 13:03 12.01.08

back to list
Up ^ gen. 0.072 Server date 06:53 08-01-2009 Developed by Zip © 2006 Up ^
Forum
Start online exam simulation
Master braindump
User braindumps
Main forum
Question comments