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 is Database Buffers ?
What is the maximum number of Lock Processes used?
What is meant by redo log buffer ?
What is SGA?
How to define Data Block size in Oracle?
What is the use of Oracle Control File?
When will be a segment released?
Name the ORACLE Background Process?
What is the OPTIMAL parameter ?
What constitute an ORACLE Instance?
What is an Oracle SYSTEM tablespace and when is it Created?
What is meant by recursive hints ?