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 the log writer writes the data into database

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

What are the consideration at tehe migration of Oracle 9i to 10G.

How will you create multiple rollback segments in a database ?

What is the maximum size of a oracle9i database?

What do Redo Log Buffers contain?

What is Cursor?

What is the function of Lock (LCKn) Process?

When Does DBWR write to the database?

How the space utilisation takes place within rollback segments?

What is a Parallel Server option in ORACLE?

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

For more Oracle Architecture Interview Questions Click Here