Wednesday, August 24, 2011

Difference between Statspack and AWR..


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:

Zheng junxai5 said...

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

Zheng junxai5 said...

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

raybanoutlet001 said...

coach outlet
ray ban sunglasses
los angeles lakers jerseys
ray ban sunglasses
fitflops shoes
jacksonville jaguars jersey
louis vuitton sacs
jordan shoes
arizona cardinals jerseys
air jordan uk