Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> accurately reporting pga size in solaris.

accurately reporting pga size in solaris.

From: Zhu,Chao <zhuchao_at_gmail.com>
Date: Mon, 22 Oct 2007 21:31:30 +0800
Message-ID: <962cf44b0710220631i2489fac7x6acc9e1b74693e5f@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 22 2007 - 08:31:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US