Patrice,
I don't know which version of the manuals you're
looking at, but there was a doc bug where the values
for the parameter were listed as OFF, CALL & LOGOFF.
The correct way to use it is to set it to an integer
value representing the number of seconds the OS stats
will be refreshed.
Also, timed_statistics must be set to true in order
for it to work.
HTH,
- Anita
- "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>
wrote:
> Does anyone know what this does? Sounds
> tantalizing.
>
> I tried to set it in my initSID.ora file, but
> Oracle8.1.7. says it does not
> understand that parameter name.
>
> It shows up when I ask the rdbms for parameter
> values, though.
>
> prompt Global Parameter Values
> column num format 999 heading 'Nbr'
> column name format a41 heading 'Parameter Name'
> column value format a37 heading 'Parameter Value'
> select num,
> name,
> value
> from v$parameter
> order by name
> /
>
> Regards,
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>
> Systems Admin & Operations | Admin. et Exploit. des
> systèmes
> Technology Services | Services technologiques
> Informatics Branch | Direction de
> l'informatique
> Maritimes Region, DFO | Région des Maritimes,
> MPO
>
> E-Mail: boivinp_at_mar.dfo-mpo.gc.ca
> <mailto:boivinp_at_mar.dfo-mpo.gc.ca>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Jun 27 2001 - 12:48:51 CDT
