Pages

Wednesday, April 16, 2014

All About Oracle Parallel Concurrent Processing (PCP)


All About Oracle Parallel Concurrent Processing (PCP)


1) What is PCP

   - Parallel Concurrent Processing (PCP) is an extension of the Concurrent Processing architecture. 

   - PCP allows concurrent processing activities to be distributed across multiple nodes, maximizing throughput and providing resilience to node failure.

2) How to Configure Parallel Concurrent Processing (PCP)

  Below are steps to configure the PCP in Oracle Applications.

  A) Set Up PCP
  
  - Edit the applications context file via Oracle Applications Manager, and set the value of the variable APPLDCP to ON.

  - Execute AutoConfig by running the following command on all concurrent processing nodes:

  - $ $INST_TOP/admin/scripts/adautocfg.sh

  - Source the Applications environment.

  - Check the tnsnames.ora and listener.ora configuration files, located in $INST_TOP/ora/10.1.2/network/admin. Ensure that the required FNDSM and FNDFS entries are present for all other concurrent nodes.

  - Restart the Applications listener processes on each application tier node. 

  - Log on to Oracle E-Business Suite Release 12 using the SYSADMIN account, and choose the System Administrator Responsibility. Navigate to Install > Nodes screen, and ensure that each node in the cluster is registered.

  - Verify that the Internal Monitor for each node is defined properly, with correct primary node specification, and work shift details. For example, Internal Monitor: Host1 must have primary node as host1. Also ensure that the Internal Monitor manager is activated: this can be done from Concurrent > Manager > Administrator. 

  - Set the $APPLCSF environment variable on all the Concurrent Processing nodes to point to a log directory on a shared file system.

  - Set the $APPLPTMP environment variable on all the CP nodes to the value of the UTL_FILE_DIR entry in init.ora on the database nodes. (This value should be pointing to a directory on a shared file system.)

  - Set profile option 'Concurrent: PCP Instance Check' to OFF if database instance-sensitive failover is not required (In case of Non RAC Database). By setting it to 'ON', a concurrent manager will fail over to a secondary Application tier node if the database instance to which it is connected becomes unavailable for some reason.


  B) Set Up Transaction Managers  (Only R12)
  
  If you are already using the transnational managers and If you wish to have transnational managers fail over, Perform the below steps

  - Shut down the application services (servers) on all nodes

  - Shut down all the database instances cleanly in the Oracle RAC environment, using the command: 
  
  - SQL>shutdown immediate;
  
  - Edit the $ORACLE_HOME/dbs/<context_name>_ifile.ora and add the following parameters:
        _lm_global_posts=TRUE
        _immediate_commit_propagation=TRUE

  - Start the instances on all database nodes.

  - Start up the application services (servers) on all nodes.

  - Log on to Oracle E-Business Suite Release 12 using the SYSADMIN account, and choose the System Administrator responsibility. Navigate to Profile > System, change the profile option ‘Concurrent: TM Transport Type' to ‘QUEUE', and verify that the transaction manager works across the Oracle RAC instance.

  - Navigate to Concurrent > Manager > Define screen, and set up the primary and secondary node names for transaction managers.

  - Restart the concurrent managers.

  - If any of the transaction managers are in a deactivated status, activate them from Concurrent > Manager > Administrator.


 C) Set Up Load Balancing on Concurrent Processing Nodes (Only Applicable in case of RAC)

  If you wish to have PCP to use the load balancing capability of RAC, You can perform the below, Connections will load balanced using SID_BALANCE value and they will connect to all the RAC nodes.
  

  - Edit the applications context file through the Oracle Applications Manager interface, and set the value of Concurrent Manager TWO_TASK (s_cp_twotask) to the load balancing alias (<service_name>_balance>).

  - Execute AutoConfig by running $INST_TOP/admin/scripts/adautocfg.sh on all concurrent nodes.


3) Is RAC Mandatory to Implement PCP?

  - No, RAC is not manadatory for PCP, If you have two or more applications nodes, You can enable PCP, But PCP works better in conjunction with RAC to handle all the failover scenarious.


4) How PCP Works with RAC?

 - In RAC Enabled env, PCP uses cp_two_task env variable to connect to DB RAC node, This can be set one CM node to one RAC node or you can set to connect to all the RAC nodes in the cluster.

5) What happens when one of the RAC node goes down when PCP enabled?

 - When Concurrent: PCP Instance Check is set to ON and cp_two_task value set to SID (i.e One CM node connects to only one RAC node always), If one DB node goes down, PCP identifies the DB failure and shifts all the CM managers to other applications node where Database is available.


6)What happen when one of the PCP node goes down?

 - IMON identifies the failure and through FNDSM (service Manager) It initiates ICM to start in surviving node (If ICM is is running on Failed node), ICM will start all the managers.

7) What is primary and Secondary Nodes in PCP?

 - It is requirement to define the primary and secondary node to distribute load on the servers, If this is not defined,All the managers will start on the node where ICM is running by default.

8) How Fail Back happens in PCP?

 - Once failed node comes online, IMON detects and ICM will fail back all the managers defined on that node. 

9) What happens to requests running during failover in PCP?

 - It is important to note RAC and PCP does not support any DML commands and TAF and FAN are not supported with E-Bussiness Suite.
 - When a request is running, If CM goes down it is having status running normal and it will not have any associated process ID, When ICM start in other node, It     
   verifies for all the running normal requests and verifies the OS process ID, If it did not find the process ID, It will resubmit the request to start.

 -  This behavior is normal even in NON PCP env.

 - The Internal Concurrent Manager (ICM) will only restart a request if the following conditions are met

The ICM got the manager's database lock for the manager that was running the request
The phase of the request is "running" (phase_code = 'R')
The program for this request is set to "restart on failure"
All of the above requirements have been met AND at least one of the following:
         a.  The ICM is just starting up, (ie. it has just spawned on a given node and going through initial code before the main loop)
         b.  The node of the concurrent manager for which we got the lock is down
         c.  The database instance (TWO_TASK) defined for the node of that concurrent  manager is down (this is not applicable if one is using some "balance" @ TWO_TASK on that node)



10) How PCP identifies when node goes down?

  - There are two types of failures that PCP recognizes.

a.) Is the node pingable ? 
Issues an operating system ping on the machine name - timeout or available.

b.) Is the database available? 
Query on V$threads and V$instance for value of open or close.



 - When any of the two above failures occur, the following example will illustrate the failover and failback of managers.

Primary node = HOST1 - Managers assigned to primary node are ICM (FNDLIBR-cpmgr) , FNDCRM
Secondary node = HOST2 - Manager assigned to secondary node is STandard Manager (FNDLIBR)

When HOST1 becomes unavailable, both ICM and FNDCRM are migrated over to HOST2.
This is viewable from Administer Concurrent Manager form in System Administrator Responsibility.
The $APPLCSF/log/.mgr logfile will also reflect that HOST1 is being added to unavailable list.

On HOST2, after pmon cycle, FNDICM, FNDCRM, and FNDLIBR are now migrated and running.
(Note: FNDIMON and FNDSM run independently on each concurrent processing node. FNDSM
is not a persistent process, and FNDIMON is a persistent process local to each node)

Once HOST1 becomes available, FNDICM and FNDCRM are migrated back to the original primary 
node for successful failback.



In summary, in a successful fail over and failback scenario, all managers should failover to their secondary node, and once node or instance becomes available; then all managers should failback to primary node.




349 comments:

  1. What happens to requests running during failover in RAC node?

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. Hi this is abinaya i am having 3 years of experience as a java developer and i am certified. i have knowledge on OOPS concepts in java but dont know indepth. After learning oracle will be enough to get a good career in IT with good package? and i crossed oracle training chennai website where someone please help me to identity the syllabus covers everything or not??

    Thanks, abinaya

    ReplyDelete
  4. The information you posted here is useful to make my career better keep updates..If anyone want to become an oracle certified professional reach FITA, which offers Best Oracle Training in Chennai with years of experienced professionals.

    ReplyDelete
  5. Cloud Computing Training

    The information you posted here is useful to make my career better keep updates...If anyone want to get Cloud Computing Training in Chennai, Please visit FITA academy located at Chennai Velachery which offer best Cloud Computing Course in Chennai.

    ReplyDelete
  6. This comment has been removed by the author.

    ReplyDelete
  7. This comment has been removed by the author.

    ReplyDelete
  8. Its Very informative blog with lot of examples thanks for sharing and keep doing it am your regular follower....

    dot net training in chennai | salesforce training in chennai | cloud computing training in chennai

    ReplyDelete
  9. hadoop training in chenani

    This is post for the useful information..oracle training in chennai..you have any preparing for oracle dba training in chennai...this is the my wonderful..Thanks a lot..

    ReplyDelete
  10. This post is wonderful..hadoop training in chennai..We have any visit oracle oracle training in chennai....i learing for lot information.Thanks a lot..oracle dba training in chennai

    ReplyDelete
  11. Java training in Chennai

    My publications is regarding your blog Android training in chennai Your blog has give a turning capacity in all aspects and can easily manage my books IOS training in chennai

    ReplyDelete
  12. Java training in Chennai

    Generally, We have enough period to access the numeric methods but still i can survive it.

    Android training in chennai | Java training in Chennai

    ReplyDelete
  13. Big Data Training Chennai

    I get a lot of great information from this blog. Thank you for your sharing this informative blog. Just now I have completed hadoop certification course at a leading academy. If you are interested to learn Hadoop Training in Chennai visit FITA IT training and placement academy which offer Big Data Training in Chennai.


    ReplyDelete
  14. Thanks for sharing this Information blog. Recently I have completed Oracle Training Courses in Bangalore at a leading Company. It's really useful for me to make a bright Future career. Visit Us, Oracle Training in Bangalore

    ReplyDelete

  15. Thanks for sharing this excellent post. Its really very informative and interesting. Keep update your blog. For a best Android training in Chennai please refer this site.
    Regards....
    Android Course in Chennai


    ReplyDelete
  16. Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog. Keep update your blog. Recently I did Testing Training in Chennai at a reputed training institutes. This is really useful for me to make a bright future in IT field.

    ReplyDelete
  17. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.
    Regards,
    Salesforce training in Chennai|Salesforce training

    ReplyDelete
  18. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    Salesforce course in Chennai|Salesforce training chennai

    ReplyDelete
  19. It was really a wonderful article and I was really impressed by reading this blog. We are giving all software and Database Course Online Training. Oracle Training in Chennai is one of the reputed Training institute in Chennai. They give professional and real time training for all students..

    Oracle Training in chennai

    ReplyDelete
  20. Oracle Training in chennai

    It’s too informative blog and I am getting conglomerations of info’s about Oracle interview questions and answer .Thanks for sharing, I would like to see your updates regularly so keep blogging.

    ReplyDelete
  21. Informatica Training in chennai

    This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic..

    ReplyDelete
  22. Pega Training in Chennai

    Brilliant article. The information I have been searching precisely. It helped me a lot, thanks. Keep coming with more such informative article. Would love to follow them.

    ReplyDelete
  23. QTP Training in Chennai,

    Thank you for the informative post. It was thoroughly helpful to me. Keep posting more such articles and enlighten us..

    ReplyDelete
  24. Nice article i was really impressed by seeing this article, it was very interesting and it is very useful for me.I get a lot of great information from this blog. Thank you for your sharing this informative blog..

    SAS Training in Chennai

    ReplyDelete
  25. I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..

    Greens Technologies In Chennai

    ReplyDelete
  26. I was looking about the Oracle Training in Chennai for something like this ,Thank you for posting the great content..I found it quiet interesting, hopefully you will keep posting such blogs…

    Greens Technologies In Chennai

    ReplyDelete
  27. It is really very helpful for us and I have gathered some important information from this blog.Oracle Training In Chennai

    ReplyDelete
  28. Oracle Training in Chennai is one of the best oracle training institute in Chennai which offers complete Oracle training in Chennai by well experienced Oracle Consultants having more than 12+ years of IT experience.

    ReplyDelete
  29. There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this.

    ReplyDelete
  30. Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision.
    Informatica Training In Chennai

    ReplyDelete
  31. A Best Pega Training course that is exclusively designed with Basics through Advanced Pega Concepts.With our Pega Training in Chennai you’ll learn concepts in expert level with practical manner.We help the trainees with guidance for Pega System Architect Certification and also provide guidance to get placed in Pega jobs in the industry.

    ReplyDelete
  32. Our HP Quick Test Professional course includes basic to advanced level and our QTP course is designed to get the placement in good MNC companies in chennai as quickly as once you complete the QTP certification training course.

    ReplyDelete
  33. Thanks for sharing this nice useful informative post to our knowledge, Actually SAS used in many companies for their day to day business activities it has great scope in future.

    ReplyDelete
  34. Greens Technologies Training In Chennai Excellent information with unique content and it is very useful to know about the information based on blogs.

    ReplyDelete
  35. Greens Technology offer a wide range of training from ASP.NET , SharePoint, Cognos, OBIEE, Websphere, Oracle, DataStage, Datawarehousing, Tibco, SAS, Sap- all Modules, Database Administration, Java and Core Java, C#, VB.NET, SQL Server and Informatica, Bigdata, Unix Shell, Perl scripting, SalesForce , RedHat Linux and Many more.

    ReplyDelete
  36. Thank you for the useful article. It has helped a lot in training my students. Keep writing more.
    big data training Chennai

    ReplyDelete
  37. Very nice article,thanks for sharing such a useful information about online trainings.

    Selenium Training

    Solaris Training

    ReplyDelete
  38. Oracle DBA Training in Chennai
    Thanks for sharing this informative blog. I did Oracle DBA Certification in Greens Technology at Adyar. This is really useful for me to make a bright career..

    ReplyDelete
  39. Whatever we gathered information from the blogs, we should implement that in practically then only we can understand that exact thing clearly, but it’s no need to do it, because you have explained the concepts very well. It was crystal clear, keep sharing..
    Websphere Training in Chennai

    ReplyDelete
  40. Data warehousing Training in Chennai
    I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly..

    ReplyDelete
  41. Selenium Training in Chennai
    Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

    ReplyDelete
  42. Oracle Training in chennai
    Thanks for sharing such a great information..Its really nice and informative..

    ReplyDelete
  43. SAP Training in Chennai
    This post is really nice and informative. The explanation given is really comprehensive and informative..

    ReplyDelete
  44. This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post,thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic
    Android Training In Chennai In Chennai

    ReplyDelete
  45. I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
    SalesForce Training in Chennai

    ReplyDelete
  46. There are lots of information about latest technology and how to get trained in them, like Best Hadoop Training In Chennai in Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies Hadoop Training in Chennai By the way you are running a great blog. Thanks for sharing this blogs..

    ReplyDelete
  47. Wonderful article! Thanks for sharing your important experience and valuable thoughts.
    http://www.crazybulksale.com/crazy-bulk-reviews/

    ReplyDelete
  48. hai you have to learned to lot of information about c# .net Gain the knowledge and hands-on experience you need to successfully design, build and deploy applications with c#.net.
    C-Net-training-in-chennai

    ReplyDelete
  49. hai If you are interested in asp.net training, our real time working.
    asp.net Training in Chennai.
    Asp-Net-training-in-chennai.html

    ReplyDelete
  50. Awesome Job oriented sharepoint training in Chennai is offered by our institue is mainly focused on real time and industry oriented. We provide training from beginner’s level to advanced level techniques thought by our experts.
    if you have more details visit this blog.
    SharePoint-training-in-chennai.html

    ReplyDelete
  51. if share valuable information about cloud computing training courses, certification, online resources, and private training for Developers, Administrators, and Data Analysts may visit
    Cloud-Computing-course-content.html

    ReplyDelete
  52. Crazy Bulk Review You really very helpless at the time when you have lean muscles and don’t have proper body muscles growth and that can’t give you proper effectiveness and such way whatever medications or products you take that don’t give that positive result. The Crazy Bulk is the right one helping in such manner where you taking it on daily basis providing the best result and in few times you can gain your body muscles. The Crazy Bulk review says after using by many people they complemented about the Crazy Bulk products. They add “It is effective and really how incredibly the Crazy Bulk bodybuilding supplement increased the muscles strength and I had very lean and thin muscles and felt always embarrassed going to anyone”, but thanks to Crazy Bulk given me the strong muscles and now I am confidently introduces myself and attend every program and party.

    http://www.mycrazybulkreviews.com/

    ReplyDelete

  53. Really awesome blog. Your blog is really useful for me. Thanks for sharing this informative blog. Keep update your blog.
    QTP Training in Chennai

    ReplyDelete
  54. There are lots of information about latest technology and how to get trained in them, like Hadoop Training Chennai have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies(Hadoop Training in Chennai). By the way you are running a great blog. Thanks for sharing this.

    ReplyDelete
  55. Excellent information with unique content and it is very useful to know about the information based on blogs.
    Selenium Training in Chennai | QTP Training In Chennai

    ReplyDelete
  56. Excellent information with unique content and it is very useful to know about the information based on blogs.
    Hadoop Training In Chennai | oracle apps financials Training In Chennai | advanced plsql Training In Chennai

    ReplyDelete
  57. The information you posted here is useful to make my career better keep updates.
    buy crazy bulk

    http://www.buycrazybulks.com/

    ReplyDelete
  58. Very nice blogs!!! i have to learning for lot of information for this sites...Sharing for wonderful information.Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
    sap abap Training in Chennai

    ReplyDelete
  59. Great article Corbett. I believe blog comments should be left on. Interaction is key. Quite often I find extra interesting tips that continue in the discussion - of course their is Spam too.
    Crazy Bulk Dbal

    ReplyDelete
  60. Hello admin, thank you for your informative post on hadoop training in Chennai. It helped a lot in training my students during our hadoop training Chennai sessions. We at Fita, provide big data training in Chennai for students who are interested in choosing a career in big data.

    ReplyDelete
  61. The information you posted here is useful to make my career better keep updates http://www.buycrazybulks.com/

    ReplyDelete
  62. I think comments can help you get feedback from your readers and see if you are blogging efforts pay off. http://www.weightlossopinion.com/

    ReplyDelete
  63. This a very useful piece of information. .buyhealthmart

    ReplyDelete
  64. I think comments can help you get feedback from your readers .Crazy Bulk

    ReplyDelete
  65. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
    Garcinia Cambogia Extra Review

    ReplyDelete
  66. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
    Garcinia Cambogia Extra Review

    ReplyDelete
  67. Excellent information with unique content .buy crazy bulk

    ReplyDelete
  68. Bed Bug Exterminator Maryland It is really a great and useful piece of information. I am glad that you shared this helpful info with us. Please keep us up to date like this. Thank you for sharing.

    ReplyDelete
  69. http://demo.presthemes.com/bonsanis/product.php?id_product=17&id_lang=2
    http://www.realcombiz.com/2012/05/seo-optimizereverse-blog-title-after.html
    http://heywhatever.net/profile/jamesedward
    http://www.dbatutor.com/2014/04/all-about-oracle-parallel-concurrent.html
    http://directoryfire.com/listings/fitness.html/page:2
    http://blog.themobilityresource.com/blog/post/13-romantic-things-in-a-marriage-with-a-disability?replytocom=2075
    http://www.passion-shop.sk/erekcne-kruzky/1274-kruzky-svietiace-v-tme-3-ks.html
    http://demonriders.com/user/jamesedward
    http://www.gantsnoirsetblancs.fr/en/tous-les-gants/12-gants-pour-tenue-maconnique-homme.html
    http://www.kukutis.com/ru/vkladyshy/74-prefold-pelenka-vkladis-bambukovoj.html

    ReplyDelete
  70. Latest Govt Bank Railway Jobs Notification 2016

    Very interesting thanks. I believe there's even more that could be on there! Keep it up.....................

    ReplyDelete
  71. Haryana HSSC Steno Typist Recruitment 2016

    Thanks for sharing it. I found this Information very interesting and informative Keep sharing................

    ReplyDelete
  72. Naval Dockyard Visakhapatnam Tradesman Skilled Recruitment 2016

    The information mentioned in the blog are several of the very best available...........

    ReplyDelete
  73. Website Development Virginia I am sure this post has helped me save many hours of browsing other related posts just to find what I was looking for. Many thanks!

    ReplyDelete
  74. Such a informative post.Thanks for sharing your knowledge with us.keep it up for updating post..
    http://sonymobileservicecenterinchennai.in/AboutUs.html

    ReplyDelete
  75. Bed Bug Control Leesburg VA It is really a great and useful piece of information. I am glad that you shared this helpful info with us. Please keep us up to date like this. Thank you for sharing.

    ReplyDelete
  76. Best SAS Training Institute In Chennai It’s too informative blog and I am getting conglomerations of info’s about Oracle interview questions and answer .Thanks for sharing, I would like to see your updates regularly so keep blogging.

    ReplyDelete
  77. Thanks for giving Good Example.
    Fantastic article Viral. Very well written clear and concise. One of the best links explaining one to many and hierarchy oracle DBA. Thanks a lot. It is useful to me and my training oracledbaonlinetraining

    ReplyDelete
  78. This post is really nice and informative. The explanation given is really comprehensive and informative..
    SAS Training In Chennai

    ReplyDelete
  79. This module deals with PCP, this will be an very much useful information for oracle leaner, we are providing salesforce training:
    salesforce

    ReplyDelete
  80. This information is impressive..I am inspired with your post writing style & how continuously you describe this topic. After reading your post,thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.
    Selenium Training in chennai

    ReplyDelete
  81. Today we are living in the Modern Data World. Yes, “SOFTWARE TESTING” is Very important in the real time world to find the defects made in the development phase. Software testing helps to grow your business in a better way.

    Software testing training in Chennai

    ReplyDelete
  82. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us.
    ... DOT NET Training in chennai

    ReplyDelete
  83. Are you a graduate, looking for an IT job in chennai or India? If yes, then your job searching comes to ends here.
    android training in Chennai

    ReplyDelete

  84. Truely a very good article on how to handle the future technology. This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks. After reading your post,thanks for taking the time to discuss this, I feel happy about and I love learning more about this topic.keep sharing your information regularly for my future reference.

    Cloud Computing Training in Chennai

    ReplyDelete
  85. Thank you for this list, I found a lot of interesting things. I also learn some advance about
    hadoop training in Chennai

    ReplyDelete
  86. Nice post. I learned something knowledgeable. Thanks for sharing.

    IELTS classes in Kuwait

    ReplyDelete
  87. Really a nice post. This is very useful in attain my knowledge in oracle.Thanks for sharing.
    Loadrunner Training in Chennai

    ReplyDelete
  88. I read this article completely it is unique content.It has valuable information and is useful for me.We provide the java training with real time environment.I hope it is useful for your future.
    Java Training in Chennai

    ReplyDelete
  89. Nice information about the oracle dba. Thanks for sharing. Join our Cloud Computing Training in Chennai

    ReplyDelete
  90. I agreed with your article that had posted.It's really useful for oracle people.Nice article share!!!Thanks for sharing this information with us.In-case if any body wants to undergone salesforce training course,can Enroll from our best salesforce training institute.Here we offered world class training with placement support.For more course details,just visit here @ Salesforce developer training in Chennai

    ReplyDelete
  91. Thanks for explain basic details about parallel concurrent processing. then good explanation pcp with rac. and also the transaction steps are explained clearly.
    Informatica Training in Chennai

    ReplyDelete
  92. The information provided in this blog is very informative for the beginners to startup their career. Thanks for sharing this valuable informationManual Testing Training in Chennai

    ReplyDelete
  93. Thank you for your helpful blog. It's very useful for interview.Question and answer pattern is very useful for studying.Still we are expecting more question and answer from you.
    Android Training in Chennai

    ReplyDelete
  94. I want to thank you for this blog. I had made a bookmark for it.Really its use ful for future.Who are attending interview can gather many information from this blog.Thank you for ur support.
    Android Training in Chennai

    ReplyDelete
  95. excellent post useful to learn more,really it is useful for us,it provides more information to learn and improve our skills.each and every points are easy to understand about Oracle applications.
    CCNA Training in Chennai

    ReplyDelete
  96. parallel concurrent processing is a method that many works can run at the same time. Thanks for the basic explanation of parallel concurrent processing. All the questions and answers are explained with easily understandable method.
    VMWare Training in Chennai

    ReplyDelete
  97. without parallel processing no pcs are working. here explains the details of basic question and answers of parallel processing.VMWare Training in Chennai

    ReplyDelete
  98. I got the basic things of pcp information which is useful and informative thanks for sharing this concept.

    sharepoint-developer-training in chennai

    ReplyDelete
  99. you shared whatever i expected about PCP. thanks Naresh miryala's DBA Blog.
    veritas volume Manager Training in Chennai

    ReplyDelete
  100. It is good to read this blog.I really thanks for this information.
    Sharepoint admin training in chennai

    ReplyDelete
  101. Thanks for sharing the post that contains all the basic to advanced topics starts with the definition that gives us the clear knowledge about the course. we are offering Datawarehousing Training in Chennai join and get benefited

    ReplyDelete
  102. Thanks for sharing the information. It explains the concept of handling future technology which helps for the users to understand the concept easily. please update these kind of informationssrs-training-in-chennai

    ReplyDelete
  103. i really feel thankful. the information is very useful for us to develop our knowledge in PCP. please keep on publishing the post like this, so as to develop our knowledge to have some better idea about those concept.

    Veritas cluster training in Chennai

    ReplyDelete
  104. You have explained about Oracle E bossiness.Its very interesting.Thanks for updating new things like this..
    linux training in chennai

    ReplyDelete
  105. Nice blog with much information covers the basic topics in more understandable format. join our Datawarehousing Training in Chennai

    ReplyDelete
  106. Thanks for sharing this blog.Its very useful for us.Question answer pattern is too good to understand quicky.
    linux training in chennai

    ReplyDelete
  107. this blog contains the very detailed explanation of parallel concurrent processing. all the details are easily learnable. thank you for this site.CCNA Training in Chennai

    ReplyDelete
  108. informative blog.... keep blogging like this....CCNA Training in Chennai

    ReplyDelete
  109. Excellent article.I read this blog completely and is easy to understanding.This contents are unique.
    Websphere MQ Training in Chennai

    ReplyDelete
  110. PCP information is wonderful.I got a idea for PCP.I am waiting for your next post.
    Websphere MQ Training in Chennai

    ReplyDelete
  111. Thanks for sharing this blog.Its very easy to understand.
    weblogic training in chennai

    ReplyDelete
  112. Clearly explained about PCP.Question and answer method is very useful.
    weblogic training in chennai

    ReplyDelete
  113. very informative and nice blog. sql concepts are explained clearly. question and answers session are also very informative ios training in chennai

    ReplyDelete
  114. Wonderful article. very interesting to read and I learned more new things. Thanks for sharing.

    web design training institute in Chennai

    ReplyDelete
  115. the blog is about oracle pcp is very useful and informative. i learned certain new concepts from this, please keep on updating. thank you...Microstrategy Training in

    Chennai

    ReplyDelete
  116. Angular Js Online training at Online IT Guru with 7+ years of hands on exp. We provide training in Hyderabad and USA. Angular JS is a powerfull JavaScript Frame work.contact:9885991924.
    anjular js online training

    ReplyDelete
  117. Thanks for sharing these information. It’s a very nice topic. We IT hub Online Training are good in giving the oracle apps technical Training

    ReplyDelete


  118. I read your articles very excellent and the i agree our all points because all is very good information provided this through in the post. It is very helpful for me. Keep blogging like this. Thanks.

    Peridot Systems Chennai Reviews

    ReplyDelete

  119. Superb i really enjoyed very much with this article here. Really its a amazing article i had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.



    Peridot Systems Chennai Contact Address

    ReplyDelete
  120. India Exam Results 2016. JEE Mains Results, Advanced JEE Results, 10th Class Results SSC Results 2016, Intermediate Results 2016 Manabadi Schools 9 Results 2016 Check your Results and Marks.
    SSC Results 2016
    JEE Mains Results 2016
    ICSE Results 2016
    AP SSC Results 2016
    Telangana SSC Results 2016
    CBSE 10th Class Results
    Intermediate Results 2016

    ReplyDelete
  121. Crazy Bulk - Crazy bulk is one of the ideal options to build quality and strongest muscles masses just in 2 to 3 weeks. This is the greatest product for muscle growth & Read Crazy Bulk Review first. Provides the good muscle size. The person who is looking for the right muscle gaining supplement they can choose this crazy bulk product to gain powerful muscles as well as the crazy bulk helps to increase your stamina.
    http://www.crazybulkstacks.com/

    ReplyDelete
  122. This comment has been removed by the author.

    ReplyDelete
  123. This comment has been removed by the author.

    ReplyDelete
  124. This comment has been removed by the author.

    ReplyDelete
  125. This comment has been removed by the author.

    ReplyDelete
  126. Crazy bulk is one of the ideal options to build quality and strongest muscles masses just in 2 to 3 weeks. This is the greatest product for muscle growth that provides the good muscle size. The person who is looking for the right muscle gaining supplement they can choose this crazy bulk product to gain powerful muscles as well as the crazy bulk helps to increase your stamina. http://www.crazybulkstacks.com/

    ReplyDelete
  127. Crazy bulk is one of the ideal options to build quality and strongest muscles masses just in 2 to 3 weeks. This is the greatest product for muscle growth that provides the good muscle size. The person who is looking for the right muscle gaining supplement they can choose this crazy bulk product to gain powerful muscles as well as the crazy bulk helps to increase your stamina. http://www.crazybulkstacks.com/

    ReplyDelete
  128. Hi ,
    The future of software testing is on positive note. It offers huge career prospects for talented professionals to be skilled software testers.
    Regards,
    Loadrunner Training in Chennai|Loadrunner Training|Qtp training institutes in chennai|testing training in chennai|Software training institutes in chennai|Software testing training institutes in chennai

    ReplyDelete
  129. Hi ,
    The future of software testing is on positive note. It offers huge career prospects for talented professionals to be skilled software testers.
    Regards,
    Loadrunner Training in Chennai|Loadrunner Training|Qtp training institutes in chennai|testing training in chennai|Software training institutes in chennai|Software testing training institutes in chennai

    ReplyDelete
  130. thanku for sharing..

    SEO training in hyderabad by experts in digital markeing And by prosessional experts in seo.All the training by placement and also guide by the professionals.SEO training in hyderabad

    ReplyDelete
  131. construction waste removal dc Established in 2003, EnviroSolutions is a vertically integrated solid waste collection, disposal and recycling company located in the Northeast and Mid-Atlantic regions of the United States.

    ReplyDelete
  132. The usage of third party storage system for the data storage can be avoided in cloud computing and we can store, access the data through internet.
    cloud computing training in chennai | cloud computing courses in chennai

    ReplyDelete
  133. Nice information!!! I prefer Loadrunner automation testing tool to validate the performance of software application/system under actual load.
    Regards,
    Loadrunner Training|Loadrunner course in Chennai|Qtp training |Qtp training institutes in chennai

    ReplyDelete
  134. My Arcus offer java training with 100% placement. Our java training course that includes fundamentals and advance java training program with high priority jobs. java j2ee training with placement having more exposure in most of the industry nowadays in depth manner of java

    java training in chennai

    ReplyDelete
  135. Great post. Happy to visit your blog. Thanks for sharing.

    php training in chennai

    ReplyDelete

  136. Hadoop online training .All the basic and get the full knowledge of hadoop.
    hadoop online training


    ReplyDelete
  137. Great article. Keep sharing such a useful post.

    ppc training in chennai

    ReplyDelete

  138. Wonderful post. This is very useful post. Keep sharing.

    Android Training in Chennai

    ReplyDelete
  139. All about oracle parallel concurrent posrts..

    Hadoop training in hyderabad.All the basic and get the full knowledge of hadoop.
    hadoop training in hyderabad


    ReplyDelete
  140. Hadoop training in hyderabad discusses many such things such as tools, resources or news related to hadoop.Nice techno resources available as always,at
    hadoop online training

    ReplyDelete

  141. Wonderful post. This is very useful post. Keep sharing.

    the best sas training in chennai

    ReplyDelete
  142. This comment has been removed by the author.

    ReplyDelete
  143. Great post. Happy to visit your blog. Thanks for sharing.
    java training in chennai

    ReplyDelete
  144. really you have post an informative blog.it will be really helpful to many peoples.thank you for sharing this blog.
    BigData Analytics Training

    ReplyDelete
  145. Great post. It really helped me to learn something new. So thanks.
    php training in Bangalore

    ReplyDelete
  146. Excellent information for the oracle. I want to read more information for Oracle.

    Manshu Ydoxy
    Founder at www.ydoxy.com

    ReplyDelete
  147. will you also teach SQL DBA Courses ..As to my knowledge SQL DBA Training Institutes in Hyderabad are very less in number who gives the best training for students..! hope to hear from u

    ReplyDelete
  148. This is my first visit to your blog, your post made productive reading, thank you. dot net training in chennai

    ReplyDelete
  149. Thanks for sharing information about Oracle Training, I read your entire post and realize that your post is really informative. Such type of post is really helpful for those people who want to learn Oracle. Apart from this I read another informative post for same kind of information. For your further information I am sharing that informative post about Oracle Training. http://www.ducatindia.com/oracle11gdbatraininginnoida/

    ReplyDelete
  150. Freelance Best Makeup & Hair Artist in Jaipur with huge experience and Specialization in Bridal and Wedding Makeup,Celebrity Makeup,Professional Makeup,Creative Makeup,Bollywood Makeup and Character Makeup in Delhi,Jaipur,Rajasthan. Natural Makeup that allows your skin to breath with a radiant glow and remains flawless throughout your special day.


    Best Makeup and Hairstyle in jaipur
    Fiza Makeup Academy in jaipur
    Best bridal makeup artist in jaipur(bollywood makeup,creative makeup,Airbrush makeup,character makeup)
    Make up and Hair kit
    Professional makeup artist course in jaipur
    Makeup and hairstyle tips
    Makeup and hair Images
    Makeup and hair tutorials
    Makeup and hair contract


    ReplyDelete
  151. I simply couldn’t leave your website before suggesting that I actually loved the usual info you posted is very useful to us thanks for posting this blog.
    Oracle Fusion HCM Technical Training

    ReplyDelete
  152. A pioneer Institute owned by industry professionals to impart vibrant, innovative and global education in the field of Hospitality to bridge the gap of 40 lakh job vacancies in the Hospitality sector. The Institute is contributing to the creation of knowledge and offer quality program to equip students with skills to face the global market concerted effort by dedicated faculties, providing best learning environment in fulfilling the ambition to become a Leading Institute in India.

    cha jaipur
    management college in jaipur
    management of hospitality administration jaipur
    cha management jaipur
    Best hotel college in jaipur
    Best management college in jaipur
    College of Hospitality Administration, Jaipur

    ReplyDelete
  153. ARY News is a wonderful channel always disclose the govt sectors scams without any fear. There are Many channels are in Pakistan but only few are working in right and exact ways. Let's watch ARY News Live channel and
    acknowledge the real truth of Pakistan scams. Make your vision strong for right things and stand together for progress of Pakistan.

    ReplyDelete
  154. ARY News is a wonderful channel always disclose the govt sectors scams without any fear. There are Many channels are in Pakistan but only few are working in right and exact ways. Let's watch ARY News Live channel and
    acknowledge the real truth of Pakistan scams. Make your vision strong for right things and stand together for progress of Pakistan.

    ReplyDelete
  155. Thanks for posting useful information.You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...Really it was an awesome article...very interesting to read..please sharing like this information......
    Web Development Company

    ReplyDelete
  156. Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
    Android training in chennai
    Ios training in chennai

    ReplyDelete
  157. Really it was an awesome article...very interesting to read..You have provided an nice article....Thanks for sharing..
    Web Design Company
    Web Development Company

    ReplyDelete
  158. A Pioneer Institute owned by industry professionals to impart vibrant, innovative and global education in the field of Hospitality to bridge the gap of 40 lakh job vacancies in the Hospitality sector. The Institute is contributing to the creation of knowledge and offer quality program to equip students with skills to face the global market concerted effort by dedicated faculties, providing best learning environment in fulfilling the ambition to become a Leading Institute in India.

    cha jaipur
    hotel management college in jaipur
    management of hospitality administration jaipur
    cha management jaipur
    Hotel management in jaipur
    Best hotel management college in jaipur
    College of Hospitality Administration, Jaipur
    Top 10 hotel management in jaipur
    Hotel management collegein Rajasthan

    ReplyDelete
  159. A Pioneer Institute owned by industry professionals to impart vibrant, innovative and global education in the field of Hospitality to bridge the gap of 40 lakh job vacancies in the Hospitality sector. The Institute is contributing to the creation of knowledge and offer quality program to equip students with skills to face the global market concerted effort by dedicated faculties, providing best learning environment in fulfilling the ambition to become a Leading Institute in India.

    cha jaipur
    hotel management college in jaipur
    management of hospitality administration jaipur
    cha management jaipur
    Hotel management in jaipur
    Best hotel management college in jaipur
    College of Hospitality Administration, Jaipur
    Top 10 hotel management in jaipur
    Hotel management collegein Rajasthan

    ReplyDelete
  160. Good effort. Thanks to shared oracle parallel concurrent details with me.
    Oracle dba training | Oracle dba training syllabus

    ReplyDelete
  161. Thank you Naresh sir for Providing me information about Oracle ... I am getting training for Oracle OAF is it useful for me if i get certified from it

    ReplyDelete
  162. nice blog
    great information
    Cosmetology Course
    Advance Diploma in Cosmetology,Grand Master in Cosmetology,
    Professional Diploma in Cosmetology,International Diploma in Cosmetology.

    ReplyDelete
  163. This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post.

    Best AngularJS Training in Chennai
    Hadoop Training in Chennai
    Big Data Training in Chennai

    ReplyDelete
  164. Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Oracle Fusion Financials Online Training

    ReplyDelete
  165. Get free quotes with low price best packers and movers Delhi process by hassle for header ways. In order to find just indeed right service for proving to moving home and office relocation you to need or get free quotes today with like memory also with compare to decision appears get one ways get rid free completely free hassle and happy or shifting by the folder experience in goods quality for packing with in order your preferred boldest upon estimate of the move to option to approach much better as stance to 3ways directly and known as best trust be pleasure provide do this area calculate the moving stamina rid provide at your preferred top packers and movers in Gurgaon city of the direly point of view about all this.

    http://www.fooglepackers.com/packersmoversdelhi.html

    http://www.fooglepackers.com/packersmoversgurgaon.html

    http://www.fooglepackers.com/

    ReplyDelete