Re: Oracle 8.1.7 on Solaris using open64/pread64 ?

From: Stephan Bressler <sbresslerx_no_spam_at_arcor.de>
Date: Tue, 24 Feb 2004 09:05:28 +0100
Message-ID: <c1f0jc$ncv$1@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 Tue Feb 24 2004 - 02:05:28 CST