What are functions of PMON?
Answers were Sorted based on User's Feedback
Answer / manvendra
PMON IS RESPONSIBLE FOR RELEASEING THE RESOURCE OCCUPIED BY
THE USER WHEN THERE IS A ABNORMAL TERMINATION OF USER.
| Is This Answer Correct ? | 14 Yes | 0 No |
Answer / td1947
In additon to the above, when a transaction causes a
process to fail, PMON will initiate a ROLLBACK for that
transaction.
| Is This Answer Correct ? | 10 Yes | 1 No |
Answer / pravin pardeshi
pmon is used in releasing of locks and latches. Locks are
put on tables and latches are put on memory.
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / khan
pmon stands for process monitor,when ever user process dies
by holding lock it use to release those locks, so other user
can use that particular table,and whenever user dies it
ensure that the database using the resource that they are
died ,and pmon process use to sleep and it activate for
regular interval of time,and it restart the failed server
process and dispatched process.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / ravi dutta
the process monitor(pmon) is used to monitor the
transactional flow in the sga and after the transaction is
over, it tells the next transaction to enter into the sga.
| Is This Answer Correct ? | 7 Yes | 8 No |
What is Dedicated Server Configuration?
What is meant by Redo Log file mirrorring ? How it can be achieved?
How will you monitor rollback segment status ?
What is Database Buffers ?
What is the functionality of SYSTEM table space ?
How will you monitor the space allocation ?
What is a Rollback segment entry ?
What is an Oracle Data Dictionary?
How to find the current session sid
What are the two types of Server Configurations?
What is use of Rollback Segments In Database ?
How does Space allocation table place within a block ?