Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Statspack, rest in piece
Long live Automatic Workload Repository (AWR). It even comes with a
package to analyze it, so that the poor administrator doesn't have
think about the question of life, universe and instance parameters.
Package is called "DBMS_ADVISOR". I have quite negative experience
with something called "VPA" (= VMS Performance Advisor) which was
usually diagnosing non-existing problems and advised purchase of new
hardware. I wonder whether Oracle has incorporated things like that
into theri code. After all, VPA was able to diagnose RDB problems and
guess who has bought RDB?
![]() |
![]() |