Browsing: Databases

All that is not covered by the Oracle Database…

3 DBConsole 11g (part 2) – Using the SQL Performance Analyzer

Now straight into the more interesting Oracle 11g features. Let’s start using the SQL performance Analyzer and doing so make use of Replay. The Performance section of the DBConsole utility has a link to Advisor Central. The Advisor Central has again two sections: The Checkers section and the Advisors section.

From the Advisor section you are able to click on the SQL Performance Analyzer link.

Here you can choose from three options. I will demonstrate the “Guided Workflow”, but before that I show you the screens of the “Optimizer Upgrade Simulation” and “Parameter Change” sections. The descriptions in the screenshots are self-explainable.

1 3 4 5 6 7 10