Oracle英文版培训课件之RAC for Administrators：07-services

ServicesObjectivesAftercompletingthislesson,youshouldbeableto:ConfigureandmanageservicesinaRACenvironmentUseserviceswithclientapplicationsUseserviceswiththeDatabaseResourceManagerUseserviceswiththeSchedulerSetperformance-metricthresholdsonservicesConfigureservicesaggregationandtracingTraditionalWorkloadDispatchingHRDWCRMBatchDaytimeHRDWCRMBatchHolidayseasonHRDWCRMBatchPaydayGridWorkloadDispatchingDaytimeHolidayseasonPaydayHRDWCRMBatchIdleCRMBatchHRCRMHRIdleBatchDWIdleDWDataWarehouse:ExampleETLDBEUT11:00p.m.ETLDBEUT3:00a.m.ETLDBEUT9:00a.m.RACandDataWarehouse:AnOptimalSolutionMaximumtotalworkloadusedforsystemsizing:Size(Workloadmaxtotal)<Size(workloadmaxcomponents)Theentireworkloadisevenlyspreadacrossallnodesatanypointintime.ETLDBEUTNextStepETLDBEUTETLDBEUTWhatworksforasingledatawarehouse……worksinalargerenvironmentaswell.WhatIsaService?IsameansofgroupingsessionsthataredoingthesamekindofworkProvidesasingle-systemimageinsteadofamultiple-instancesimageIsapartoftheregularadministrationtasksthatprovidedynamicservice-to-instanceallocationIsthebaseforHighAvailabilityofconnectionsProvidesanewperformance-tuningdimensionHighAvailabilityofServicesinRACServicesareavailablecontinuouslywithloadsharedacrossoneormoreinstances.Additionalinstancesaremadeavailableinresponsetofailures.Preferredinstances:SettheinitialcardinalityfortheserviceArethefirsttostarttheserviceAvailableinstancesareusedinresponsetopreferred-instancefailures.PossibleServiceConfigurationwithRACAPRAC01RAC02RAC03GLAPGLAPRAC01RAC02RAC03GLAPGLAPGLAPRAC01RAC02RAC03GLAPGLAPGLActive/spareActive/symmetricActive/asymmetricServiceAttributesGlobaluniquenameNetworknameLoadBalancingAdvisorygoal*Distributedtransactionsflag*AdvancequeuingnotificationcharacteristicsforOCIandODP.NETclients*Failovercharacteristics*Connectionload-balancingalgorithm*ThresholdPriorityHigh-availabilityconfiguration*ServiceTypesApplicationservices:Limitof100servicesperdatabaseInternalservices:SYS$BACKGROUNDSYS$USERSCannotbedeletedorchangedServiceGoodnessValuethatreflectstheabilityofanodeandinstancetodeliverworkforaserviceAppropriatemetricsusedtocomputegoodnessdependingontheservicegoal:ServicetimeServicethroughputAutomaticallycomputedateachinstancebyMMNLCreateServiceswiththeDBCACreateServiceswiththeDBCATheDBCAconfiguresboththeOracleClusterwareresourcesandtheNetServiceentriesforeachservice.CreateServiceswithEnterpriseManagerCreateServiceswithSRVCTL$srvctladdservice–dPROD–sGL-rRAC02-aRAC01$srvctladdservice–dPROD–sAP

–rRAC01-aRAC02APRAC01GLAPRAC02GLPreferredandAvailableInstances$srvctladdservice–dPROD–sERP\

–rRAC01,RAC02-aRAC03,RAC04ERPERPERPERPRAC01RAC02RAC03RAC04ERPERPERPERPRAC01RAC02RAC03RAC04ERPERPERPERPRAC01RAC02RAC03RAC04ERPERPERPERPRAC01RAC02RAC03RAC041234ModifyServiceswiththeDBMS_SERVICEPackageModifyaserviceinRACwiththefollowing:DatabaseConfigurationAssistant(DBCA),SRVCTLEnterpriseManagerDBMS_SERVICE.MODIFY_SERVICEexecDBMS_SERVICE.MODIFY_SERVICE('SELF-SERVICE','SELF-SERVICE.',goal=>DBMS_SERVICE.GOAL_SERVICE_TIME,clb_goal=>DBMS_SERVICE.CLB_GOAL_SHORT);EverythingSwitchestoServicesDatadictionarymaintainsservices.TheAWRmeasurestheperformanceofservices.TheDatabaseResourceManagerusesservicesinplaceofusersforpriorities.Jobscheduler,ParallelQuery(PQ),andStreamsqueuesrununderservices.RACkeepsservicesavailablewithinasite.DataGuardBrokerwithRACkeepsprimaryservicesavailableacrosssites.UseServiceswithClientApplicationsERP=(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=node-1vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=node-2vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=node-3vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=node-4vip)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ERP)))url="jdbc:oracle:oci:@ERP"url="jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=node-1vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=node-2vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=node-3vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=node-4vip)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ERP)))"UseServiceswiththeResourceManagerConsumergroupsareautomaticallyassignedtosessionsbasedonsessionservices.Workisprioritizedbyserviceinsideoneinstance.APInstanceresourcesBATCH75%25%APBATCHConnectionsServicesandResourceManagerwithEMServicesandtheResourceManager:ExampleexecDBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA;execDBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(CONSUMER_GROUP=>'HIGH_PRIORITY',COMMENT=>'Highpriorityconsumergroup');execDBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING(ATTRIBUTE=>DBMS_RESOURCE_MANAGER.SERVICE_NAME,VALUE=>'AP',CONSUMER_GROUP=>'HIGH_PRIORITY');execDBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA;exec-DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(-GRANTEE_NAME=>'PUBLIC',CONSUMER_GROUP=>'HIGH_PRIORITY',GRANT_OPTION=>FALSE);UseServiceswiththeSchedulerServicesareassociatedwithSchedulerclasses.Schedulerjobshaveserviceaffinity:HighAvailabilityLoadbalancingDatabaseJob1HOT_BATCH_CLASSHOT_BATCH_SERVJobtableJob2HOT_BATCH_CLASSHOT_BATCH_SERVJob3LOW_BATCH_CLASSLOW_BATCH_SERVHOT_BATCH_SERVJobcoordinatorJobslavesHOT_BATCH_SERVJobcoordinatorJobslavesLOW_BATCH_SERVJobcoordinatorJobslavesServicesandtheSchedulerwithEMServicesandtheSchedulerwithEMServicesandtheScheduler:ExampleDBMS_SCHEDULER.CREATE_JOB_CLASS(JOB_CLASS_NAME=>'HOT_BATCH_CLASS',RESOURCE_CONSUMER_GROUP=>NULL,SERVICE=>'HOT_BATCH_SERV',LOGGING_LEVEL=>DBMS_SCHEDULER.LOGGING_RUNS,LOG_HISTORY=>30,COMMENTS=>'P1batch');DBMS_SCHEDULER.CREATE_JOB(JOB_NAME=>'my_report_job',JOB_TYPE=>'stored_procedure',JOB_ACTION=>'my_name.my_proc();',NUMBER_OF_ARGUMENTS=>4,START_DATE=>SYSDATE+1,REPEAT_INTERVAL=>5,END_DATE=>SYSDATE+30,JOB_CLASS=>'HOT_BATCH_CLASS',ENABLED=>TRUE,AUTO_DROP=>false,COMMENTS=>'dailystatus');UseServiceswithParallelOperationsSlavesinherittheservicefromthecoordinator.Slavescanexecuteoneveryinstance.ERPExecutioncoordinatorParallelExecutionserverShareddisksNode4Node1Node2Node3ERPERPERPERPERPERPERPERPUseServiceswithMetricThresholdsYoucandefineservice-levelthresholds:ELAPSED_TIME_PER_CALLCPU_TIME_PER_CALLServer-generatedalertsaretriggeredonthresholdviolations.Youcanreactongeneratedalerts:Changepriority.Relocateservices.Addinstancesforservices.SELECTservice_name,elapsedpercall,cpupercallFROMV$SERVICEMETRIC;ChangeServiceThresholdsbyUsingEMServicesandMetricThresholds:ExampleThresholdsmustbesetoneachinstancesupportingtheservice.execDBMS_SERVER_ALERT.SET_THRESHOLD(-METRICS_ID=>dbms_server_alert.elapsed_time_per_call,WARNING_OPERATOR=>dbms_server_alert.operator_ge,WARNING_VALUE=>'500000',CRITICAL_OPERATOR=>dbms_server_alert.operator_ge,CRITICAL_VALUE=>'750000',OBSERVATION_PERIOD=>15,CONSECUTIVE_OCCURRENCES=>3,INSTANCE_NAME=>'I0n',OBJECT_TYPE=>dbms_server_alert.object_type_service,OBJECT_NAME=>'ERP');ServiceAggregationandTracingStatisticsarealwaysaggregatedbyservicetomeasureworkloadsforperformancetuning.Statisticscanbeaggregatedatfinerlevels:MODULEACTIONCombinationofSERVICE_NAME,MODULE,ACTIONTracingcanbedoneatvariouslevels:SERVICE_NAMESMODULEACTIONCombinationofSERVICE_NAME,MODULE,ACTIONThisisusefulfortuningsystemsthatusesharedsessions.TopServicesPerformancePageServiceAggregationConfigurationAutomaticserviceaggregationlevelofstatisticsDBMS_MONITORusedforfinergranularityofserviceaggregations:SERV_MOD_ACT_STAT_ENABLESERV_MOD_ACT_STAT_DISABLEPossibleadditionalaggregationlevels:SERVICE_NAME/MODULESERVICE_NAME/MODULE/ACTIONTracingservices,modules,andactions:SERV_MOD_ACT_TRACE_ENABLESERV_MOD_ACT_TRACE_DISABLEDatabasesettingspersistacrossinstancerestarts.ServiceAggregation:ExampleCollectstatisticsonserviceandmodule:Collectstatisticsonservice,module,andaction:Traceallsessionsofanentireservice:Traceonservice,module,andaction:execDBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE(-'AP','PAYMENTS');execDBMS_MONITOR.SERV_MOD_ACT_STAT_ENABLE(-'AP','PAYMENTS','QUERY_DELINQUENT');execDBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE('AP');execDBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(-'AP','PAYMENTS','QUERY_DELINQUENT');trcsessUtilityClientDedicated

serverTrace

fileClientsShared

serverTrace

fileShared

serverTrace

fileShared

serverTrace

fileClientDedicated

serverTrace

fileTRCSESSTracefile

foroneclientTKPROFReport

fileTRCSESSTracefile

forCRMserviceClientDedicated

serverTrace

fileCRMERPCRMCRMERPCRMServicePerformanceViewsService,module,andactioninformationin:V$SESSIONV$ACTIVE_SESSION_HISTORYServiceperformancein: V$SERVICE_STATSV$SERVICE_EVENTV$SERVICE_WAIT_CLASSV$SERVICEMETRICV$SERVICEMETRIC_HISTORYV$SERV_MOD_ACT_STATSDBA_ENABLED_AGGREGATIONSDBA_ENABLED_TRACESTwenty-eightstatisticsforservicesGeneralizedTraceEnablingForallsessionsinthedatabase:Foraparticularsession:EXECdbms_monitor.DATABASE_TRACE_ENABLE(TRUE,TRUE);EXECdbms_monitor.DATABASE_TRACE_DISABLE();EXECdbms_monitor.SESSION_TRACE_ENABLE(session_id=>27,serial_num=>60,waits=>TRUE,binds=>FALSE);EXECdbms_monitor.SESSION_TRACE_DISABLE(session_id=>27,serial_num=>60);ManageServicesUseEMorSRVCTLtomanageservices:Start:AllowconnectionsStop:PreventconnectionsEnable:AllowautomaticrestartandredistributionDisable:PreventstartingandautomaticrestartRelocate:TemporarilychangeinstancesonwhichservicesrunModify:ModifypreferredandavailableinstancesGetstatusinformationAddorremoveUsetheDBCA:AddorremoveModifyservicesManageServiceswithEnterpriseManagerManageServiceswithEMManageServices:ExampleStartanamedserviceonallpreferredinstances:Stopaserviceonselectedinstances:Disableaserviceatanamedinstance:Setanavailableinstanceasapreferredinstance:$srvctlstartservice–dPROD–sAP$srvctlstopservice–dPROD–sAP–iRAC03,RAC04$srvctldisableservice–dPROD–sAP–iRAC04$srvctlmodifyservice–dPROD–sAP-iRAC05–rManageServices:ScenarioDWHRHolidayseasonPaydayDW