1.) STATSPACK does not store the Active Session History (ASH) statistics which are available in the AWR dba_hist_active_sess_history view.
2.)An important difference between STATSPACK and the AWR is that STATSPACK does not store history for new metric statistics introduced in Oracle10g. The key AWR views, dba_hist_sysmetric_history and dba_hist_sysmetric_summary.
3.)Statspack snapshots must be run by an external scheduler (dbms_jobs, CRON, etc.). AWR snapshots are scheduled every 60 minutes by default. Administrators can manually adjust the snapshot interval if so desired.
4.)ADDM captures a much greater depth and breadth of statistics than Statspack does.
5.)Statspack snapshot purges must be scheduled manually.AWR snapshots are purged automatically by MMON every night. MMON, by default, tries to keep one week's worth of AWR snapshots available. If AWR detects that the SYSAUX tablespace is in danger of running out of space, it will free space in SYSAUX by automatically deleting the oldest set of snapshots.
Enjoy:-)
3 comments:
zhengjx20160428
michael kors outlet clearance
oakley sunglasses
longchamp le pliage
kate spade handbags
michael kors outlet online
fitflops
rolex watches
michael kors outlet
tiffany and co
burberry handbags
christian louboutin outlet
christian louboutin sale clearance
ray ban sunglasses outlet
juicy couture
jordan 6s
kobe 8
michael kors outlet
nike blazers shoes
fitflop clearance
jordan 3s
cheap ray ban sunglasses
kate spade purses
tory burch flats
air max
air max 95
kobe 10
concords 11
adidas outlet store
louis vuitton purses
louis vuitton handbags
rolex watches
cheap ray ban sunglasses
louis vuitton bags
nike store
ray ban sunglasses
coach outlet store online
cheap jordans
ralph lauren outlet
giuseppe zanotti outlet
zzzzz2018.8.31
off white jordan 1
polo ralph lauren outlet
pandora jewelry
nba jerseys
golden goose
ralph lauren outlet
pandora
mlb jerseys
pandora
pandora jewelry
ysl handbags
adidas outlet
longchamp
nike air max
fila
jordan retro
goyard bags
jordan 4
adidas ultra boost
ultra boost
Post a Comment