Re: SPM again

From: John Kanagaraj <>
Date: Thu, 11 Mar 2010 15:37:04 -0800
Message-ID: <>

Hi Brandon,

> Why not just create a few preserved snapshots at your desired interval to retain older plans in AWR?

The problem with this approach is this: One would need to retain all of AWR data for *just* the SQL and SQL plans. The other is this: A Dev/Test would run over a long period, with SQL plans *evolving* during this period. We would not be able to get all the snapshots and preserve them....

SPM, IMHO, provides an easy way to do this provided you are prepared to pay for the license. Don't get me wrong: I am not advocating using SPM right away, and we still need to work through all the bugs and "features" :)

John Kanagaraj <>< (Sorry - not an Oracle blog!)
** The opinions and facts contained in this message are entirely mine
and do not reflect those of my employer or customers **
Received on Thu Mar 11 2010 - 17:37:04 CST

Original text of this message