One simple example about Oracle SPM

The profiles are a new (relatively) word in a database systems. Profiles of load on the file system, of a historical sessions behaviour, of SQL … Finally, the baseline or Oracle SQL Plan Management is a new (again relatively 🙂 ) instrument for working with explain plan of queries during the lifetime of the application that can manage the choose among  explain plans and keep track of their evolutions.

There are a lot of technical surveys about it:

  1. Documentation
  2. Maria Kolgan
  3. Johathan Lewis
  4. NoCOUG 2012, №8 SQL Plan Management for Performance Testing

Let’s consider the principles of SPM on one simple example.

Continue reading “One simple example about Oracle SPM”

One simple example about Oracle SPM