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.




219 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 in Chennai website where someone please help me to identity the syllabus covers everything or not??

    Thanks, abinaya

    ReplyDelete
  4. 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
  5. 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
  6. 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
  7. This comment has been removed by the author.

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

    ReplyDelete
  9. 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
  10. 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
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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

  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
  21. 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
  22. 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
  23. 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
  24. 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
  25. There are lots of information about latest technology and how to get trained in them, like Hadoop Training 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..

    ReplyDelete
  26. 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
  27. 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
  28. 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
  29. It is really very helpful for us and I have gathered some important information from this blog.Oracle Training In Chennai

    ReplyDelete
  30. 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
  31. 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
  32. Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision.
    Informatica Training In Chennai

    ReplyDelete
  33. 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
  34. 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
  35. 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
  36. Greens Technologies Training In Chennai Excellent information with unique content and it is very useful to know about the information based on blogs.

    ReplyDelete
  37. 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
  38. Thank you for the useful article. It has helped a lot in training my students. Keep writing more.
    big data training Chennai

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

    Selenium Training

    Solaris Training

    ReplyDelete
  40. 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
  41. 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
  42. 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
  43. Selenium Training in Chennai
    Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

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

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

    ReplyDelete
  46. 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
  47. 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..
    Unix Training In Chennai

    ReplyDelete
  48. 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
  49. 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
  50. Thanks for the article. It has given me so much information that I shared with my students in the class. Come up with more such articles.
    Shashaa
    Dot Net training Chennai | Dot Net training Chennai | Dot Net training Chennai

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

    ReplyDelete
  52. 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
  53. 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
  54. Amazing blog if our training additional way as an silverlight training trained as individual, you will be able to understand other applications more quickly and continue to build your skill set which will assist you in getting hi-tech industry jobs as possible in future courese of action..visit this blog
    silverlight-training.html
    greenstechnologies.in:

    ReplyDelete
  55. 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
  56. 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
  57. 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

  58. 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
  59. 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
  60. 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
  61. 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
  62. In database computing, Oracle Real Application Clusters (RAC) — an option for the Oracle Database software produced by Oracle Corporation and introduced in 2001 with Oracle9i — provides software for clustering and high availability in Oracle database environments. Oracle Corporation includes RAC with the Standard Edition, provided the nodes are clustered using Oracle Clusterware.
    Oracle RAC allows multiple computers to run Oracle RDBMS software simultaneously while accessing a single database, thus providing clustering.

    In a non-RAC Oracle database, a single instance accesses a single database. The database consists of a collection of data files, control files, and redo logs located on disk. The instance comprises the collection of Oracle-related memory and operating system processes that run on a computer system.

    Oracle RAC Training in Chennai

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

    http://www.buycrazybulks.com/

    ReplyDelete
  64. 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
  65. 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
  66. 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
  67. The information you posted here is useful to make my career better keep updates http://www.buycrazybulks.com/

    ReplyDelete
  68. 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
  69. I think comments can help you get feedback from your readers .Crazy Bulk

    ReplyDelete
  70. 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
  71. 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
  72. 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
  73. 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
  74. 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
  75. Haryana HSSC Steno Typist Recruitment 2016

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

    ReplyDelete
  76. Naval Dockyard Visakhapatnam Tradesman Skilled Recruitment 2016

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

    ReplyDelete
  77. 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
  78. Such a informative post.Thanks for sharing your knowledge with us.keep it up for updating post..
    http://sonymobileservicecenterinchennai.in/AboutUs.html

    ReplyDelete
  79. 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..
    Informatica Training In Chennai
    Hadoop Training In Chennai
    Oracle Training In Chennai
    Pega Training In Chennai
    Hadoop Training In Chennai

    ReplyDelete
  80. 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
  81. Really awesome blog. Your blog is really useful for me.
    Thanks for sharing this informative blog. Keep update your blog.
    Oracle Training In Chennai

    ReplyDelete
  82. 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
  83. 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
  84. This post is really nice and informative. The explanation given is really comprehensive and informative..
    SAS Training In Chennai

    ReplyDelete
  85. christian fellowship programs The C.S. Lewis Institute was founded in 1976 and endeavors, in the legacy of C.S. Lewis, to develop disciples who will articulate, defend and live their faith in Christ in personal and public life

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

    ReplyDelete
  87. 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
  88. 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
  89. 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
  90. 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

  91. 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
  92. Thank you for this list, I found a lot of interesting things. I also learn some advance about
    hadoop training in Chennai

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

    IELTS classes in Kuwait

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

    ReplyDelete
  95. 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
  96. Nice information about the oracle dba. Thanks for sharing. Join our Cloud Computing Training in Chennai

    ReplyDelete
  97. 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
  98. 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
  99. 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
  100. 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
  101. 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
  102. 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
  103. 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
  104. without parallel processing no pcs are working. here explains the details of basic question and answers of parallel processing.VMWare Training in Chennai

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

    sharepoint-developer-training in chennai

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

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

    ReplyDelete
  108. 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
  109. 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
  110. 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
  111. You have explained about Oracle E bossiness.Its very interesting.Thanks for updating new things like this..
    linux training in chennai

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

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

    ReplyDelete
  114. 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
  115. informative blog.... keep blogging like this....CCNA Training in Chennai

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

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

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

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

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

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

    web design training institute in Chennai

    ReplyDelete
  122. 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
  123. 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
  124. 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


  125. 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

  126. 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
  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. That is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.


    PHP training in Adyar

    ReplyDelete
  129. 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
  130. 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
  131. 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
  132. 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
  133. 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
  134. 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
  135. 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
  136. 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
  137. 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
  138. Great post. Happy to visit your blog. Thanks for sharing.

    php training in chennai

    ReplyDelete

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


    ReplyDelete

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

    Android Training in Chennai

    ReplyDelete
  141. Rolex Watches Authentic Mens & Ladies Rolex Datejust, President Watches for Sale at JavyEstrella.com.

    ReplyDelete
  142. 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
  143. 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
  144. This comment has been removed by the author.

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

    ReplyDelete
  146. 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
  147. Great post. It really helped me to learn something new. So thanks.
    php training in Bangalore

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

    Manshu Ydoxy
    Founder at www.ydoxy.com

    ReplyDelete
  149. Nice article
    Thanks for sharing the informative blog.
    Linux training in Bangalore

    ReplyDelete
  150. 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
  151. This is my first visit to your blog, your post made productive reading, thank you. dot net training in chennai

    ReplyDelete
  152. 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
  153. 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
  154. 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
  155. 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