database services

Database services  are logical abstractions for managing workloads in Oracle Database. 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. For example, the Oracle E-Business suite defines a service for each responsibility, such as general ledger, accounts receivable, order entry, and so on. Each database service has a unique name. Connection requests can include a database service name. If no service name is included and the Net Services file listener.ora designates a default service, the connection uses the default service. Services are built into the Oracle Database, providing a single system image for wor...