[Ocfs-users] OCFS Database too slow

[Wim Coekaerts]

yes you are probably comparing local filesystem versus raw or cfs which
is not cached in the OS only in oracle.

this is a story that comes back on this list every few weeks or months
and basically happens because there is a huge misunderstanding on what
the OS filesystem cache provides single node etc etc, it takes time to
explain and I think wehave in the past. could you go through the
archives and look for earlier discussions on this ? 

there is nothing slow, what youa re doing is having a database run that
has a lot of stuff cached in the OS itself on local fielsystem and then
when you do that query on cfs or raw it has to go to disk, the rigth
thing to do (should do) is give all that memory to oracle. then you will
see the difference

again, it's not abug, don't think it's slow, just do the right thing.
and look in archives for a pointer to the discussions

Wim

On Fri, Jul 16, 2004 at 09:39:33AM -0700, Varghese Abraham wrote:
> 
> Hi All,
>  we are using Red Hat 2.1 Kernel e38 along with MSA 1000.
> ocfs version being used is
> 
> $ rpm -qa | grep ocfs
> ocfs-tools-1.0.10-1
> ocfs-2.4.9-e-enterprise-1.0.12-1
> ocfs-support-1.0.10-1
>  
> 
> Database Version is 9.2.0.5
> 
> 
> However we find that the performance of the database on OCFS is too slow. even a select count(1) from all_tables takes like a while to complete.
> 
> We initially assumed RAC is the problem area.  ( Because with both nodes enabled we had terrible performance)
> 
> Hence we stopped one of the RAC Databases to test out the performance.
> However even with one node the performance is real bad.
> 
>  
> 
> Any pointers on how to debug this problem.
> 
> 
> R'gds
> Varghese Abraham.
> _______________________________________________
> Ocfs-users mailing list
> Ocfs-users at oss.oracle.com
> http://oss.oracle.com/mailman/listinfo/ocfs-users