From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Performing an optimization exercise

Performing an optimization exercise - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Performing an optimization exercise

“

- [Instructor] An optimization exercise can provide incredible value when done correctly. If there aren't clear goals, or when completion deadlines aren't set, then exercises often result in little value or can go on indefinitely. For a productive optimization exercise, first, determine the goal. Troubleshooting a recurring single situation, an overall environment performance problem that the database is included in and will be part of a large group of specialists for each tier. How to eliminate resource usage of CPU, memory, I/O, network, or any combination of these. Users are dissatisfied with the performance of the system. Where types one, two, and three exercise requirements are best determined by reports provided by system utilities and tools, four will be determined by individuals. As with the example you can see on the screen, a high level list of goals should be set, and colors should be kind of decided for the actual categories. When deciding what detailed tasks will be part…

Contents