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: Performance impact of "MONITORING USAGE"

Re: Performance impact of "MONITORING USAGE"

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 3 Dec 2003 06:27:55 +1100
Message-ID: <3fcce7c4$0$20308$afc38c87@news.optusnet.com.au> 






"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message
news:3fcce40c$0$20308$afc38c87_at_news.optusnet.com.au...



>

> The overhead of setting segment_statistics to ALL is quite high, but for

> TYPICAL, it's barely noticeable. And you can set and forget it.

>




Ooops. The init.ora parameter is called statistics_level. It's the view
that's called v$segment_statistics. I got it right first time, but then went
uncharacteristically loopy.



Regards


HJR

Received on Tue Dec 02 2003 - 13:27:55 CST












Original text of this message













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