FILE SYSTEM BUFFER IN JFS : ON OR OFF : CONCLUSION
I know I am slightly late but I have been losing some sleep and lot of patience with my project(s) so bear with me : ). The question was The ideal mounting option for ORACLE on JFS ? suggested is RBS TEMP files : mincache=dsync, convosync=dsync DATAFILES REDO files : mincache=direct,convosync=direct Before jumping to answers definition of some terms used . CONVOSYNC : This option determines how synchronous writes are treated direct : Bypassing system buffer dsync : A write operation returns to the caller after the data has been transferred to external media, but the inode is not updated synchronously if only the times in the inode need to be updated MINCACHE : The mincache mount option determines how ordinary writes are treated. Can have the same values . I did some digging around and found some details First : The answer by Steve , Unless your 'db_block_size' is 8192 then you should use direct I/O for all Oracle file systems regardless of usage. Also because Oracle explicitly requests synchronous I/O whenever it opens its datafiles, it is the convosync mount option that counts, rather than the mincache one. Indeed, if you use 'convosync=direct, mincache=dsync' you'll get buffering for trace files or other stuff that might also reside on your Oracle file systems, which is probably what you want. I can't imagine any reason why you would want buffering for rollback segment datafiles, but assuming your block size is 8K, there is a weak argument for buffering temporary segment datafiles. Namely that temporary segment writes are invariably read again, and operating system buffering may save physical I/O on the reads. Oracle does not normally buffer temporary tablespace I/O and so with operating system buffering there is no buffering at all. However, if you machine is dedicated to Oracle and you are willing to allow Oracle to use the memory directly, then a better approach is to use the memory that might otherwise be used for operating system buffering of temporary tablespace writes to increase the 'sort_area_size' and thus avoid those writes entirely. Christian Bilien : The advice given looks good to me. Online JFS must indeed be separately purchased. In light of the above and my research , DATAFILES , RBS , TEMP : mincache=direct,convosync=direct,nodetainlog REDOLOG , ARCHIVE : mincache=dsync,convosync=dsync Any comments welcome . regards , RS __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FILE SYSTEM BUFFER IN JFS : ON OR OFF
Hi List , I posted this on friday but didn't see it on the list so I am posting this again . I am redesigning a major system and particular attension is being given to filesystem configuration and IO . I got this from one supposedly top notch Unix performance tuning expert . I would like to know if anybody implemeted this and what are the impacts . The options you want are mount options available only with Online JFS (not a free product, unfortunately.) The options you want are: RBS TEMP files : mincache=dsync, convosync=dsync DATAFILES REDO files : mincache=direct, convosync=direct TIA regards, RS __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FILE SYSTEM BUFFER IN JFS : ON OR OFF
The Unix is HP-UX 11.0 64 bit Storage is XP 256 The point to note is , we are concerned about the filesystem which happens to be Veritas filesystem and the mount options available in that . --- David A. Barbour [EMAIL PROTECTED] wrote: What flavor of UNIX and what type of storage are you considering? Regards, David A. Barbour Raj Sakthi wrote: Hi List , I posted this on friday but didn't see it on the list so I am posting this again . I am redesigning a major system and particular attension is being given to filesystem configuration and IO . I got this from one supposedly top notch Unix performance tuning expert . I would like to know if anybody implemeted this and what are the impacts . The options you want are mount options available only with Online JFS (not a free product, unfortunately.) The options you want are: RBS TEMP files : mincache=dsync, convosync=dsync DATAFILES REDO files : mincache=direct, convosync=direct TIA regards, RS __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David A. Barbour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FILE SYSTEM BUFFER IN JFS : ON OR OFF
Hi List , I am in the middle of Major configuration of JFS filesystem on HP-UX 11.0 . I came across the follwing info . Could someone validate this please ? The options you want are mount options available only with Online JFS (not a free product, unfortunately.) The options you want are: RBS TEMP files : mincache=dsync, convosync=dsync DATAFILES REDO files : mincache=direct, convosync=direct TIA . regards, RS __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORACLE 816 ON WIN2000 : UPDATE
Hi Folks , Thanks for everyone who answered . I installed O816 on win2K . I wanted to post these tips on Win Platform although I always end up catching up the posts 3 days later due to busy schedule . 1.It is best to save the scripts of Database creation assistant in a batch file . 2.Configure listener for the database you are going to create and bounce the listener . 3.Configure tnsnames.ora file 4.Edit the registry - HKEY_LOCAL_MACHINE - SOFTWARE - ORACLE - HOME0 (whatevr is your home ) create a string LOCAL and set it to your SID then execute the batch file . This is to svoid the error like protocol adaptor error kind of thing . Once again thankyou list . Hope this helps . Any comments welcome. regards RS __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORACLE 816 ON WIN2000
Hi List , I am supposed to install oracle 816 on win2K ( I knowI should go for real OS !! ) I am very much of a UNIX bigot and I am looking for any pitfalls and things I should look out for . TIA . Regards, RS __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE 816 ON WIN2000
Tell me 'bout it..!!! --- Kimberly Smith [EMAIL PROTECTED] wrote: Only one real pitfall - Win2000 __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Import/Export performance
Hi RF , export is Fairly straight forward . 1.Use direct export 2.Use parallel export processes . Run your biggest table export first and fire off other exports simultaneously . Take a look at parallel download script at http://www.oriole.com/frameindexTK.html Now import is another kind of beast . Import : SERVER SIDE 1.Increase SGA as much as possible with out paging and if possible lock it in physical memory . 2. Create Large redo log files or = 3 3. No archivelog mode 4.Depending on number of parallel Exp/Imp process , create the same number of large rollback segs and bring them on line ( keep other normal ones offline ) 5.Precreate empty objects . Make all tablespace nologging and all tables nologging . 6. Disable all FK and PKs 7. Drop all indexes if you have already created them . 8. drop all triggers . 9. Finally ( I hope..!! ) run import with commit=N. Remember to fix all this when import is over . Hope this helps . Regards, RS __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: HP environment - standby db?
I would try to answer your questions by a series of observations 1. Only upto 4 ARs could be attached to a L or N class HPs. Moreover this is possible only if you daisy chain the 2 ARs which will in turn degrade the performance . 2. The Parallel server Option has to be approached with caution as it needs special application design . So if you are just looking for "High Availability" MC SERVICE GUARD is a good option . It is relatively simple compared to STANDBY DB and easy to implement and does not involve any 'Recovery' or other complications . On the other hand MCSG doesn't give you the option of opening the DB in read only mode and use it as reporting DB either . SO the decision is highly application specific . Hope this helps . Regards, RS --- Don Dealy II [EMAIL PROTECTED] wrote: Anybody out there using 2 HP servers attached to a single StoreEdge (AutoRaid) and setting up Oracle for a hot-standby db? Or are you running OPS instead of the hot-standby? Management thinking is to attach a N4000 and a L2000 servers to a 12H StoreEdge. I understand that a "HP Service Card" is required that will allow the L2000 to be the "fail to" server for the N4000. We would be starting with a 500G Oracle db, growing up to 9T at the end of 2 years. Oracle would be setup so that the L2000 would be serving the "hot standby" database. Or, should we toss the "hot standby" idea and go directly to Oracle Parallel Server? Would you care to comment on the good, the bad or the ugly to this idea? Yes, the 12H becomes the weak link in this idea, but there are budget constraints in this fiscal year that are forcing that config. In the next 2 fiscal years are monies to address the single storage device problem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Dealy II INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OraGeeks$ : SUPPORT FOR SITE
Hi Folks , I am sure some of you would be remembering "orageeks " website http://www.interealm.com/orageeks/ Well.the site owner Roby Sherman who is a frequent poster in this site has closed the site down . When I asked the reason he sent me the following . I agree with his sentiments . Thought since this a place real talent hangs out I thought some of you could chip in . " Hi Raj: More or less, I was looking for volunteers to help maintain the technical content of the directory. That means helping me with finding new resources (that weren't links to some company's product) to add to the directory on an ongoing basis, communicating with me when they found a resource that was outdated or inappropriate, help with the addition / modification of directory categories, Etc. Heck, even contributing a small technical note once in a blue moon wouldn't have hurt either. Cheers! --Roby " Cheers RS __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re: SUN vs. HP
C.S.Venkata Subramanian" scribbled with glittering crayon : I have been working with Oracle under HP, I find HP server with high fault toulerence and reliable. If we tune the OS and DB then we can get maximum performance. I can vouch for that . I have been working with HP for more than 5 years and I find it very reliable and efficient OS . One word of caution is that, if u use Mc Servicegaurd then u shud go for OPS. Which works for only on RAW partitions. Administration will not be a easy job. Not necessarily . You can use it for single instance more easily . MCSG is just a set of shell scripts allowing you to escape from hardware failure of MACHINES...not the storage unit . The conf. is 2 machines configured to recognize same mount points from the storage unit . So setup should be done carefully like the ORACLE user id and Group id's should be same on both machines . Instead go for AutoRAID box which HP has got. It converts itself bet RAID5 and RAID1/0. CAREFULL...!! This depends . Decision of using AUTORAID should be taken after carefull thought . The AR is a "BlackBox" ...literally . HP refuses to divulge any info on that . But this much is known from experience : AR starts off with RAID1 and as you put more data into it at one point when AR decides to go for RAID5 , all the applications will run into stonewall because AR is busy converting itself into RAID5 and will not process any IO requests..!!! RS __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AUDITING - DEFAULT FOR CONNECT INTERNAL
ll Rights Reserved. Legal Notices and Terms of Use. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).