accurately reporting pga size in solaris. 2007-11-02 - By Zhu,Chao
Back
This is far away from the real oracle pga usage;
Another guy told me v$process_memory in 10g is pretty close. In 9i it does
not work.
not much knowledge updated about 10g, and 11g is out!
On 10/23/07, BN <bnsarma@(protected)> wrote:
>
>
>
> On 10/22/07, Zhu,Chao <zhuchao@(protected)> wrote:
> >
> > hi, all,
> > I am wondering whether there is any tool that can report the
> > accurate PGA size of oracle database, when database has several thousands of
> > processes. I have a small tool to pmap every process to get the sum of
> > [heap|anon}] pages, but it does not work when we have lots of process.
> > Or maybe there is any existing Dtrace script that can do this?
> >
> > --
> > Regards
> > Zhu Chao
> > www.cnoug.org
> >
>
>
> Greetings
>
> HAve you looked at these:
>
>
> clear columns
>
> col SID FOR 99999
> col name for a45
> col username for a10
> col osuser for a12
> break ON report
> compute sum OF "MB" ON report
>
> SELECT NAME, round(value/1024/1024) "Mb" FROM V$PGASTAT;
>
> col name for a23
> col "Mb" FOR 99999
>
> SELECT se.sid,se.username,se.osuser,name, round(value/(1024*1024))
> "Mb",sysdate
> FROM v$session se, v$sesstat ss, v$statname sn
> WHERE ss.sid=se.sid
> AND sn.statistic# = ss.statistic#
> AND sn.name = 'session pga memory'
> -- GROUP BY name,se.sid,se.username,se.osuser,name
> order by value
> /
>
>
> Regards
> BN
>
>
> --
> Regards & Thanks
> BN
>
--
Regards
Zhu Chao
www.cnoug.org
This is far away from the real oracle pga usage; <br>Another guy told me v
$process_memory in 10g is pretty close. In 9i it does not work.<br>not much
knowledge updated about 10g, and 11g is out!<br><br><div><span class="gmail
_quote">
On 10/23/07, <b class="gmail_sendername">BN</b> <<a href="mailto:bnsarma
@(protected)">bnsarma@(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>
<div><span class="q"><span class="gmail_quote">On 10/22/07, <b class="gmail
_sendername">Zhu,Chao</b> <<a href="mailto:zhuchao@(protected)" target="_blank"
onclick="return top.js.OpenExtLink(window,event,this)">zhuchao@(protected)
</a>> wrote:</span>
</span><div><span class="e" id="q_115cd549ebd2f44d_2"><blockquote class="gmail
_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0
.8ex; padding-left: 1ex;">hi, all,<br> I am wondering whether
there is any tool that can report the accurate PGA size of oracle database,
when database has several thousands of processes. I have a small tool to pmap
every process to get the sum of [heap|anon}] pages, but it does not work when
we have lots of process.
<br> Or maybe there is any existing Dtrace script that can do this?
<br clear="all"><span><br>-- <br>Regards<br>Zhu Chao<br><a href="http://www
.cnoug.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this
)">
www.cnoug.org</a><br></span></blockquote></span></div></div>
<div><br> </div>
<div>Greetings</div>
<div> </div>
<div>HAve you looked at these:</div>
<div> </div>
<p>clear columns</p>
<p>col SID FOR 99999<br>col name for a45<br>col username for a10<br>col osuser
for a12<br>break ON report<br>compute sum OF "MB" ON report</p>
<p>SELECT NAME, round(value/1024/1024) "Mb" FROM V$PGASTAT;</p>
<p>col name for a23<br>col "Mb" FOR 99999</p>
<p>SELECT se.sid,se.username,se.osuser,name, round(value/(1024*1024)) "Mb
",sysdate<br>FROM v$session se, v$sesstat ss, v$statname sn<br>WHERE ss.sid
=se.sid<br>AND sn.statistic# = ss.statistic#<br>AND <a href="http://sn.name"
target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
sn.name</a> = 'session pga memory'<br>-- GROUP BY name,se.sid,se
.username,se.osuser,name<br>order by value<br>/</p>
<p> </p>
<div>Regards</div>
<div>BN</div>
<div><br clear="all"><br>-- <br>Regards & Thanks<br>BN </div>
</blockquote></div><br><br clear="all"><br>-- <br>Regards<br>Zhu Chao<br><a
href="http://www.cnoug.org">www.cnoug.org</a><br>
|
|
