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 do Redo Log Buffers contain?

What is meant by free extent ?

How free extents are managed in Ver 6.0 and Ver 7.0 ?

what is ORACLE MEMORY STRUCTURES

What is Shared Pool?

How can we plan storage for very large tables ?

What is advantage of having disk shadowing/ Mirroring ?

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

What is meant by Redo Log file mirrorring ? How it can be achieved?

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

What is dictionary cache ?

When does LGWR write to the database?

For more Oracle Architecture Interview Questions Click Here