Oracle Streams Interview Question and Answers

5. What is a sub plan?
  A resource sub plan is a plan, which gets the resource to allocate from a higher level plan. It is created in a similar manner as a plan. However, a top level plan gets to allocate 100% of the resource while a sub plan can allocate only the resources allocated to it by the top level plan.
 
Your Name Your Email-ID
Your Answer
6. What is parallel degree limit?
 
  • Parallel degree limit is an allocation method for degree of parallelism.
  • It specifies the maximum degree of parallelism for an operation.
  • It can be set using the PARALLEL_DEGREE_LIMIT_P1 parameter.
  • The default value of this parameter is null which indicates no limit is imposed.
 
Your Name Your Email-ID
Your Answer
7. What is a CPU method or parameter?
  Oracles uses eight levels of CPU allocation namely, CPU_P1 to CPU_P8, to prioritize and allocate CPU usage among the competing user sessions.
 
Your Name Your Email-ID
Your Answer
8. What is an active session pool?
 
  • It specifies the maximum number of concurrently active sessions for a consumer group or sub plan. It can be set using the ACTIVE_SESS_POOL_P1 parameter.
  • The default value for this parameter is null which means unlimited.
 
Your Name Your Email-ID
Your Answer
1234 Page 2 of 4