Answer / manvendra

PMON IS RESPONSIBLE FOR RELEASEING THE RESOURCE OCCUPIED BY
THE USER WHEN THERE IS A ABNORMAL TERMINATION OF USER.

Answer / td1947

In additon to the above, when a transaction causes a
process to fail, PMON will initiate a ROLLBACK for that
transaction.

Answer / pravin pardeshi

pmon is used in releasing of locks and latches. Locks are
put on tables and latches are put on memory.

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.

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.

What is the function of Redo Log in Oracle?

0 Answers  

List the Optional Flexible Architecture (OFA) of Oracle database ?

1 Answers  

What is the OPTIMAL parameter ?

1 Answers   TCS,

Diference between Oracle 9i and 10G.

2 Answers   Baidu,

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?

0 Answers  

How will you estimate the space required by a non-clustered tables?

2 Answers  

What are functions of PMON?

5 Answers  

What are Oracle Schema Objects?

0 Answers  

What is the maximum size of a row in oracle 9i?

4 Answers   Baidu, HCL, Yashu Systems,

What is advantage of having disk shadowing/ Mirroring ?

1 Answers  

What is the role of PCTFREE parameter is Storage clause ?

2 Answers  

Teradata: How can we know the indexed column in a table?

0 Answers   CTS, HSBC,