Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: V$???? Manipulation

Re: V$???? Manipulation

From: David J. Roth <droth_at_sii.com>
Date: 1996/10/29
Message-ID: <01bbc5e5$889269e0$8b0ebe9b@droth.sii.com>#1/1

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>...

> 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
>
Received on Tue Oct 29 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US