July 2015 archive

There are three types of baselines: Fixed, Moving Windows and Templates. In this chapter, we will focus in the third one, where our target is to create baselines for a contiguous time period in the future. There are two types of baseline templates: single and repeating. They are very easy to create through "DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE" procedure. In …

Continue reading

Performance Analyser is specially good when we are doing an Upgrade in our Oracle Version, so you can check the times of the queries before/after the change. But for OCM, only 11gR2 is required to study. So probably, we will face another type of changement, like: Parameter Change Optimizer Statistics Practice here creating a SQL Tuning …

Continue reading

As I said to the previous chapter, SQL Access Advisor is also related with the previous topic ("Use SQL tuning tools and features"), but was defined separately. This indicates that this it is also a very important and will probably be in the certification exam. Study it! SQL Advisor is another performance tool and can suggest improvements like: Indexes. …

Continue reading

SQL Tuning Advisor is a great tool. This item is related with the previous topic ("Use SQL tuning tools and features"), but was defined separately. This indicates that it is very important and will probably be in the certification exam. SQL Tuning will suggest you to: Create a SQL Profile Create an Index Gather Statistics Restructure SQL …

Continue reading

This chapter is very very hard. Why? Because you can rephrase this as: "you need to know all the oracle tools that can help you improve the performance of something". So, what are those "tools" and "features". Well, there are a lot of them: First, the ones that have a specific topic already defined: SQL Performance …

Continue reading