RE: AIX 5.2 move from JFS to JFS2

Patty,

Of course, since you just moved from 9.2 to 10.2, you mean db_cache_size, not db_block_buffers, right? ;-) I don't have any firsthand experience w/ JFS2, however, yes, in general, it's certainly possible to see physical I/O increase, as Oracle now has to physically hit disk for data that was previously cached in the filesystem buffer cache. This is ok though, the idea is that Oracle is much smarter about caching stuff than the filesystem is, since it has more information. So, there should have been some memory freed up, when you moved to JFS2 and CIO. That memory should be allocated to the database buffer cache, to compensate. In the end, you should come out ahead. Finally, if you really want to get bang for your buck on caching, you may consider implementing a keep and a recycle pool. I have done this to great effect in the past.

Hope that helps,

-Mark

Mark J. Bobak
Senior Oracle Database Administrator, System & Product Technologies ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346
734.997.4059 or 800.521.0600 x 4059
mark.bobak_at_il.proquest.com
www.proquest.com
www.csa.com

ProQuest...Start here.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Patty.Charlebois_at_greenshield.ca Sent: Wednesday, June 27, 2007 8:47 AM
To: Oracle-L_at_freelists.org
Subject: AIX 5.2 move from JFS to JFS2

Now that I have upgraded our production systems from 9.2.0.7 to 10.2.0.3 I can see via truss that Oracle is taking advantage of our newly implemented JFS2 filesystems and opening the datafiles using CIO.

We are experiencing higher WIO percentages since the upgrade.

My sysadmn has suggested that perhaps I need to increase db_block_buffers to make up for the lack of buffering at the FS level now that we are using JFS2.

Does anyone have any experience and/or thoughts regarding this?

TIA,
 Patty

This e-mail is confidential, intended solely for the use of the recipient(s) to whom it was addressed. If you have received it in error, please do not copy or distribute this e-mail. We ask that you notify us immediately by replying to the sender and then delete this e-mail. E-mail sent or received over the internet may not be secure. You should use caution when sending e-mail messages containing private and confidential information or consider other secure means to send the information. If you have any questions regarding the authenticity or security of the e-mail you have received please do not hesitate to contact us at 1-800-265-5615.

Ce message de courriel est confidentiel et s'adresse uniquement à la personne indiquée. Si vous l'avez reçu par erreur, veuillez ne pas copier ni distribuer ce message de courriel. Nous vous demandons de nous aviser immédiatement en répondant à l'expéditeur, puis en supprimant ce message. Les messages envoyés ou reçus par courriel pourraient ne pas être sécurisés. Vous devriez être prudent lorsque vous envoyez des messages de courriel contenant des renseignements confidentiels et privés ou songer à prendre d'autres moyens sécurisés pour envoyer les renseignements. Si vous avez des questions concernant l'authenticité ou la sécurité d'un courriel que vous avez reçu, n'hésitez pas à communiquer avec nous au 1 800 265-5615.
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jun 27 2007 - 08:38:37 CDT