Why I need two Concurrent Processing Nodes or in

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Why I need two Concurrent Processing Nodes or in what scenarios PCP is Used ?

Well If you are running GL Month end reports or taxation reports annually these reposrts might take couple of days. Some of these requests are very resource intensive so you can have one node running long running , resource intensive requests while other processing your day to day short running requets.
Another scenario is when your requests are very critical and you want high resilience for your Concurrent Processing Node , you can configure PCP. So if node1 goes down you still have CM node available processing your requests.

(Continued on next question...)

Other Job Interview Questions

• What are few profile options which you update after cloning ?
• How to compile Invalid Objects in database ?
• What is dev60cgi and f60cgi ?
• What is different between NO DATA FOUND and %NOTFOUND
• What is plssql/database cache ?
• Can the default values be assigned to actual parameters?
• What are various options available with adpatch ?
• Can cursor variables be stored in PL/SQL tables. If answer is yes, explain how? If not why?
• What are few profile options which you update after cloning ?
• What are different modes of parameters used in functions and procedures?
• More...