Based on the number of instances participating in your Oracle RAC Cluster and complexity and objectives of your application’s environment we need to choose optimal workload management. And there variety of considerations based on that.
We can use following features of Oracle RAC to manage workload :
- Oracle Services
- Database Resource Manager
- Oracle Rac High Availability Framework
- FAN[Fast Application Notification]
- Load Balancing Advisory
- Connection Load Balancing
In this article we are going to cover Oracle Services.
First of all What is Services
In Single Instance database we use service for separating workloads and we can administer it well.
The services are tightly integrated with Oracle Database and are maintained in the data dictionary.Application team can define service name while connecting to database and if no service is defined , database will be connected with default service which has same name as database name.
We can check service name using service_names parameter
SQL> show parameter service_names NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ service_names string orcl SQL>
In Oracle RAC , Services are having much more features than just separating workload and administer it.
A service is a logical grouping of sessions performing similar kind of work.Services enable you to group database workloads and route work to the optimal instances that are assigned to offer the service
For services ,It is recommended that all the users who connect using a service have the same service-level requirements.
Advantages of using Services :
- High Availability : In Oracle RAC we can set preferred and available instance for specific service. Which gives advantage. In case of Instance crash , service will be automatically redirected to a available instance.
- Services makes the work more manageable and tuneable. For example , all on-line users can use one service whereas batch users can use another service and reporting can use yet another service.
- Tracing can be also enabled for all sessions who connect using a service. This is useful to identify culprit session connected using a particular service.Performance statistics are collected and aggregated by service: This can be used to find out the performance of all the sessions belonging to a service.
- We can SERVICE_ELAPSED_TIME and SERVICE_CPU_TIME performance threshold . The AWR report monitors the service time and CPU time and publishes alerts when the performance exceeds the thresholds. With this information we can modify services accordingly.
In next article we will learn about modification of Services.
Stay tuned for More articles on Oracle RAC
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Telegram Channel : https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp