What is the function of Lock (LCKn) Process?
Answer / guest
Lock (LCKn) are used for inter-instance locking when the ORACLE
Parallel Server option is used.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is Shared SQL Area?
Why query fails sometimes ?
What is a Rollback segment entry ?
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?
what is ORACLE MEMORY STRUCTURES
What is meant by free extent ?
What is the maximum number of Lock Processes used?
What is User Process?
What is dictionary cache ?
What is PGA?
What is the functionality of SYSTEM table space ?
List the Optional Flexible Architecture (OFA) of Oracle database ?