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 |
List the Optional Flexible Architecture (OFA) of Oracle database ?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
What are the two types of Server Configurations?
Can a View based on another View in Oracle?
What is meant by free extent ?
• What is oracle Architecture?
List the factors that can affect the accuracy of the estimations ?
What is the function of Lock (LCKn) Process?
Teradata: How can we know the indexed column in a table?
What is meant by recursive hints ?
What is an Oracle Data Block?
How to define Data Block size in Oracle?