Re: Oracle 8.1.7 on Solaris using open64/pread64 ?

Thanks for all your answers. I found out where the slow performances were coming from. There was contention on oraus.msb. See www.sun.com (56980). We improved our performance by 40% by using the patch provided !

I can provide more info if needed.
Philippe (kouchba_at_yahoo.com)

Stephan Bressler <sbresslerx_no_spam_at_arcor.de> wrote in message news:<c1f0jc$ncv$1_at_news.mch.sbs.de>...
> kouchba wrote:
> > 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).
> Hi,
> the open64, read64, etc calls were designed to get around the 2GB/4GB
> file size limit (seek took the position as byte offset).
> The use is related to the version of oracle. 8i used these calls by
> default, whether or not the datafile is big (>2GB).
>
> This has for sure no performance impact. I would go after memory setting
> or execution plan differences.
>
> Regards
> Stephan
Received on Wed Feb 25 2004 - 11:22:18 CST