Topics
- Administer Resource Manager
- Use Result Cache
- Use multi column statistics
- Gather statistics on a specific table without invalidating cursors
- Use partitioned indexes
- Administer and tune schema object to support various access methods
- Interpret execution plan
- Use SQL tuning tools and features
- Use SQL Tuning Advisor
- Use SQL Access Advisor
- Use SQL Performance Analyzer
- Configure baseline templates
- Use SQL Plan Management feature
- Implement instance caging
The following two tabs change content below.
Jacques
I am Oracle Certified Master 11g & 12c database architect with significant experience in heterogeneous environments, and strong ability to lead complex and critical projects requiring multiple technical implementations. at Trivadis SA
Latest posts by Jacques (see all)
- 8 Nodes Cluster Upgrade from 12.1.0.2 to 12.2.0.1 - May 12, 2019
- RAC Database upgrade from 12.1.0.2 to 12.2.0.1 - May 12, 2019
- Managing Standby RedoLogs - May 12, 2019
- Cannot create database on ODA X6-2m after changing default port from 1521 to 13200 - January 8, 2018
- Setting up TAF with Data Guard: news from error ORA-16456 - December 13, 2016