RAC Service Management
Oracle 12c
| Intermediate
- 16 videos | 1h 7m 31s
- Includes Assessment
- Earns a Badge
Managing varying workloads from different applications can be very complicated. Discover how to create and manage services with Enterprise Manager Cloud Control and SRVCTL.
WHAT YOU WILL LEARN
-
Define oracle services and describe how services are used in a rac database
Describe the characteristics that can be specified when creating a service
List the default services in a database and describe how restricted service registration improves rac security
Create a service using enterprise manager and perform common service management tasks
Create a service using srvctl and perform common service management tasks
Use a service in a client connect string and configure a service for load balancing
Configure services for use with transparent application failover
Configure resource manager to prioritize sessions by binding the client to a consumer group according to the service the client connects with -
Use job classes to assign a job to a service, to bring the benefits of services in rac to the scheduler
Configure singleton services for distributed transactions to maximize application throughput
Specify performance thresholds for services to compare achieved service levels against minimum required levels
Describe how statistics can be aggregated into finer levels to monitor and trace workloads where sessions are shared
View performance-related information for services with enterprise manager
Use the dbms_monitor package to enable or disable the aggregation of finer levels of granularity for statistics and tracing
Describe the service-related performance views
Connect to the database using a new service and schedule a job that runs under a specific service
IN THIS COURSE
-
1. Oracle Services Overview4m 7sIn this video, you will define Oracle services and describe how services are used in a RAC database. FREE ACCESS
-
2. Service Characteristics4m 43sAfter completing this video, you will be able to describe the characteristics that can be specified when creating a service. FREE ACCESS
-
3. Default Services and Restricted Service Registration4m 32sUpon completion of this video, you will be able to list the default services in a database and describe how Restricted Service Registration improves RAC security. FREE ACCESS
-
4. Creating and Managing Services in Enterprise Manager3m 16sIn this video, you will learn how to create a service using Enterprise Manager and perform common service management tasks. FREE ACCESS
-
5. Creating and Managing Services with SRVCTL5m 7sFind out how to create a service using SRVCTL and perform common tasks related to service management. FREE ACCESS
-
6. Services and Client Connections4m 38sIn this video, you will learn how to use a service in a client connect string and configure a service for load balancing. FREE ACCESS
-
7. Services and Transparent Application Failover4m 1sIn this video, you will learn how to configure services for Transparent Application Failover. FREE ACCESS
-
8. Using Services with the Resource Manager4m 33sTo prioritize sessions, configure Resource Manager to bind the client to a consumer group according to the service the client connects with. FREE ACCESS
-
9. Using Services with the Scheduler3m 18sIn this video, find out how to use job classes to assign a job to a service, to bring the benefits of services in RAC to the Scheduler. FREE ACCESS
-
10. Using Distributed Transactions with RAC5m 57sIn this video, you will configure singleton services for distributed transactions to maximize application throughput. FREE ACCESS
-
11. Service Thresholds and Alerts3m 59sUpon completion of this video, you will be able to specify performance thresholds for services and compare achieved service levels against minimum required levels. FREE ACCESS
-
12. Service Aggregation and Tracing3m 47sUpon completion of this video, you will be able to describe how statistics can be aggregated into finer levels to monitor and trace workloads where sessions are shared. FREE ACCESS
-
13. Enterprise Manager Top Services Performance Page3m 50sIn this video, you will learn how to view performance-related information for services with Enterprise Manager. FREE ACCESS
-
14. Service Aggregation Configuration4m 53sLearn how to use the DBMS_MONITOR package to enable or disable the aggregation of statistics and tracing at finer levels of granularity. FREE ACCESS
-
15. Service Performance views3m 13sAfter completing this video, you will be able to describe the service-related performance views. FREE ACCESS
-
16. Exercise: Create a New Service3m 38sIn this video, you will learn how to connect to the database using a new service, and schedule a job that runs under a specific service. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
