Interested to Buy Any Domain ? << Click Here >> for more details...
What are functions of PMON?
- 5 Answers
- 14622 Views
- I also Faced
- E-Mail Answers
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 |
1.Explain the three levels with the help og a diagram.
What is the role of PCTFREE parameter is Storage clause ?
What is meant by redo log buffer ?
How the space utilisation takes place within rollback segments?
What is use of Rollback Segments In Database ?
How will you monitor rollback segment status ?
What is User Process?
What is meant by recursive hints ?
What is an Oracle Data Dictionary?
What is Shared SQL Area?
What do Redo Log Buffers contain?
What is meant by free extent ?
Oracle General 
