Re: How to delete STATSPACK data efficient to release back space?

Are you really running into any performance problem? If not, then you
can reduce the statspack snapshot interval from 15 min to reasonably
higher intervel like say 1 ro 2 hours.

Check this link..
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1336002638218

Cheers,
WantedToBeDBA.

.

Relevant Pages

  • Re: About Machine Performance issue
    ... waitio is a meaningless metric. ... Please describe the performance problem. ... Tell us what load the system ... Prev by Date: ...
    (comp.unix.solaris)
  • Re: copymemory basic question
    ... > optimizer can do it or not, ... predict what is most efficient and what is a performance problem. ... > it's best to test it with a timing routine to see which method is faster. ... Prev by Date: ...
    (microsoft.public.vb.winapi)
  • Re: please verify the code
    ... Joe Wright wrote: ... Its a rule of thumb -- and it seems I got it wrong. ... which of course it not a performance problem. ... Prev by Date: ...
    (comp.lang.c)
  • Re: FastMove bad RTL Replacement for Athlon XP
    ... Main interest is to locate the performance problem. ... This time I am interested to see how effective patching is also. ... Best regards ... Prev by Date: ...
    (borland.public.delphi.language.basm)