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

Home -> Community -> Usenet -> c.d.o.server -> Re: Background Processes and I/O

Re: Background Processes and I/O

From: Geomancer <pharfromhome_at_hotmail.com>
Date: 21 Dec 2003 06:07:14 -0800
Message-ID: <cf90fb89.0312210607.2017d3f2@posting.google.com>


> I thought they all did, except CKPT which tells DBWn to do it, and PMON
> which only works with memory structures.

If you are on 9i, you can measure the RAM used by the Oracle background processes:

select

   program,

   pga_used_mem, 
   pga_alloc_mem, 
   pga_max_mem 

from

   v$process; Received on Sun Dec 21 2003 - 08:07:14 CST

Original text of this message

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