Overview
Understudies make sense of how to use Oracle Database customized tuning features, for instance, SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning procedures. The course bases on the tuning tasks expected of a DBA: open tuning of SQL declarations, keeping up SQL clarification and movement execution, and tuning the Oracle Database Instance parts.
Audience
- Administrator
- Database Administrator
Course Prerequisites
Proposed Prerequisite :
- Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
- Familiarity with Oracle Database foundation
- Familiarity with Oracle Database arrangement thoughts
Required Prerequisite :
- Oracle Database 18c: Administration Workshop Ed 1
- Basic data of Linux working system
- A working data of SQL and PL/SQL groups
- Basic perception of Oracle Database plan
- Familiarity with basic database checking procedures