ORACLEEBS并发管理器

.关于OracleE-BusinessSuite并发处理机制（CurrentProcessing）2015-01-2114:052352人阅读评论(0)收藏举报分类：OracleEBS（48）OracleEBSConcurrentProgram（15）版权声明：转载请以链接形式注明出处2012年写过一篇关于OracleE-BusinessSuite并发管理器的文章，回头看之前总结的 内容 财务内部控制制度的内容财务内部控制制度的内容人员招聘与配置的内容项目成本控制的内容消防安全演练内容 还是比较单薄，很多点没说到，最近在看这块的内容，索性再写一篇稍微完整的文章来。OracleE-BusinessSuite并发处理机制（CurrentProcessing）的好处区别于普通功能的处理机制，并发处理机制其实是一个异步处理机制，它把程序放到后台来运行，前台的操作还给用户，允许用户可以继续做其他业务。技术上将，异步处理的好处是降低系统特定时间点的负载，提升系统资源的整体使用率。感受上讲，异步的机制可以有效提升整体的使用感受，减少用户无效的等待时间。什么样的程序可以用并发机制来处理报表类..报表是一种非常个性化的东西，一般也是每家公司客户化最多的部分，如果为报表需求都开发不同的列表界面来查询、展示，那么工作量将是巨大的。所以Oracle把报表嵌入到并发处理中，通过一些灵活的配置或少量的开发（Reports/BIPublisherReports）既可以实现用户各类报表的需求. 流程 快递问题件怎么处理流程河南自建厂房流程下载关于规范招聘需求审批流程制作流程表下载邮件下载流程设计 类多用于批量事务处理，或是长时间运行的业务，如库存管理器批量处理接口表中的临时事务。并发处理机制（CurrentProcessing）的两类组件并发处理机制（CurrentProcessing）包括两类组件：并发管理器（ConcurrentManagers）并发请求（ConcurrentRequests）像公司中“经理”一样，Manager给Worker安排任务，Worker负责具体的执行。OracleEBS中的ConcurrentManagers就是负责安排工作，ConcurrentRequests负责具体的执行。并发管理器（ConcurrentManagers）的分类一家企业一般都有许多的经理，有着高低之分，总裁、总监、经理、主管....OracleEBS这家企业中，同样也有着许多不同层面上的ConcurrentManager，有核心的ConcurrentManagers管理团队（InternalConcurrentManager、StandardManager、ConflictResolutionMananger），也有普通ConcurrentManagers。核心的ConcurrentManagers团队管理下边普通ConcurrentManagers。核心的三个并发管理器：InternalConcurrentManager（内部管理器）—ThemastermanageriscalledtheInternalConcurrentManager(ICM)becauseitcontrolsthebehaviorofalloftheothermanagers,andbecausetheICMistheboss,itmustberunningbeforeanyothermanagerscanbeactivated.ThemainfunctionsoftheICMaretostart..upandshutdowntheindividualconcurrentmanagers,andresettheothermanagersafteronethemhasafailure.StandardManager（标准管理器）—AnotherimportantmasterConcurrentManageriscalledtheStandardManager(SM).TheSMfunctionstorunanyreportsandbatchjobsthathavenotbeendefinedtoruninanyspecificproductmanager.ExamplesofspecificconcurrentmanagersincludetheInventoryManager,CRPInquiryManager,andtheReceivablesTaxManager.Itisnotrecommendedtoaddspecializationrulestothestandardmanagerasitcancauseproblems.ConflictResolutionManager（冲突解决管理器）—TheConflictResolutionManager(CRM)functionstocheckconcurrentprogramdefinitionsforincompatibilityrules.However,theICMcanbeconfiguredtotakeovertheCRM'sjobtoresolveincompatibilities.小结：InternalConcurrentManager是管理器中的BOSS，总负责人，控制着其他并发管理器的运作。StandardMananger是标准管理器，没有纳入其他特定管理器（SpecificConcurrentManagers）的请求，默认就会由标准管理器管理。ConflictResolutionManager主要用于处理日程冲突。2.特定用途的并发管理器（SpecificConcurrentManagers，SCM）除了上边说的三个核心并发管理器，还有众多的特定用途的并发管理器，如库存管理员（InventoryManager），接收事务处理管理器（ReceivingTransactionManager），MRPManager，以及用户自定义的并发管理器。并发管理器是如何管理并发请求的并发请求从提交到运行大概的过程是这样的：用户首先提交并发程序运行请求，并发请求会首先放入请求队列中，再由InternalConcurrentManager根据特定的 规则 编码规则下载淘宝规则下载天猫规则下载麻将竞赛规则pdf麻将竞赛规则pdf 找到对应的ConcurrentManager（是StandardManager，还是特定的并发管理器）来运行这些请求。下图为一个典型的并发管理器管理并发请求的流程图：..并发管理器的定义并发管理器（ConcurrentManager）=参数（缓存大小、节点设置...)+特殊规则SpecializationRules）+工作班次(WorkShifts)并发管理器的定义路径：系统管理员职责->并发->经理->定义，定义过程也可以参考官方文档：Link。以InventoryManager为例，下图为库存管理器的定义界面。..CacheSize：这个数字表示并发管理器每次读取多少请求来运行。Enterthenumberofrequestsyourmanagerrememberseachtimeitreadswhichrequeststorun.Forexample,ifamanager'sworkshifthas1targetprocessandacachevalueof3,itwillreadthreerequests,andtrytorunthosethreerequestsbeforereadinganynewrequests.Tip:Enteravalueof1whendefiningamanagerthatrunslong,time-consumingjobs,andavalueof3or4formanagersthatrunsmall,quickjobs.Node：这个是并发管理器负载均衡的设置，即ParallelConcurrentProcessing（PCP）。如果服务器是多节点的，那么可以在这里设定并发管理器以哪个节点为主节点运行，哪个节点为辅节点。Ifyouareoperatinginaparallelconcurrentprocessingenvironmentandyouwantyourmanagertooperateonaspecificnode,selectthenameofthenode.Theprimarynode,ifavailable,isthenodeyourconcurrentmanageroperateson.Iftheprimarynodeorthedatabaseinstanceonitgoesdown,yourconcurrentmanagermigrates..toitssecondarynode.Yourconcurrentmanagermigratesbacktoitsprimarynodewhenthatnodebecomesavailable.特殊规则(SpecializationRules)中设定并发管理要包括/排除的并发请求。工作班次（WorkShifts）中赋予InventoryManager并发管理器的运行班次(WorkShift)，运行班次决定了并发管理什么日子、什么时间来运行。..流程(Processes)：这个字段OracleEBS中文翻译的有问 题 快递公司问题件快递公司问题件货款处理关于圆的周长面积重点题型关于解方程组的题及答案关于南海问题 ，官方翻译成“流程”，我觉翻译成“进程”更好，这个参数表示，对于每个班次，ConcurrentManager能够调用最大操作系统层的进程数量来并发处理请求。休眠秒(SleepSeconds)：表示班次间的间隔时间。Thesleeptimeforyourmanagerduringthisworkshift.Sleeptimeisthenumberofsecondsyourmanagerwaitsbetweencheckingthelistofpendingconcurrentrequests(concurrentrequestswaitingtobestarted).Tip:Setthesleeptimetobeverybriefduringperiodswhenthenumberofrequestssubmittedisexpectedtobehigh.OracleEBS并发管理器性能调优的最佳实践一、调整并发参数-SleepSeconds-CacheSize-Purging-GatherSchemaStatistics二、负载调整-SpecializedConcurrentmanagers三、OutputPostProcessor–OPP-JavaHeapSize四、TuningPCP/RAC五、TransactionManagers详情可以参考以下文档：BestPracticesforPerformanceforConcurrentManagersinE-BusinessSuite(DocID1057802.1)EBS-TechnologyArea-WebcastRecording'E-BusinessSuite-ConcurrentManagerPerformance-BestPractices'[video](DocID1367676.1)..Specialized/DedicatedConcurrentManagers(EnhancingPerformance)ConcurrentmanagerinOracleAppsBestPracticesforPerformanceforConcurrentManagersinE-BusinessSuiteInsidetheOracleConcurrentManager如何判断并发管理器是否正常运行系统管理员职责，Concurrent->Managers->Administer，如果Target和Actual相等，并且都大于0，则表示并发管理器为启动和运行状态。TheTargetcolumnliststhenumberofprocessesthatshouldberunningforeachmanagerforthisparticularworkshift.TheActualcolumnliststhenumberofprocessesthatareactuallyrunning.IftheActualcolumniszero,therearenoprocessesrunningforthismanager.IftheTargetcolumniszero,theneitheraworkshifthasnotbeenassignedtothismanager,orthecurrentworkshiftdoesnotspecifyanytargetprocesses.Ifthetargetcolumnisnotzero,thenthemanagerprocesseshaveeitherfailedtostartup,orgonedown.Oneshouldcheckthemanager'slogfileandtheICMlogfile.OnecanalsosearchforOSprocessesusingthe'ps'command.Itispossiblefortheformtobeinaccurate,..i.e.itmayshowactualprocesseseventhoughtheyarenotreallyrunning.Whenindoubt,checkforprocessesattheOSlevel.操作系统下如何检查ConcurrentMananger的运行情况FNDLIBR进程是否启动，这个表示InternalConcurrentManager进程是否运行FNDLIBR:ConcurrentManagerps-ef|grepFNDLIBRFNDLIBRprocessindicatesthatconcurrentmnagersareupandrequestsarerunningonthesystem.Sometimesithappensthatevenafterstoppingtheconcurrentmanagersbyadcmctl.shstopapps/appssomeoftherequestsmightcontinuerunning.Insuchcasesyoucanwaitforsay5minutesandthenifitdosnotstopthenyoucankillthoseFNDLIBRprocessesbykill-9其他ApplicationConcurrentManagerINVLIBRistheprocessforthefollowingManagersManagertorunImmediateConcurrentProgramsdefinedinINVLIBR..[oracle@bej301441~]$ps-ef|grepINVLIBRoracle711170040Jul03?00:00:07INVLIBRoracle1401613573019:40pts/500:00:00grepINVLIBR[oracle@bej301441~]$MRCLIBistheprocessforthefollowingManagersMRPManager[oracle@bej301441~]$ps-ef|grepMRCLIBoracle711370040Jul03?00:00:06MRCLIBoracle1402413573019:40pts/500:00:00grepMRCLIB[oracle@bej301441~]$PALIBRistheprocessforthefollowingManagersPAStreamlineManager[oracle@bej301441~]$ps-ef|grepPALIBRoracle711070040Jul03?00:00:06PALIBRoracle1400313573019:39pts/500:00:00grepPALIBR[oracle@bej301441~]$并发管理器/并发请求的日志在哪里？可参考MetalinkNote105133.1：ConcurrentProcessing-ConcurrentManagerGenericPlatformQuestionsandAnswersWheredoconcurrentrequestormanagerlogfilesandoutputfilesgo?Whatarethelogfileandoutputfilenamingconventions?..CurrentProcessingTables表 说明 关于失联党员情况说明岗位说明总经理岗位说明书会计岗位说明书行政主管岗位说明书 FND_CONCURRENT_REQUESTSDetailsofuserrequests,includingstatus,startdate,andcompletiondateDetailsofconcurrentprograms,includingexecutionmethod,whethertheprogramisconstraFND_CONCURRENT_PROGRAMSberunalone.FND_CONCURRENT_PROCESSESCross-referencesbetweenconcurrentrequestsandqueues,andahistoryofconcurrentmanaFND_CONCURRENT_QUEUESInformationabouteachoftheconcurrentmanagerqueues也可以参考我之前的一篇文章：Oracle原厂提供并发相关的脚本-$FND_TOP/sqlScripts..afimchk.sql-TellsthestatusoftheICMafcmstat.sql-Listsactivemanagerprocessesafrqrun.sql-Listsalltherunning,waitingandTerminatingrequestsafrqwait.sql-ListsrequeststhatareconstrainedandwaitingfortheICMtoreleasethem.afrqscm.sql-Printslogfilenameofmanagersthatcanrunagivenrequest.afcmcreq.sql-Printsthelogfilenameofthemanagerthatprocessedtherequestafrqstat.sql-Summaryofcompletedconcurrentrequestsgroupedbycompletionstatusandexecutiontype..afimlock.sql-ListslocksthattheICMiswaitingtogetafcmrrq.sql-Listsmanagersthatcurrentlyarerunningarequest运行步骤：1.sqlplusapps/apps@instance2.SQL>@$FND_TOP/sql/afimchk.sql参考Specialized/DedicatedConcurrentManagers(EnhancingPerformance)ConcurrentmanagerinOracleAppsConcurrentManagersWindowBestPracticesforPerformanceforConcurrentManagersinE-BusinessSuite(DocID1057802.1)BestPracticesforPerformanceforConcurrentManagersinE-BusinessSuiteEBS-TechnologyArea-WebcastRecording'E-BusinessSuite-ConcurrentManagerPerformance-BestPractices'[video](DocID1367676.1)ConcurrentManagerQuestionsandAnswersRelatingtoGenericPlatform[ID105133.1]BasicinformationaboutConcurrentManagers(DocID69336.1)ConcurrentProcessing-ConcurrentManagerGenericPlatformQuestionsandAnswers(DocID105133.1).