RAC Service Management

Oracle 12c    |    Intermediate
  • 16 videos | 1h 7m 31s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 5 users Rating 4.4 of 5 users (5)
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

  • Locked
    1.  Oracle Services Overview
    4m 7s
    In this video, you will define Oracle services and describe how services are used in a RAC database. FREE ACCESS
  • Locked
    2.  Service Characteristics
    4m 43s
    After completing this video, you will be able to describe the characteristics that can be specified when creating a service. FREE ACCESS
  • Locked
    3.  Default Services and Restricted Service Registration
    4m 32s
    Upon 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
  • Locked
    4.  Creating and Managing Services in Enterprise Manager
    3m 16s
    In this video, you will learn how to create a service using Enterprise Manager and perform common service management tasks. FREE ACCESS
  • Locked
    5.  Creating and Managing Services with SRVCTL
    5m 7s
    Find out how to create a service using SRVCTL and perform common tasks related to service management. FREE ACCESS
  • Locked
    6.  Services and Client Connections
    4m 38s
    In this video, you will learn how to use a service in a client connect string and configure a service for load balancing. FREE ACCESS
  • Locked
    7.  Services and Transparent Application Failover
    4m 1s
    In this video, you will learn how to configure services for Transparent Application Failover. FREE ACCESS
  • Locked
    8.  Using Services with the Resource Manager
    4m 33s
    To prioritize sessions, configure Resource Manager to bind the client to a consumer group according to the service the client connects with. FREE ACCESS
  • Locked
    9.  Using Services with the Scheduler
    3m 18s
    In 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
  • Locked
    10.  Using Distributed Transactions with RAC
    5m 57s
    In this video, you will configure singleton services for distributed transactions to maximize application throughput. FREE ACCESS
  • Locked
    11.  Service Thresholds and Alerts
    3m 59s
    Upon 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
  • Locked
    12.  Service Aggregation and Tracing
    3m 47s
    Upon 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
  • Locked
    13.  Enterprise Manager Top Services Performance Page
    3m 50s
    In this video, you will learn how to view performance-related information for services with Enterprise Manager. FREE ACCESS
  • Locked
    14.  Service Aggregation Configuration
    4m 53s
    Learn how to use the DBMS_MONITOR package to enable or disable the aggregation of statistics and tracing at finer levels of granularity. FREE ACCESS
  • Locked
    15.  Service Performance views
    3m 13s
    After completing this video, you will be able to describe the service-related performance views. FREE ACCESS
  • Locked
    16.  Exercise: Create a New Service
    3m 38s
    In 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.