Resource Management

Oracle 12c    |    Intermediate
  • 8 videos | 45m 22s
  • Includes Assessment
  • Earns a Badge
Rating 4.3 of 10 users Rating 4.3 of 10 users (10)
Ensure efficient database performance by taking advantage of tuning tools available in Oracle Database 12c. Discover how to manage resources to optimize performance, including working with Resource Manager and monitoring statistics.

WHAT YOU WILL LEARN

  • Describe the uses of the database resource manager in oracle database 12c
    Describe the default resource manager plan and maintenance window in oracle database 12c
    Create simple and complex resource plans in oracle database 12c
    Specify resource plan directives and allocate plan resources in oracle database 12c
  • Describe the active session pool mechanism, specify thresholds, and set idle timeouts in oracle database 12c
    Limit cpu utilization at the database and server levels, and monitor instance caging in oracle database 12c
    Track runaway queries and manage the mapping of sessions to resource consumer groups in oracle database 12c
    Monitor resource manager statistics in oracle database 12c

IN THIS COURSE

  • Locked
    1.  Database Resource Manager Uses
    7m 2s
    Upon completion of this video, you will be able to describe the uses of the Database Resource Manager in Oracle Database 12c. FREE ACCESS
  • Locked
    2.  Resource Manager Plans and Maintenance Windows
    3m
    Upon completion of this video, you will be able to describe the default Resource Manager plan and maintenance window in Oracle Database 12c. FREE ACCESS
  • Locked
    3.  Creating Simple and Complex Resource Plans
    7m 30s
    Learn how to create simple and complex resource plans in Oracle Database 12c. FREE ACCESS
  • Locked
    4.  Managing Resource Plans
    6m 43s
    Upon completion of this video, you will be able to specify resource plan directives and allocate plan resources in Oracle Database 12c. FREE ACCESS
  • Locked
    5.  Managing Session Resource Use
    6m 47s
    Upon completion of this video, you will be able to describe the Active Session Pool mechanism, specify thresholds, and set idle timeouts in Oracle Database 12c. FREE ACCESS
  • Locked
    6.  Limiting CPU Utilization
    6m 58s
    In this video, you will learn how to limit CPU utilization at the database and server levels, and monitor instance caging in Oracle Database 12c. FREE ACCESS
  • Locked
    7.  Managing Runaway Queries and Consumer Group Mapping
    5m 27s
    Learn how to track runaway queries and manage the mapping of sessions to resource consumer groups in Oracle Database 12c. FREE ACCESS
  • Locked
    8.  Monitoring Resource Manager Statistics
    1m 56s
    Learn how to monitor Resource Manager statistics in Oracle Database 12c. 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.

YOU MIGHT ALSO LIKE

Book Expert Performance Indexing in Azure SQL and SQL Server 2022: Toward Faster Results and Lower Maintenance Both on Premises and in the Cloud, 4th Edition
Course Modern Data Management: Data Quality Management
Rating 4.4 of 186 users Rating 4.4 of 186 users (186)
Course Leveraging the Power of Performance Management
Rating 4.7 of 164 users Rating 4.7 of 164 users (164)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Formatting cells and ranges in Excel 365
Rating 4.6 of 1179 users Rating 4.6 of 1179 users (1179)
Course Spring Boot Microservices: Asynchronous Methods, Schedulers, & Forms
Rating 4.6 of 60 users Rating 4.6 of 60 users (60)
Course Database Fundamentals: Database Administration Basics
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)