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