We use Statspack everywhere, given that AWR cost so much.Now that we are licensed for AWR with grid, I find out that Oracle has no way to port the historical information I have in statspack to AWR, all three yars of it, rendering AWR's historical analysis useless. Great... (NOT!) They really went out of their way to make AWR useless for folks already monitoring their dbs, didn't they?
Ah well: I suppose it's fun watching them shooting their collective feet off... -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxx Allen, Brandon wrote,on my timestamp of 12/12/2009 7:42 AM:
And/or schedule regular statspack snapshots - it's a good replacement for AWR, but not so much for ASH
-- //www.freelists.org/webpage/oracle-l