Re: Oracle 8.1.7 huge performance problem : please help !

From: Chuck <chuckh_nospam_at_softhome.net>
Date: 14 Jan 2004 17:39:19 GMT
Message-ID: <Xns947080BCC504chuckhsofthomenet@130.133.1.4>

Last I heard, Oracle recommended that you do NOT put any files used by the rdbms on an nfs mounted file system.

Does the version 7 instance also use nfs?

kouchba_at_yahoo.com (kouchba) wrote in
news:f55a8ec8.0401140723.24f2d21f_at_posting.google.com:

> I forgot to tell you that we are using a netapp (nfs based disk) on
> which the datafiles are located.
> 
> kouchba_at_yahoo.com (kouchba) wrote in message
> news:<f55a8ec8.0401140345.17e23c71_at_posting.google.com>... 

>> Hi there,
>>
>> We are using Oracle 8.1.7 on Solaris 7 and Oracle 7.3.4 as well.
>> We compared the execution plan of a query under Oracle 7 and Oracle
>> 8.1.7 and it is exactly the same (using the same indexes,..). The
>> number of extents of the index is the same too. The data files of the
>> two instances are located on the same disks. But each time we execute
>> the query under Oracle 8 , it is about ten times slower. That
>> slowliness is not related to that particular query but to the whole
>> application when executed under Oracle 8.1.7. So I am thinking more
>> of an instance problem rather than an application problem.
>>
>> It seems to be IO bound to me just as something which have changed in
>> the way Oracle 8 interacts with the filesystem. I tried to play with
>> the hidden parameter _filesystemio_options but it did not work.
>>
>> Any idea ?
>>
>> Thanks,
>> Philippe (kouchba_at_yahoo.com, pbackouche_at_sepro-robotique.com)

-- 
Chuck
Remove "_nospam" to reply by email

Received on Wed Jan 14 2004 - 11:39:19 CST