Re: _tru64_directio_disabled param Value on Digital Tru64 Unix
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 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 to .11 sec. Query2 : Avg. of 11.78 sec improved to 2.12 sec. Query3 : Avg. of .75 sec improved to .08 sec. This included multiple runs of each query, with a database bounce in between of course. So, what is the catch? [EMAIL PROTECTED] 05/29/02 02:26PM 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 operating system (ADVFS file system) caching and is more efficient; however, ADVFS does not cache any data or pre-fetch read data.For single block random reads directio is a performance improvement--there is less O/S overhead and Oracle does a good job of managing the buffer cache. However, Oracle does not hold multiple block reads in its cache, so if your workload involves a large number of multi-block reads directio is a performance detriment.The blocks are not cached, so re-reads require physical I/O for each read, and Oracle does not pre-fetch data as ADVFS does, so the application incurs more I/O wait. Also, any subsequent access after a file is opened in directio mode inherits the directio mode. This may impact other applications reading the files outside of the database activity--for example backup. In our experience using the Oracle Applications (ERP) suite, overall performance was better with directio disabled. By default directio is enabled if running 8.1.6 or later and Tru64 5.0a or later.The flag to disable was introduced in 8.1.7.2, I believe. We were told not to run 8.1.7.2 on Tru64 (buggy), so we have implemented 8.1.7.3. The default operating mode is: _tru64_directio_disabled = FALSE This enables directio. If you set it TRUE, then the RDBMS I/O will function as it did before--using normal I/O. There is not a lot of risk in changing this option, and directio may prove to be advantageous for a heavy OLTP environment. I would recommend testing outside of Production if at all possible. Bill HTH Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Hemant K Chitale INET: [EMAIL PROTECTED] 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: [EMAIL
Re: _tru64_directio_disabled param Value on Digital Tru64 Unix
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 - 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 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 to .11 sec. Query2 : Avg. of 11.78 sec improved to 2.12 sec. Query3 : Avg. of .75 sec improved to .08 sec. This included multiple runs of each query, with a database bounce in between of course. So, what is the catch? [EMAIL PROTECTED] 05/29/02 02:26PM 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 operating system (ADVFS file system) caching and is more efficient; however, ADVFS does not cache any data or pre-fetch read data.For single block random reads directio is a performance improvement--there is less O/S overhead and Oracle does a good job of managing the buffer cache. However, Oracle does not hold multiple block reads in its cache, so if your workload involves a large number of multi-block reads directio is a performance detriment.The blocks are not cached, so re-reads require physical I/O for each read, and Oracle does not pre-fetch data as ADVFS does, so the application incurs more I/O wait. Also, any subsequent access after a file is opened in directio mode inherits the directio mode. This may impact other applications reading the files outside of the database activity--for example backup. In our experience using the Oracle Applications (ERP) suite, overall performance was better with directio disabled. By default directio is enabled if running 8.1.6 or later and Tru64 5.0a or later.The flag to disable was introduced in 8.1.7.2, I believe. We were told not to run 8.1.7.2 on Tru64 (buggy), so we have implemented 8.1.7.3. The default operating mode is: _tru64_directio_disabled = FALSE This enables directio. If you set it TRUE, then the RDBMS I/O will function as it did before--using normal I/O. There is not a lot of risk in changing this option, and directio may prove to be advantageous for a heavy OLTP environment. I would recommend testing outside of Production if at all possible. Bill HTH Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are
RE: _tru64_directio_disabled param Value on Digital Tru64 Unix
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 operating system (ADVFS file system) caching and is more efficient; however, ADVFS does not cache any data or pre-fetch read data.For single block random reads directio is a performance improvement--there is less O/S overhead and Oracle does a good job of managing the buffer cache. However, Oracle does not hold multiple block reads in its cache, so if your workload involves a large number of multi-block reads directio is a performance detriment.The blocks are not cached, so re-reads require physical I/O for each read, and Oracle does not pre-fetch data as ADVFS does, so the application incurs more I/O wait. Also, any subsequent access after a file is opened in directio mode inherits the directio mode. This may impact other applications reading the files outside of the database activity--for example backup. In our experience using the Oracle Applications (ERP) suite, overall performance was better with directio disabled. By default directio is enabled if running 8.1.6 or later and Tru64 5.0a or later.The flag to disable was introduced in 8.1.7.2, I believe. We were told not to run 8.1.7.2 on Tru64 (buggy), so we have implemented 8.1.7.3. The default operating mode is: _tru64_directio_disabled = FALSE This enables directio. If you set it TRUE, then the RDBMS I/O will function as it did before--using normal I/O. There is not a lot of risk in changing this option, and directio may prove to be advantageous for a heavy OLTP environment. I would recommend testing outside of Production if at all possible. Bill HTH Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: _tru64_directio_disabled param Value on Digital Tru64 Unix
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 to .11 sec. Query2 : Avg. of 11.78 sec improved to 2.12 sec. Query3 : Avg. of .75 sec improved to .08 sec. This included multiple runs of each query, with a database bounce in between of course. So, what is the catch? [EMAIL PROTECTED] 05/29/02 02:26PM 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 operating system (ADVFS file system) caching and is more efficient; however, ADVFS does not cache any data or pre-fetch read data.For single block random reads directio is a performance improvement--there is less O/S overhead and Oracle does a good job of managing the buffer cache. However, Oracle does not hold multiple block reads in its cache, so if your workload involves a large number of multi-block reads directio is a performance detriment.The blocks are not cached, so re-reads require physical I/O for each read, and Oracle does not pre-fetch data as ADVFS does, so the application incurs more I/O wait. Also, any subsequent access after a file is opened in directio mode inherits the directio mode. This may impact other applications reading the files outside of the database activity--for example backup. In our experience using the Oracle Applications (ERP) suite, overall performance was better with directio disabled. By default directio is enabled if running 8.1.6 or later and Tru64 5.0a or later.The flag to disable was introduced in 8.1.7.2, I believe. We were told not to run 8.1.7.2 on Tru64 (buggy), so we have implemented 8.1.7.3. The default operating mode is: _tru64_directio_disabled = FALSE This enables directio. If you set it TRUE, then the RDBMS I/O will function as it did before--using normal I/O. There is not a lot of risk in changing this option, and directio may prove to be advantageous for a heavy OLTP environment. I would recommend testing outside of Production if at all possible. Bill HTH Srini Chavali Oracle DBA Cummins Inc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: _tru64_directio_disabled param Value on Digital Tru64 Unix
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. [EMAIL PROTECTED] -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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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
RE: _tru64_directio_disabled param Value on Digital Tru64 Unix
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: _tru64_directio_disabled param Value on Digital Tru64 Unix
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. [EMAIL PROTECTED] -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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: _tru64_directio_disabled param Value on Digital Tru64 Unix
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. [EMAIL PROTECTED] -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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: _tru64_directio_disabled param Value on Digital Tru64 Unix
_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. [EMAIL PROTECTED] -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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
_tru64_directio_disabled param Value on Digital Tru64 Unix
_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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
8.1.7.2.0 Supported on Digital Tru64 Unix ver 5.1 ?
Is 8.1.7.2.0 Supported/Safe/Advisable on Digital Tru64 Unix ver 5.1 ? OR Should we Go to a Minimum of 8.1.7.2.1 ? We are Migrating our Ver 7.3 Database Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: _tru64_directio_disabled param Value on Digital Tru64 Unix
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 _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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Anjo Kolk INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: 8.1.7.2.0 Supported on Digital Tru64 Unix ver 5.1 ?
The 8.1.7.2.0 Patchset for Tru64 was withdrawn and replaced by the 8.1.7.2.1 Patchset. You would be applying the patchset on top of an 8.1.7.0.0 or 8.1.7.1.0 or 8.1.7.1.0B installation. 8.1.7 is certified on Tru64 5.1 Hemant K Chitale - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, 26 May, 2002 11:28 PM Is 8.1.7.2.0 Supported/Safe/Advisable on Digital Tru64 Unix ver 5.1 ? OR Should we Go to a Minimum of 8.1.7.2.1 ? We are Migrating our Ver 7.3 Database Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Hemant K Chitale INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: digital tru64 unix
Lisa, We are running Oracle 7.3.4 and 8.1.6 on Compaq (Digital) Tru64 Unix. However, we are in the process of migrating to Sun Solaris. I can try to answer your questions, though. Lisa Koivu wrote: Hello everyone, Anyone out there running Oracle on this flavor of Unix? If so can you please email me directly? I don't have a Unix box to play with and I have a few simple performance questions. I'm also looking in the online doco and I don't see what I'm looking for (yet). Thanks in advance Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 "Life is like a sewer, what you get out of it depends on what you put into it" - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: digital tru64 unix
Lisa, 73450 on 4.0f. that help? if so, call...(i think you have the number?) if not, shoot me a mail. Ross -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/1/2001 10:46 AM Lisa, We are running Oracle 7.3.4 and 8.1.6 on Compaq (Digital) Tru64 Unix. However, we are in the process of migrating to Sun Solaris. I can try to answer your questions, though. Lisa Koivu wrote: Hello everyone, Anyone out there running Oracle on this flavor of Unix? If so can you please email me directly? I don't have a Unix box to play with and I have a few simple performance questions. I'm also looking in the online doco and I don't see what I'm looking for (yet). Thanks in advance Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -- Scott Canaan ([EMAIL PROTECTED]) (716) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it - Tom Lehrer -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Canaan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
digital tru64 unix
Title: digital tru64 unix Hello everyone, Anyone out there running Oracle on this flavor of Unix? If so can you please email me directly? I don't have a Unix box to play with and I have a few simple performance questions. I'm also looking in the online doco and I don't see what I'm looking for (yet). Thanks in advance Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments.