Re: accurately reporting pga size in solaris.
- From: "Zhu,Chao" <zhuchao@xxxxxxxxx>
- To: BN <bnsarma@xxxxxxxxx>
- Date: Fri, 2 Nov 2007 22:34:16 +0800
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@xxxxxxxxx> wrote:
>
>
>
> On 10/22/07, Zhu,Chao <zhuchao@xxxxxxxxx> 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
Other related posts:
