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 Data Segment?
What is Server Process?
Can a View based on another View in Oracle?
1.Explain the three levels with the help og a diagram.
How will you create multiple rollback segments in a database ?
What is the function of Lock (LCKn) Process?
What are Oracle Schema Objects?
What is a Parallel Server option in ORACLE?
What is the function of Redo Log in Oracle?
How the space utilisation takes place within rollback segments?
What is meant by free extent ?
What is Shared Pool?