Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: resetting HWM and other stats
Yes.
When creating rollback segments, set
the option "optimal".
This option try to group extents at the
size specified. (not usable on all
versions)
Hope this help.
-- REIP Jean-Claude Pour me contacter, enlevez ".remove.this" de l'adresse ! (anti-spam) jacari.consultant.remove.this_at_skynet.be Wisd743 <wisd743_at_aol.com> a écrit dans l'article <19971012044101.AAA10182_at_ladder01.news.a ol.com>...Received on Sun Oct 12 1997 - 00:00:00 CDT
> Is there a way to reset rollback
segment high water marks and other data
> dictionary dynamic stats without
shutting down the database?
> Just wondering.
>
>
![]() |
![]() |