Wednesday, 11 October 2017

What Is Oracle Database QoS Management

Oracle Database QoS Management is an automated, policy-based product that monitors the workload requests for an entire system. Oracle Database QoS Management manages the resources that are shared across applications and adjusts the system configuration to keep the applications running at the performance levels needed by your business. Oracle Database QoS Management responds gracefully to changes in system configuration and demand, thus avoiding additional oscillations in the performance levels of your applications.

Oracle Database QoS Management monitors the performance of each work request on a target system. Oracle Database QoS Management starts to track a work request from the time a work request requests a connection to the database using a database service. The amount of time required to complete a work request, or the response time (also known as the end-to-end response time, or round-trip time), is the time from when the request for data was initiated and when the data request is completed. By accurately measuring the two components of response time, which are the time spent using resources and the time spent waiting to use resources, Oracle Database QoS Management can quickly detect bottlenecks in the system. Oracle Database QoS Management then makes suggestions to reallocate resources to relieve a bottleneck, thus preserving or restoring service levels.

Oracle Database QoS Management provides the following benefits:

1) Reduces the time and expertise requirements for system administrators who manage Oracle Real Application Clusters (Oracle RAC) resources

2) Helps reduce the number of performance outages

3) Reduces the time needed to resolve problems that limit or decrease the performance of your applications

4) Provides stability to the system as the workloads change

5) Makes the addition or removal of servers transparent to applications

6) Reduces the impact on the system caused by server failures

7) Helps ensure that service-level agreements (SLAs) are met

8) Enables more effective sharing of hardware resources

No comments:

Post a Comment