Re: Oracle memory allocation on Linux 2.6
Date: Thu, 3 Apr 2008 10:28:10 -0700 (PDT)
On Apr 3, 1:28 am, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> On Wed, 02 Apr 2008 03:20:27 -0700, vitalisman wrote:
> > On 9i, filesystemio_options=none (default) and Oracle binaries are not
> > linked for AIO (default, at least with RAC). I'm in the process of
> > testing AIO and DIO on RAC 9i following Oracle support questions, but
> > the first attempts gave way to some instance internal errors... I've
> > asked the support if this is really a supported configuration (at least
> > with OCFS1, it was not, apparently.)
> > Thanks Mladen for your answer!
> Jerome, direct I/O should lower memory consumption simply because it
> bypasses buffer cache over which we have no control. you still can control
> the amount of consumed memory through
> - min_free_kbytes,
> - dirty_background_ratio,
> - dirty_expire_centisecs
> - dirty_writeback_centisecs.
> You cannot control the size of cache components (like buffer cache) but
> you can control behavior and overall limit with min_free_kbytes. It's
> essentially the same approach as the one taken by oracle. You can
> determine an overall lump of memory that you want to use, but not the
> structure of that lump. The structure will be adjusted by some AI
> predictive component of the software. So far, the "I" part is failing
> miserably in both cases. With Linux, I really have a problem with the
> "OOM killer" component. I cannot see how would that be superior to the
> traditional mechanisms for fine-tuning the memory allocation. I used to
> work on an ancient and arcane OS, the best one I've ever seen, called
> "VAX/VMS". I started with the version 4.2 and the last version that I used
> was 5.5-2. Believe it or not, VAX/VMS used to have far superior monitoring
> tools and memory tuning mechanisms to any of modern Unix systems. Linux
> systems are far inferior to things like AIX 5.3, HP-UX 11.11 or Solaris
> 10 and those systems are, in turn, far inferior to VAX/VMS.
I started with 3.something, having been a RSTS pro. What I don't understand is why the Cutler group didn't put those mechanisms in NT - or did they, and the Elbonians didn't know what to do with them?
Of course, I thought VMS was unnecessarily verbose in administration and slow with I/O at that time, hence DEC's prediliction for forcing people off of superior performing PDP's (PDP 11/70 v. VAX 750)...
Having worked with RSTS, VMS, some Windows, and various unix, I find my bias fairly consistent towards unix, even the jurassic parts seem better - just in general being able to edit a text file rather than a registry or GUI helps feed my feeling of control.
> I believe that the root of the evil is in the crusade against expensive
> administrators. DBA personnel, as well as system administrators are
> considered "expensive" and disliked by the modern management. Just as
> there is a tendency to cut the number of expensive workers in automobile
> industry, there is also a tendency to replace everybody by "business
> professionals", people programming with Hibernate and Tapestry for
> WebLogic or JBoss, knowing next to nothing about databases or the
> underlying OS. That's the real spirit of Windows platform, as well as the
> Linux platform. If I understand the business correctly, what is wanted is
> the system that can be used and administered by Elbonians. Fortunately for
> us, the effect is precisely the opposite. Oracle11 is the most complex
> database to date and Linux 2.6 is the most problems-prone Linux version
> ever. You need better administrators than ever, fewer and fewer are up to
> the task. I will not shed a tear over a demise of Linux, when that
> happens. However, don't be mistaken: the industry will succeed,
> eventually. They succeeded in the automobile industry, there is no reason
> to doubt the progress and the prospect of the ultimate victory for idiots.
> HAL 9000 awaits us.
Depends how you define victory. In dollars, technical superiority is rarely the determinant.
Not sure what you mean by succeeded in the automobile industry, manufacturing capacity planning is AFU there, labor cost control still has a long way to go. US economy will even impact Toyota. Chrysler, Land Rover, Jaguar, Aston-Marton have all been bought with inflated IT (that would be Tata), oil and casino dollars at fire-sale prices. Design (Nissan, Chrysler) and luxury (Ford Premier) centers on the US west coast are being "consolidated" towards Detroit, England and Japan. Things aren't going to improve any time soon.
HAL 9000? More likely 2010, a Stooges Odyssey. http://thedailywtf.com/Articles/Youll-Need-to-Come-Downtown.aspx
-- @home.com is bogus. Right in front of the bank I saved my pennies at as a kid. But why has no one mentioned the jet fuel pipeline that runs right under Sepulveda there? http://www.latimes.com/news/local/la-me-explosion29mar29,0,5311983.storyReceived on Thu Apr 03 2008 - 12:28:10 CDT