What is the maximum number of Lock Processes used?

Question Posted / guest

What is the maximum number of Lock Processes used?..

Answer / guest

Though a single LCK process is sufficient for most Parallel
Server systems upto Ten Locks (LCK0,....LCK9) are used for
inter-instance locking

Is This Answer Correct ?

2 Yes

0 No

More Oracle Architecture Interview Questions

What is the maximum number of Lock Processes used?

What constitute an ORACLE Instance?

Why query fails sometimes ?

What is advantage of having disk shadowing/ Mirroring ?

What is an Oracle Data Block?

When will be a segment released?

What is the function of ARCH?

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

How will you force database to use particular rollback segment?

What is a Control file ?

What are functions of PMON?

Can a View based on another View in Oracle?

For more Oracle Architecture Interview Questions Click Here