accurately reporting pga size in solaris.

  • From: "Zhu,Chao" <zhuchao@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 22 Oct 2007 21:31:30 +0800

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

Other related posts: