> -- --Original Message-- -- > From: Sightler, Tom [mailto:tsightler@(protected)] snip > > To me open files looks low at 1024, but our old system is > set this way > > and never hung once. > > Did your old system run the same OS and same version of > Oracle with async IO? If not then it's probably not fair to > compare the two. Oracle version was the same, but we ran SuSE 8 PRO not SLES and had no async IO.
> I'd at least look at this as, based on your proc output, your Snip Good advice. > to the same as the system limit. Lot's of Oracle setup docs > suggest setting both the system file number limit and the > Oracle users ulimit to 65535 or greater. > > We used to get lots of ORA-03113 (See ORA-03113.ora-code.com) errors before we increased > our limits. Are you having some of those? Our current Yes we are, a fair amount. Usually on the second day after a reboot. They get worse and worse as time goes on.
When we restarted our server last night we set the file limit for oracle to 16384.
Thanks Andy
-- To unsubscribe, email: suse-oracle-unsubscribe@(protected) For additional commands, email: suse-oracle-help@(protected) Please see http://www.suse.com/oracle/ before posting
