Configuring Services - Describe applications, Application functions & data ranges - Oracle DBA

Discussion

• Nirja Shah   -Posted on 26 Aug 15
  -Services are logical abstractions for managing workloads in Oracle Database 10g.
  -Services divide workloads into mutually disjoint groupings.
  -Each service represents a workload with common attributes, service-level thresholds, and priorities.
  -The grouping is based on attributes of work that might include the application function to be used, the priority of execution for the application function, the job class to be managed, or the data range used in the application function or job class.
  
  -Oracle Database 10g gives us three types of services which are as follows:
  
  - Configuring Services - Services describe applications, application functions, and data ranges as either functional services or data-dependent services.
  -Functional services are the most common mapping of workloads. Sessions using a particular function are grouped together.
  -For Oracle*Applications, ERP, CRM, and iSupport functions create a functional division of the work.
  -For SAP, dialog and update functions create a functional division of the work.
  
  - Deploying Services - Installations configure Oracle Database 10g services in the database giving each service a unique global name, associated performance goals, and associated importance.
  -The services are tightly integrated with the Oracle Database and are maintained in the data dictionary.
  
  - Using Services - Using services requires no changes to your application code.
  -Client-side work connects to a service. Server-side work specifies the service when creating the job class for the Job Scheduler and the database links for distributed databases.
  -Work requests executing under a service inherit the performance thresholds for the service and are measured as part of the service.

➨ Post your comment / Share knowledge