Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question regarding Iz0-031 (PMON or SMON?)

Status
Not open for further replies.

sasa888

Programmer
Oct 15, 2001
131
0
0
US
Hi all, I would appreciated it if anyone can tell me the right answer of this question:

A network error unexpectedly terminated a user's database session. Which 2 events occur in this scenario? (Pick 2)
~ Checkpoint occur
~ A fast commit occurs
~ RECO performs the session recovery
~ PMON rolls back the user's current transaction
~ SMON rolls back the user's current transaction
~ SMON frees the system resource reserved for the user session
~ PMON releases the table and rowlocks held by the user session

Please help. Thanks in advance.
 
i think
PMON rolls back the user's current transaction
PMON releases the table and rowlocks held by the user session

read this
The process monitor (PMON) performs process recovery when a user process fails.
PMON is responsible for cleaning up the database buffer cache and freeing
resources that the user process was using. For example, it resets the status of the
active transaction table, releases locks, and removes the process ID from the list of
active processes.
PMON periodically checks the status of dispatcher and server processes, and
restarts any that have stopped running (but not any that Oracle has terminated
intentionally). PMON also registers information about the instance and dispatcher
processes with the network listener.
Like SMON, PMON checks regularly to see whether it is needed and can be called if
another process detects the need for it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top