SQL Tuning

Oracle 12c    |    Intermediate
  • 10 Videos | 53m 42s
  • Includes Assessment
  • Earns a Badge
Likes 20 Likes 20
Proper monitoring and tuning of databases significantly improves system performance. Learn how to use SQL tuning, optimizer statistics, and the range of SQL advisors included in Oracle Database 12c.

WHAT YOU WILL LEARN

  • describe SQL tuning and the optimizer statistics used in Oracle Database 12c
    describe the collection of optimizer statistics in Oracle Database 12c
    use the Optimizer Statistics Console to set global preferences for optimizer statistics in Oracle Database 12c
    gather optimizer statistics manually and set optimizer statistics preferences in Oracle Database 12c
    describe concurrent statistics gathering in the Oracle Database 12c
  • describe concurrent statistics gathering and the use of SQL plan directives in the Oracle Database 12c
    describe the SQL Advisors available in Oracle Database 12c
    describe and use the SQL Tuning Advisor in Oracle Database 12c
    describe and use the SQL Access Advisor in Oracle Database 12c
    describe and use the SQL Performance Analyzer in Oracle Database 12c

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

CHANNEL Oracle Database 12c: Performance Management and Tuning
Likes 49 Likes 49  
BOOK PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
BOOK Oracle High Availability, Disaster Recovery, and Cloud Services: Explore RAC, Data Guard, and Cloud Technology

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Shell Scripting
Likes 141 Likes 141  
COURSE Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Likes 165 Likes 165  
COURSE Advanced SQL Queries
Likes 209 Likes 209