Re: Oracle 8.1.7 on Solaris using open64/pread64 ?

Thanks Anurag. The files are located on a Netapp filesystem (i.e a disk accessed via NFS). You can get more info on those on www.netapp.com. They are recommended by Oracle as a good storage system. I'll be posting the truss output by tonight. Thanks again,

Philippe

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:<wps_b.13$ax2.3_at_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 Tue Feb 24 2004 - 01:21:12 CST