LD_PRELOAD 2007-11-02 - By Mark Brinsmead
Back
I don't know a thing about LD_PRELOAD, but here is a link to an example of
how it might be used to diagnose performance issues:
http://developers.sun.com/solaris/articles/lib_interposers.html
I would expect that this would only be useful, though, if you know a lot
about the implementation of the program you are going to use it on. Without
source code for Oracle, it might be of rather limited use.
The only other benefit I can imagine is perhaps using this to move a shared
library (very) commonly used by Oracle to the front of the list. I've never
heard anybody talk about time to load shared libraries as a major
contributor to Oracle overhead, though, except perhaps in cases where your
applications are making very frequent connections to the database. Most
people address that problem with connection pooling and similar techniques,
though.
Anyway, I'm kind of curious to learn what your sysadmins have in mind. Let
us know if anything useful comes of this.
On 11/2/07, Best, David <David.Best@(protected)> wrote:
>
>
>
> Hey all, has anyone ever used LD_PRELOAD to resolve performance issues?
> Our Unix guy says that they have used this setting in the past with
> great results. I've searched metalink and the documentation but
> haven't seen anything for performance. The main reason for its use, that
> I can see, is to resolve some shared library errors.
>
> Thanks
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
Cheers,
-- Mark Brinsmead
Senior DBA,
The Pythian Group
http://www.pythian.com/blogs
I don't know a thing about LD_PRELOAD, but here is a link to an example of
how it might be used to diagnose performance issues:<br><a href="http:/
/developers.sun.com/solaris/articles/lib_interposers.html">http://developers.sun
.com/solaris/articles/lib_interposers.html
</a><br><br>I would expect that this would only be useful, though, if you know
a lot about the implementation of the program you are going to use it on.
Without source code for Oracle, it might be of rather limited use.<br>
<br>The only other benefit I can imagine is perhaps using this to move a shared
library (very) commonly used by Oracle to the front of the list. I've
never heard anybody talk about time to load shared libraries as a major
contributor to Oracle overhead, though, except perhaps in cases where your
applications are making very frequent connections to the database. Most
people address that problem with connection pooling and similar techniques,
though.
<br><br>Anyway, I'm kind of curious to learn what your sysadmins have in
mind. Let us know if anything useful comes of this.<br><br><div><span
class="gmail_quote">On 11/2/07, <b class="gmail_sendername">Best, David</b>
<<a href="mailto:David.Best@(protected)">David.Best@(protected)</a>> wrote
:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204,
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br><br>
Hey all, has anyone ever used LD_PRELOAD to resolve performance issues?<br>Our
Unix guy says that they have used this setting in the past with<br>great
results. I've searched metalink and the documentation but<br
>haven't seen anything for performance. The main reason for its use, that
<br>I can see, is to resolve some shared library errors.<br><br>Thanks<br>--<br
><a href="http://www.freelists.org/webpage/oracle-l">http://www.freelists.org
/webpage/oracle-l</a><br><br><br></blockquote></div><br><br clear="all">
<br>-- <br>Cheers,<br>-- Mark Brinsmead<br> Senior DBA,<br>
The Pythian Group<br> <a href="http://www.pythian.com/blogs"
>http://www.pythian.com/blogs</a>
|
|
