Oracle-L: RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

From: Browett, Darren <dbrowett_at_city.coquitlam.bc.ca>
Date: Tue, 28 May 2002 07:53:28 -0800
Message-ID: <F001.0046CCB1.20020528075328@fatcity.com>

Thank You !

-----Original Message-----
Sent: May 27, 2002 11:13 PM
To: Multiple recipients of list ORACLE-L

_tru64_directio_disabled is an NON-Documented Tru64 Unix Specific parameter

To get List of ALL (Documented & NON-Documented) parameters :-

set echo on

spool parm1

select

a.ksppinm "Parameter",
a.ksppdesc "Description",
b.ksppstvl "Session Value",
c.ksppstvl "Instance Value"

from

x$ksppi a,
x$ksppcv b,
x$ksppsv c

where
a.indx = b.indx
and a.indx = c.indx
and a.ksppinm like '/_%' escape '/'
/

spool off

-----Original Message-----
Sent: Monday, May 27, 2002 10:38 PM
To: Multiple recipients of list ORACLE-L

Tru64 5.0 pk3 and oracle 8.1.7.2

Where can I find this parameter ( _tru64_directio_disabled ) ?

It is not in V$PARAMETER

Thanks

Darren

-----Original Message-----
Sent: May 27, 2002 6:58 AM
To: Multiple recipients of list ORACLE-L

Vivek - I don't know if you checked Google, but the following page has some information. http://www.ixora.com.au/notes/direct_io.htm It sounds like on Tru64 5.0 this is "yes" by default, so you would only be setting it "no".

And sure I always try out new settings on the production server. That is how you get a reputation as an eXtremeDBA. Corporations like to trust their systems to "live on the edge" types. ;-) Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Monday, May 27, 2002 3:38 AM
To: Multiple recipients of list ORACLE-L

Anjo , List

If you mean it is SAFE to set this parameter to Either Value , Thanks

Are there any Guidelines to Set this Value for Best Performance ? OR Should we Simply Set it & See ?
The only Concern is that it is a Production Database .

Thanks

-----Original Message-----
Sent: Sunday, May 26, 2002 9:48 PM
To: Multiple recipients of list ORACLE-L

Well,

If don't want direct io set it to true, else set it to false.

Anjo.

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Sunday, May 26, 2002 5:23 PM

>
> _tru64_directio_disabled Stands for Direct IO support Disabled
>
> Current Default Value of _tru64_directio_disabled is FALSE ?
>
> Qs What would be the SAFE & Advisable to set  _tru64_directio_disabled to

TRUE ?

>
> Oracle 8.1.7.2 on Digital Tru64 Unix 5.1
>
> It is a Banking (Hybrid) Application having a Load of about 2 Million OLTP
> Transactions in a 5 Hour Window Everyday

--

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

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.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: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.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: Browett, Darren
INET: dbrowett_at_city.coquitlam.bc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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: Browett, Darren
INET: dbrowett_at_city.coquitlam.bc.ca

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------