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: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: 1996/10/29
Message-ID: <$Ee2$CA3RhdyEwvn@jimsmith.demon.co.uk>#1/1 







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