Oracle 8.1.6 and AdvFS on Tru64 5.1A+pk1

From: A. Mahendra Rajah (Mahendra.Rajah@URegina.CA)
Date: Tue May 07 2002 - 13:20:18 EDT


   System: 2 CPU ES40 with Tru64 5.1A+pk1

   Ever since we moved to Tru64 5.1A from 5.1, users have been
   complaining that Oracle is quite slow on our system. My Oracle
   DBA says that direct I/O that is implicitly enabled in AdvFS on
   Tru64 5.1A affects Oracle's performance considerably.

   Is this true?

   My reading up of the AdvFS Administration manual tells me that
   one must request direct I/O explicitly when the file is opened.
   So, it begs the question: is direct I/O implicit for all AdvFS
   files or is Oracle asking for it in their code?

   If so, how can one get around this problem? Moving to 8.1.7 is
   not possible at the moment as SCT, the supplier of BANNER, has
   not yet approved its usage.

   Any help will be greatly appreciated.

   Thanks in advance,

   -- mahendra
.....................................................................
   A. Mahendra Rajah Email: Mahendra.Rajah@URegina.CA
   Tru64 UNIX Systems Manager Phone: (306) 585-4496
   Dept. of Computing Services FAX: (306) 585-5060
   University of Regina,
   Regina, Sask., S4S 0A2
   Canada.
.....................................................................



This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:48:40 EDT