Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: V$???? Manipulation
Direct manipulation of Oracle system tables is an invitation to disaster!
-- David J Roth (My own opinions) Jim Smith <jim_at_jimsmith.demon.co.uk> wrote in article <$Ee2$CA3RhdyEwvn_at_jimsmith.demon.co.uk>...Received on Tue Oct 29 1996 - 00:00:00 CST
> In article <553bap$t82_at_news.gte.com>, Kevin Brand <kbrand_at_gtetel.com>
> writes
> >
> >I have found the need to zero out various NUMBER columns in
> >the V$ performance tables without bouncing the engine.
>
> Why? If you want to collect statistics over a period, look at the
> UTLBSTAT and UTLESTAT scripts provided for just this purpose.
>
> Please use comp.databases.oracle.server for questions like this
> --
> Jim Smith
>