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 an Oracle Data Dictionary?

How will you create multiple rollback segments in a database ?

What is an Oracle SYSTEM tablespace and when is it Created?

What are Oracle Schema Objects?

What is the function of Redo Log in Oracle?

Can a View based on another View in Oracle?

What is SGA?

What is the OPTIMAL parameter ?

How to define Data Block size in Oracle?

How to implement the multiple control files for an existing database ?

What is the significance of having storage clause ?

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

For more Oracle Architecture Interview Questions Click Here