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 |
How will you monitor the space allocation ?
What are functions of PMON?
What is the OPTIMAL parameter ?
How does Space allocation table place within a block ?
What is Shared Pool?
What are the two types of Server Configurations?
What is meant by free extent ?
How will you monitor rollback segment status ?
What is an Oracle SYSTEM tablespace and when is it Created?
What is advantage of having disk shadowing/ Mirroring ?
How can we plan storage for very large tables ?
What is meant by redo log buffer ?