Oracle Streams Interview Question and Answers

13. What is a resource plan directive?
 
  • Resource plan directive is the key element in creating complex resource plans. It assigns consumer groups to resource plans and defines the resource allocation for each.
  • It can also allocate resources to sub plans.
 
Your Name Your Email-ID
Your Answer
14. What is an undo pool allocation method?
 
  • It is a resource plan directive parameter, which controls the total amount of undo (in KB) that can be generated by a consumer group or sub plan.
  • It can be set using the UNDO_POOL parameter.
  • The default value for this parameter is null which indicates that no limit is imposed
 
Your Name Your Email-ID
Your Answer
15. How can you manage operating system resources from the database?
  You can use Database Resource Manager (DRM) to manage operating system resources.
 
Your Name Your Email-ID
Your Answer
16. What is canceling SQL and terminating sessions?
 
  • You can specify the directives to cancel long running SQL queries or to terminate long running sessions based on the amount of system resources consumed.
  • In other words, you can cancel SQL queries or kill sessions if consumer group meets certain criteria.
  • The criterion is specified using the SWITCH_TIME and SWITCH_ESTIMATE parameters.
  • The option to CANCEL_SQL or KILL_SESSION can be specified by the SWITCH_GROUP parameter.
 
Your Name Your Email-ID
Your Answer
17. What is automatic consumer group switching?
 
  • It is a type of resource allocation method used to automatically switch the consumer group if the switch criterion is met.
  • The switch group is specified using the SWITCH_GROUP parameter.
  • Switch criteria can be set using the SWITCH_TIME and SWITCH_ESTIMATE parameters.
 
Your Name Your Email-ID
Your Answer
1234 Page 4 of 4