Re: Oracle memory allocation on Linux 2.6
- From: joel garry <joel-garry@xxxxxxxx>
- Date: Thu, 3 Apr 2008 10:28:10 -0700 (PDT)
On Apr 3, 1:28 am, Mladen Gogala <mgog...@xxxxxxxxx> 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
jg
--
@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.story
.
- References:
- Oracle memory allocation on Linux 2.6
- From: vitalisman
- Re: Oracle memory allocation on Linux 2.6
- From: Mladen Gogala
- Re: Oracle memory allocation on Linux 2.6
- From: vitalisman
- Re: Oracle memory allocation on Linux 2.6
- From: Mladen Gogala
- Oracle memory allocation on Linux 2.6
- Prev by Date: Pass a variable into procedure to use as column in select statement
- Next by Date: Re: Large tables, updates, selects and varchars
- Previous by thread: Re: Oracle memory allocation on Linux 2.6
- Next by thread: Re: Oracle memory allocation on Linux 2.6
- Index(es):
Relevant Pages
|
