Oracle Pcp

Powerful Essays
Parallel Concurrent Processing
Mike Swing TruTek mswing@trutek.com RMOUG 2009
1

Conclusions
• You don’t need RAC to use Parallel Concurrent Processing (PCP)! • If you have PCP enabled, secondary nodes must be defined during the upgrade to R12 • Tuning of TCP, SQLNet and PMON parameters can minimize PCP failover time. • Implement Failover Sensitive Workshifts

2

Concurrent Processing Server
Allows scheduling of jobs – batch jobs, or Requests in Oracle terms. Processes concurrent programs as a Request. Requests can be grouped together into Request Sets. Different types of concurrent managers handle different types of requests. A concurrent program can be assigned to a responsibility, and that responsibility can be assigned to users, allowing them the permission to run the concurrent program. Concurrent managers may have limits on the concurrent programs that can be run, and the times that they can be started. Requests have priorities, status and log and out files in the above directory
3

Definitions
• • • • • • • CP => Concurrent Processing DCD => Dead Connection Detection ICM => Internal Concurrent Manager IM => Internal Monitor CRM => Conflict Resolution Manager PCP => Parallel Concurrent Processing PMON => Process Monitor for ICM
4

Concurrent Request

5

Phase and Status of Concurrent Requests
Phase Pending Pending Running Completed Completed Completed Inactive Status Normal Standby Normal Normal Error Warning No Manager Description - Action The request is waiting to be picked up by the next available manager. Waiting for CRM to resolve conflict. CRM could be slow or an incompatible program is running. The request is running normally. The request has finished successfully The request has finished with an error. Check logs. The request has finished with a Warning. Check the logs. Request won’t run without a manager. Specialization rules aren’t configured properly.
6

PCP Failover
•DB Node – RH8
•Database

•RH7

•RH8

•RH9



References: • • • • • • • • • • • • 249213.1 - Performance problems with Failover when TCP Network goes down 364171.1- TAF Session Hangs, Select Fails To Complete W/ Loss Of NIC: Tune TCP Keepalive 211362.1 - Process Monitor Session Cycle Repeats Too Frequently 291201.1 - How To Remove a Dead Connection to the Target Database 362135.1 - Configuring Oracle Applications Release 11i with Oracle10g Release 2 Real Application Clusters and Automatic Storage Management Optimizing the E-Business Suite with Real Application Clusters (RAC) - Ahmed Alomari 240818.1 - Concurrent Processing: Transaction Manager Setup and Configuration Requirement in an 11i RAC Environment R12 ATG - Concurrent Processing Functional Overview – Aaron Weisberg 210062.1 - Generic Service Management (GSM) in Oracle Applications 11i 271090.1 - Parallel Concurrent Processing Failover/Failback Expectations 241370.1 - Concurrent Manager Setup and Configuration Requirements in an 11i RAC Environment 602899.1 - Some More Facts On How to Activate Parallel Concurrent Processing 126

You May Also Find These Documents Helpful

  • Powerful Essays

    Pcp Substance Abuse

    • 2424 Words
    • 10 Pages

    that are not legitimate. See also drug abuse first aid and drug abuse and dependence. Reference from A.D.A.M. ALTERNATIVE NAMES Heroin abuse; Substance abuse; Marijuana abuse; Illicit drug abuse; Narcotic abuse; Cocaine abuse; Hallucinogen abuse; PCP abuse; LSD abuse MARIJUANA About 2 in 5 Americans have used marijuana (also called "grass," "pot," "reefer," "joint," "hashish," "cannabis," "weed,"…

    • 2424 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    Oracle

    • 5656 Words
    • 23 Pages

    Oracle - Oracle- Database Management System Data management is an extraordinarily old craft. Aristotle 's scheme of interlocking classifications of knowledge in his work Physica is a data-management effort. In the early 1800s the Jacquard loom used holes punched in paper cards to represent instructions for controlling the action of a loom. These cards became the basis for Herman Hollerith’s card-sorting device, used for the 1890 U.S. census http://80-gme.grolier.com.ezproxy.apollolibrary.com. Many…

    • 5656 Words
    • 23 Pages
    Good Essays
  • Good Essays

    Oracle

    • 503 Words
    • 3 Pages

    1. What assumptions underlie Oracle’s recognition of revenue for license fee. Are these assumptions reasonable given the firm’s business and operating policies? Oracle recognized its license fee either upon shipment of the product or at the time such agreements are effective. In most instance is this the date of the agreement. The assumptions underlying this method is that if the customer is creditworthy and the terms of the agreement are such that the amounts are due within one year and are non-refundable…

    • 503 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    oracle

    • 3885 Words
    • 16 Pages

    ORACLE 10g ASM May 17th, 2006 Inderpal S. Johal Principal Consultant Agenda What is ASM Benefits of ASM ASM Architecture ASM Components DB Instance parameters to support ASM ASM Instance Monitoring using EM ASM Views Migrating from File system to ASM Miscellaneous Tips Q&A Data Softech Inc. Oracle 10g ASM 2 What is ASM ASM stands for Automatic Storage Management It is Oracle Cluster File System and Volume Manager Designed for Oracle Database Related Files Provide…

    • 3885 Words
    • 16 Pages
    Satisfactory Essays
  • Powerful Essays

    Oracle

    • 32236 Words
    • 129 Pages

    Introduction to Oracle9i: SQL Instructor Guide • Volume 1 40049GC11 Production 1.1 October 2001 D33993 Authors Copyright © Oracle Corporation, 2000, 2001. All rights reserved. Nancy Greenberg Priya Nathan This documentation contains proprietary information of Oracle Corporation. It is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverse engineering of the software is prohibited. If this documentation…

    • 32236 Words
    • 129 Pages
    Powerful Essays
  • Better Essays

    PCP: Angel Dust

    • 1182 Words
    • 5 Pages

    PCP: Angel Dust Hallucinogens include drugs that are fascinating yet have alarming effects on a user. According to Gaines and Kremling (2014), “In contrast to antidepressants that make the neurotransmitter serotonin linger in the gaps between brain cells, hallucinogens push the serotonin system into overdrive. Hallucinogens amplify signals from a person’s sensory perception, distorting form and size. Users often talk about “seeing sounds,” or “hearing visual stimuli” (p. 129-130).” Hallucinogens…

    • 1182 Words
    • 5 Pages
    Better Essays
  • Good Essays

    kown as (PCP) Phencylidine is a central nervous system depressant, introduced as an anesthetic in the early 1950s but later abandoned because of unpredictable side effects such as agitation, disorientation, and hallucination. The drug is easily synthesized by anyone with a basic knowledgeof chemistry and has become one of the drugs most frequently used by drug abusers. Examples of the drug is: Angel Dust, Ecstasy, LCD, Peyote, and Mescaline The short term effects of this drug: PCP can cause…

    • 533 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    PCP course notes

    • 297 Words
    • 1 Page

    to PCP seems to be low, the substance is still commonly abused and extremely dangerous. Another substance that is included in this video because of the effects and danger is ketamine. PCP is classified alone because of how different the substance effects the users. Unlike other substances, PCP disrupts many more neurotransmitter than any other single substance. It is important when working with clients to be aware of the damages that could be done by use, as well as signs of use. When on PCP individuals…

    • 297 Words
    • 1 Page
    Satisfactory Essays
  • Powerful Essays

    Oracle

    • 7272 Words
    • 30 Pages

    Corporation. ® ® ® ® ® ® ® ® ® IBM , DB2 , OS/2 , DB2/6000 , Parallel Sysplex , MVS/ESA , RS/6000 , AIX , S/390 , ® ® ® AS/400 , OS/390 , and OS/400 are registered trademarks of IBM Corporation. ® ORACLE is a registered trademark of ORACLE Corporation. ® ® INFORMIX -OnLine for SAP and Informix Dynamic Server Informix Software Incorporated. ® ® ® TM are registered trademarks of ® UNIX , X/Open , OSF/1 , and Motif are registered trademarks…

    • 7272 Words
    • 30 Pages
    Powerful Essays
  • Good Essays

    Oracle

    • 677 Words
    • 3 Pages

    How is the IKEA operations design different from that of most furniture retail operations? IKEA is known as one of the world’s largest furniture retailer that focuses highly on cost control, operational process and product development. IKEA differentiates itself from most furniture retailers by offering a wide range of well designed array of home furniture at very attractive prices that remain affordable to a large group of diverse customers. There are some unique features of IKEA as compared…

    • 677 Words
    • 3 Pages
    Good Essays