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 an Oracle SYSTEM tablespace and when is it Created?
What is the function of checkpoint(CKPT)?
What is the function of Lock (LCKn) Process?
What is meant by Redo Log file mirrorring ? How it can be achieved?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
What is Database Buffers ?
What are the two types of Server Configurations?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
List the Optional Flexible Architecture (OFA) of Oracle database ?
What is a Parallel Server option in ORACLE?
What is hit ratio ?
When will be a segment released?