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

When Does DBWR write to the database?

What is advantage of having disk shadowing/ Mirroring ?

What is an Oracle Rollback Segment?

What is hit ratio ?

THE MAIN CONCEPT OF PROGRAMMIN TYPE?

How does Space allocation table place within a block ?

When will be a segment released?

What constitute an ORACLE Instance?

How will you create multiple rollback segments in a database ?

What is an Integrity Constrains in Oracle?

What are the components of SGA?

Can a Tablespace hold objects from different Schemes in Oracle?

For more Oracle Architecture Interview Questions Click Here