IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: June 2011

Oracle SQL Plan Management – Part 2

3 Comments Posted by on June 7, 2011

SQL Plan Management – Oracle Database 11g In SPM part 1 we saw information about SPM and how to automatically capture the baseline. In this part we will see how to manually capture the baseline and the affect of using FIXED variable. Capturing Baseline Manually Occasionally we have to to capture the baseline manually. This [...]

, , ,

Oracle SQL Plan Management – Part 1

4 Comments Posted by on June 2, 2011

SQL Plan Management – Oracle Database 11g SQL Plan Management or SPM is a new feature introduced in 11g. We will take a detailed look at SPM in the following sessions. Before starting with practical example lets see some theory. What is SQL Plan Management? SPM is a new feature introduced in Oracle database 11g [...]

Database 10g Performance Tuning, Oracle Database 10g, Oracle Database 11g , , , ,

Follow

Get every new post delivered to your Inbox.

Join 156 other followers