Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Mon, 27 May 2002 22:13:21 -0800
Message-ID: <F001.0046C6B8.20020527221321@fatcity.com>

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

>
> _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
--------------------------------------------------------------------
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: 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).
Received on Tue May 28 2002 - 01:13:21 CDT

Original text of this message

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