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 SGA?

What is the maximum size of a row in oracle 9i?

When does LGWR write to the database?

What is the OPTIMAL parameter ?

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

How many Dispatcher Processes are created?

What is the function of Lock (LCKn) Process?

What is advantage of having disk shadowing/ Mirroring ?

What are the components of SGA?

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

What is an oracle database schema?

How will you force database to use particular rollback segment?

For more Oracle Architecture Interview Questions Click Here