Re: Oracle 8.1.7 on Solaris using open64/pread64 ?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Mon, 23 Feb 2004 19:22:04 GMT
Message-ID: <wps_b.13$ax2.3@nwrdny03.gnilink.net>

"kouchba" <kouchba_at_yahoo.com> wrote in message news:f55a8ec8.0402231017.66184edd_at_posting.google.com...
> Hi Gurus and regards,
>
> I have one Oracle 7.3.4 instance running on Solaris 2.7 (Sparc). When
> I truss a dedicaced process, I see it using functions like open and
> pread,..
>
> I also have one 8.1.7 instance running on the same server but when I
> truss its dedicaced servers, I see they are using functions calls such
> as open64 pread64...which are 64 file system calls, I believe.
>
> My question is, why ? can I change the second behaviour to have it
> working as 7.3.4 as I see huge performance differences between the 2
> (7.3.4 much faster than 8.1.7).
>
> Thanks in advance for those who can help,
> Regards Gurus,
> Philippe (kouchba_at_yahoo.com)

On what kind of filesystem are the oracle files located (VxFS?) ? Why do you feel the pread64 calls are the problem? Can you paste a section of the truss results out here...

Have you analyzed performance using utlbstat/estat or event 10046?

Anurag Received on Mon Feb 23 2004 - 13:22:04 CST