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
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
-
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
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
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
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,
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.
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
_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
_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
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
11 matches
Mail list logo