Re: Performance impact of "MONITORING USAGE"

"Howard J. Rogers" <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]: 

> 
> "Howard J. Rogers" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> 
>>
>> 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.
> 

BTW. statistics_level = typical is the default:

SQL> exec print_table('select * from v$parameter where name like 
''stat%''');
NUM                           : 769
NAME                          : statistics_level
TYPE                          : 2
VALUE                         : TYPICAL
ISDEFAULT                     : TRUE
ISSES_MODIFIABLE              : TRUE
ISSYS_MODIFIABLE              : IMMEDIATE
ISMODIFIED                    : FALSE
ISADJUSTED                    : FALSE
DESCRIPTION                   : statistics level
UPDATE_COMMENT                :

so no you get it automatically unless you change it.