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 the uses of Oracle Rollback Segment?
What does LGWR do?
How will you monitor rollback segment status ?
Diference between Oracle 9i and 10G.
What is the function of Dispatcher (Dnnn)?
What is the maximum size of a oracle9i database?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
List the Optional Flexible Architecture (OFA) of Oracle database ?
What is an Oracle Data Block?
What is a Control file ?
What is SGA?
What is dictionary cache ?