Re: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-30 Thread Hemant K Chitale
So you got a performance improvement by *disabling* DirectIO (ie, by setting _tru64_directio_disabled=TRUE) ? Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, 30 May, 2002 3:48 AM I joined in on this thread a little bit

Re: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-30 Thread Jay Hostetter
Yes, I changed it from the default. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA Hemant K Chitale [EMAIL PROTECTED] 05/30/02 09:32AM So you got a performance improvement by *disabling* DirectIO (ie, by setting _tru64_directio_disabled=TRUE) ? Hemant K Chitale -

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-29 Thread Srini . Chavali
Quote from a person who has had researched this thoroughly at our site - Oracle 8.1.6 and later releases check to see if they are running on Tru64 5.0a or later operating system revision.If so, the RDBMS automatically uses the directio mode to open the database files. Directio bypasses the

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-29 Thread Jay Hostetter
I joined in on this thread a little bit late. I just did a little experimentation with this parameter, and all that I can say is WOW! This is the equivalent of the mythical _make_sql_run_faster! My quick tests on 8.1.7.2 on both Tru64 5.1 pk3 and 5.1a pk1: Query1 : Avg. of 1.13 sec improved

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-28 Thread Browett, Darren
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

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-27 Thread VIVEK_SHARMA
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,

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-27 Thread DENNIS WILLIAMS
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.

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-27 Thread Browett, Darren
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

RE: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-27 Thread VIVEK_SHARMA
_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

Re: _tru64_directio_disabled param Value on Digital Tru64 Unix

2002-05-26 Thread Anjo Kolk
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 [EMAIL PROTECTED] Sent: Sunday, May 26, 2002 5:23 PM _tru64_directio_disabled Stands for Direct IO support Disabled Current Default Value of