RE: timed_os_statistics initSID.ora parameter

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Wed, 27 Jun 2001 11:58:34 -0700
Message-ID: <F001.0033A913.20010627110817@fatcity.com>

Ross,
Do you mean to check v$sysstat and statname? (not parameter) If I remember correctly, the statistics that are populated are OS dependent (not all OS's populated all stats).

Henry

-----Original Message-----

Sent: Wednesday, June 27, 2001 12:33 PM
To: Multiple recipients of list ORACLE-L

oracle<==>os hooks for monitoring.

select from parameters where name starts with "OS".

it populates those stats.

For more, and something written in uncompressed English, wait for the cognoscenti to post...:)

• Ross

-----Original Message-----

Sent: Wednesday, June 27, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mohan, Ross
  INET: MohanR_at_STARS-SMI.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Henry Poras
  INET: Henry.Poras_at_ctp.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 - 13:58:34 CDT