 | | | -none- | -none- 2007-08-15 - By Alvaro Jose Fernandez
Back
Also (aside note), there are one bug in 10.2.0.3 related to hash joins using
excess memory (above pga_aggregate_target).
I recommend getting a "snap" at peak time with the SQLAREAT tools from Carlos
Sierra of Oracle (Note 238684.1) . This tool is great to detect improper PGA
memory usage/bad plans.
Also a statspack snap would reveal if there's something wrong (multipass execs
from the PGA report).
regards,
?lvaro Fern?ndez
Departamento de Sistemas_
__ ____ ____ ____ ____ ____ ____
SIVSA, Soluciones Inform?ticas S.A.
Arenal n? 18 ? 3? Planta ? 36201 ? Vigo
Tel?fono: (+34) 986 092 100
Fax: (+34) 986 092 219
e-mail: alvaro.fernandez@(protected)
www.sivsa.com <http://www.sivsa.com/>
Espa?a_
****************************** ADVERTENCIA LEGAL ****************************
En cumplimiento de la Ley de Servicios de la Sociedad de la Informaci?n y de
Comercio Electr?nico (LSSI-CE), y de la vigente Ley Org?nica 15/1999 de 13 de
Diciembre de Protecci?n de Datos de Car?cter Personal (LOPD), le informamos que
su direcci?n de correo electr?nico figura en este momento en la base de datos
de SIVSA, Soluciones Inform?ticas, S.A, con domicilio en la calle Areal n? 18
- 3? planta, Vigo (Pontevedra), que, como responsable del fichero, le garantiza
el ejercicio de sus derechos de acceso, rectificaci?n, cancelaci?n y oposici?n
de los datos facilitados, en los t?rminos y condiciones previstos en la propia
LOPD, mediante una comunicaci?n por escrito dirigida a la direcci?n indicada, a
la atenci?n del "Departamento de Administraci?n". De no ser as?, se entiende
que usted consiente expresamente que sus datos puedan ser utilizados por SIVSA
con fines publicitarios, promocionales y de marketing, en relaci?n con sus
propios productos y servicios.
Este mensaje va dirigido, de manera exclusiva, a su destinatario y contiene
informaci?n confidencial y sujeta al secreto profesional, cuya divulgaci?n no
est? permitida por la ley. En caso de haber recibido este mensaje por error, le
rogamos que, de forma inmediata, nos lo comunique mediante correo electr?nico
remitido a nuestra atenci?n o a trav?s del tel?fono (+ 34) 986 092 100 y
proceda a su eliminaci?n, as? como a la de cualquier documento adjunto al mismo
. Asimismo, le comunicamos que la distribuci?n, copia o utilizaci?n de este
mensaje, o de cualquier documento adjunto al mismo, cualquiera que fuera su
finalidad, est?n prohibidas por la ley."
__ ____ ____ ____ ____ ____ ____
De: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] En
nombre de Greg Norris
Enviado el: mi?rcoles, 15 de agosto de 2007 15:53
Para: ORACLE-L
Asunto: determine total memory used by Oracle via OS tools
I'm looking for a good way to determine total Oracle memory usage, taking
shared memory into account, using standard Unix/Linux tools. I can, of course,
easily determine how much memory the database is configured to use, but need
something which indicates how much the OS has actually allocated. Any
suggestions?
Here's a little background. We recently had an outage on one of our 10.2.0.3
databases running under SunOS 5.10, for which our SysAdmin believes the root
cause to be Oracle using all available virtual memory. I'm somewhat skeptical,
however, since the problem didn't go away after shutting down the database
(shutdown immediate) and listener...normal operation was restored only after
rebooting the server. In addition, I've learned that he used the "prstat -t"
command to make this determination, which doesn't distinguish between shared
and non-shared memory (thereby grossly over-reporting the usage).
At this point we've opened a SR with Oracle to followup on the outage itself,
but I need to be able to provide an alternate (useful) command for determining
memory usage at the OS level next time this sort of thing comes up.
Thanx!
--
"I'm too sexy for my code." - Awk Sed Fred.
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1=
"urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC
-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859 (See http://iso-8859.ora-code.com)-1">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
{font-family:Tahoma;
panose-1 (See http://ose-1.ora-code.com):2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
address
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";
font-style:italic;}
pre
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EstiloCorreo17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@(protected) Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=ES link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Also (aside note), there are one bug in
10.2.0.3 related to hash joins using excess memory (above pga_aggregate_target)
.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I recommend getting a “snap” at
peak time with the SQLAREAT tools from Carlos Sierra of Oracle (Note 238684.1)
. This tool is great to detect improper PGA memory usage/bad plans.<o:p></o:p><
/span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Also a statspack snap would reveal if
there’s something wrong (multipass execs from the PGA report).<o:p></o:p>
</span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>regards, <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<address style='margin-right:2.2pt'><i><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> </span>
</font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></i></address>
<address style='margin-right:2.2pt'><i><font size=2 color=navy
face="Times New Roman"><span style='font-size:10.0pt;color:navy'> </span><
/font></i><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>?lvaro Fern?ndez</span></font><font color=navy><span
style='color:navy'><o:p></o:p></span></font></address>
<address style='margin-right:2.2pt'><i><font size=2 color=navy face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:navy'> Departamento de
Sistemas_</span></font><font color=navy><span style='color:navy'><o:p></o:p><
/span></font></i></address>
<address style='margin-right:2.2pt'><i><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'> <o:p></o
:p></span></font></i></address>
<address style='margin-right:2.2pt'><i><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'><img width=86
height=28 id="_x0000_i1026" src="cid:image001.jpg@(protected)"><o:p></o:p
></span></font></i></address>
<div class=MsoNormal align=center style='text-align:center'><font size=3
color=navy face="Times New Roman"><span style='font-size:12.0pt;color:navy'>
<hr size=2 width="100%" align=center>
</span></font></div>
<address style='margin-right:2.2pt'><b><i><font size=2 color=navy face=Arial>
<span
style='font-size:10.0pt;font-family:Arial;color:navy;font-weight:bold'>SIVSA,
Soluciones Inform?ticas S.A. </span></font></i></b><font color=navy><span
style='color:navy'><o:p></o:p></span></font></address>
<address style='margin-right:2.2pt'><i><font size=1 color=navy face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:navy'>Arenal n? 18 ? 3? Planta ?
36201 ? Vigo </span></font><font color=navy><span style='color:navy'><o:p></o:p
></span></font></i></address>
<address style='margin-right:2.2pt'><i><font size=1 color=navy face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:navy'>Tel?fono: (+34) 986
092 100 </span></font><font color=navy><span style='color:navy'><o:p
></o:p></span></font></i></address>
<address style='margin-right:2.2pt'><i><font size=1 color=navy face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:navy'>Fax: (+34) 986 092
219</span></font><font color=navy><span style='color:navy'><o:p></o:p></span><
/font></i></address>
<address style='margin-right:2.2pt'><i><font size=1 color=navy face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:navy'>e-mail: </span></font></i>
<font
size=1 color=blue><span style='font-size:7.5pt;color:blue'><a
href="mailto:alvaro.fernandez@(protected)">alvaro.fernandez@(protected)</a></span><
/font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></address>
<address style='margin-right:2.2pt'><i><font size=1 color=blue face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:blue'><a
href="http://www.sivsa.com/" title="http://www.sivsa.com/"><font
face="Times New Roman"><span style='font-family:"Times New Roman"'><span
title="http://www.sivsa.com/">www.sivsa.com</span></span></font></a></span><
/font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></i></address>
<address style='margin-right:2.2pt'><i><font size=1 color=navy face=Arial><span
style='font-size:7.5pt;font-family:Arial;color:navy'>Espa?a_</span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></i></address>
<address style='margin-right:2.2pt'><i><font size=3 color=navy
face="Times New Roman"><span style='font-size:12.0pt;color:navy'> <o:p></o
:p></span></font></i></address>
<div><pre><font size=2 color=navy face="Courier New"><span style='font-size:
10.0pt;color:navy'>******************************? ADVERTENCIA LEGAL? *********
*******************<o:p></o:p></span></font></pre></div>
</div>
<div>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=640
style='width:480.0pt' id=table1>
<tr>
<td width="100%" style='width:100.0%;padding:.75pt .75pt .75pt .75pt'>
<p><em><i><font size=1 color=black face=Arial><span lang=ES-TRAD
style='font-size:8.0pt;font-family:Arial;color:black;font-style:normal'>En
cumplimiento de <st1:PersonName ProductID="la Ley" w:st="on">la Ley</st1
:PersonName>
de Servicios de <st1:PersonName ProductID="la Sociedad" w:st="on">la Sociedad
</st1:PersonName>
de <st1:PersonName ProductID="la Informaci?n" w:st="on">la Informaci?n</st1
:PersonName>
y de Comercio Electr?nico (LSSI-CE), y de la vigente Ley Org?nica 15/1999 de
13 de Diciembre de Protecci?n de Datos de Car?cter Personal (LOPD),
le informamos que su direcci?n de correo electr?nico figura en este
momento en la base de datos de SIVSA, Soluciones Inform?ticas,
S.A, con domicilio en la calle Areal n? 18 - 3? planta, Vigo
(Pontevedra), que, como responsable del fichero, le garantiza el
ejercicio de sus derechos de acceso, rectificaci?n, cancelaci?n y
oposici?n de los datos facilitados, en los t?rminos y condiciones previstos
en la propia LOPD, mediante una comunicaci?n por escrito dirigida a la
direcci?n indicada, a la atenci?n del "Departamento
de Administraci?n". De no ser as?, se entiende que usted
consiente expresamente que sus datos puedan ser utilizados por
SIVSA con fines publicitarios, promocionales y de marketing, en relaci?n con
sus propios productos y servicios.</span></font></i></em><font color=navy>
<span
lang=ES-TRAD style='color:navy'> </span><o:p></o:p></font></p>
<p class=MsoNormal><em><i><font size=1 color=black face=Arial><span
lang=ES-TRAD style='font-size:8.0pt;font-family:Arial;color:black;font-style:
normal'>Este mensaje va dirigido, de manera exclusiva, a su destinatario y
contiene informaci?n confidencial y sujeta al secreto profesional, cuya
divulgaci?n no est? permitida por la ley. En caso de haber recibido este
mensaje por error, le rogamos que, de forma inmediata, nos lo comunique
mediante correo electr?nico remitido a nuestra atenci?n o a trav?s del
tel?fono (+ 34) 986 092 100 y proceda a su eliminaci?n, as? como a la de
cualquier documento adjunto al mismo. Asimismo, le comunicamos que la
distribuci?n, copia o utilizaci?n de este mensaje, o de cualquier documento
adjunto al mismo, cualquiera que fuera su finalidad, est?n prohibidas por la
ley.</span></font></i></em><font size=1 color=black face=Arial><span
lang=ES-TRAD style='font-size:8.0pt;font-family:Arial;color:black'>"<
/span></font><font
color=navy><span style='color:navy'><o:p></o:p></span></font></p>
</td>
</tr>
</table>
</div>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>De:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <b><span
style='font-weight:bold'>En nombre de </span></b>Greg Norris<br>
<b><span style='font-weight:bold'>Enviado el:</span></b> mi?rcoles, 15 de
agosto de 2007 15:53<br>
<b><span style='font-weight:bold'>Para:</span></b> ORACLE-L<br>
<b><span style='font-weight:bold'>Asunto:</span></b> determine total memory
used by Oracle via OS tools</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I'm looking for a good way to determine total Oracle memory usage,
taking shared memory into account, using standard Unix/Linux tools. I
can, of course, easily determine how much memory the database is <i><span
style='font-style:italic'>configured</span></i> to use, but need something
which indicates how much the OS has actually allocated. Any suggestions?
<br>
<br>
Here's a little background. We recently had an outage on one of our <a
href="http://10.2.0.3">10.2.0.3</a> databases running under SunOS 5.10, for
which our SysAdmin believes the root cause to be Oracle using all available
virtual memory. I'm somewhat skeptical, however, since the problem didn't
go away after shutting down the database (shutdown immediate) and
listener...normal operation was restored only after rebooting the server.
In addition, I've learned that he used the "prstat -t" command to
make this determination, which doesn't distinguish between shared and
non-shared memory (thereby grossly over-reporting the usage). <br>
<br>
At this point we've opened a SR with Oracle to followup on the outage itself,
but I need to be able to provide an alternate (useful) command for determining
memory usage at the OS level next time this sort of thing comes up. <br>
<br>
Thanx!<br clear=all>
<br>
-- <br>
"I'm too sexy for my code." - Awk Sed Fred.<o:p></o:p></span></font><
/p>
</div>
</body>
</html>
|
|
|