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 |
What are Oracle Schema Objects?
What is meant by recursive hints ?
What Does DBWR do?
How to implement the multiple control files for an existing database ?
What is dictionary cache ?
What is the function of ARCH?
What is the function of Lock (LCKn) Process?
What are the consideration at tehe migration of Oracle 9i to 10G.
What is the OPTIMAL parameter ?
How will you force database to use particular rollback segment?
List the Optional Flexible Architecture (OFA) of Oracle database ?
What do Redo Log Buffers contain?