Re: [suse-oracle] OCFS2, blockdev and readahead

 Aside of the question - what are they going to back up from the file system with the database?

I'd better set read_ahead = 0, except if you have a lot of full table scans.


  ----- Original  Message ----- 
  From: Vladimir Barac
  To: '[email protected]'
  Sent: Sunday, February 08, 2009 1:48 AM
  Subject: [suse-oracle] OCFS2, blockdev and readahead


  Greetings, listers



  Oracle 10.2.0.2, OCFS2, single instance database, NetApp FCP disks



  filesystemio_options=setall

  db_file_multiblock_read_count=128



  Do we need to set readahead to greater than 0 for OCFS2? What would be ideal value? How to measure impact - 
positive/negative?



  Storage admins would prefered "blockdev --setra" to be set to maximum value, to speed up filesystem backups. On the 
other hand, since oracle will use O_DIRECT on OCFS2, I believe we don't need readahead to be set.



  Thanks in advance,

  Vladimir Barac
  Database administrator | Alghanim Industries
  P.O. Box 223, Safat 13003, Kuwait
  Tel: +965 1881 111  / ext. 2960





  ______________________________________________________________________
  This e-mail message and any attachments to it are for the sole use of the intended recipients and may contain 
confidential and privileged information. This e-mail message and any attachments are the property of Yusuf A. Alghanim & 
Sons w.l.l. or any of its subsidiaries or affiliates ("Alghanim Industries"). Any unauthorized review, use, disclosure, 
or distribution of this e-mail message or its attachments is prohibited. Any opinions expressed in this message are 
those of the author and do not necessarily reflect the opinion of Alghanim Industries. If you are not an intended 
recipient, please notify the sender by reply e-mail and destroy all copies of the original message and any attachments.
  ______________________________________________________________________



------------------------------------------------------------------------------


  _______________________________________________
  suse-oracle mailing list
  [email protected]
  http://listx.novell.com/mailman/listinfo/suse-oracle

_______________________________________________
suse-oracle mailing list
[email protected]
http://listx.novell.com/mailman/listinfo/suse-oracle