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

How will you force database to use particular rollback segment?

What is Shared SQL Area?

How will you swap objects into a different table space for an existing database?

What is an Oracle Rollback Segment?

When Does DBWR write to the database?

What is the significance of having storage clause ?

What is a Multi-threaded Server Configuration?

What do Redo Log Buffers contain?

How does Space allocation table place within a block ?

1.Explain the three levels with the help og a diagram.

Why query fails sometimes ?

How will you monitor rollback segment status ?

For more Oracle Architecture Interview Questions Click Here