Re: OS Paging/performance question

If you are using statspack, you may want to check there for PGA memory usage. The query below will show how much memory is being used at any one time.

Also, what is the total memory utilization on the machine?

You can check this with perfmon or tsk manager.

Jared

select

   sum(stat.value) valuesum
from v$sesstat stat, v$statname name
where

   stat.statistic# = name.statistic#
   and name.name = 'session pga memory'
/

On Tue, 21 Sep 2004 09:04:34 -0600, Justin Cave <justin_at_askddbc.com> wrote:
> Are you measuring "memory allocated" based on the SGA alone? Or are you
> adding in all the PGA's as well? Batch processing implies DSS, which means
> that your SGA's may end up being larger than your PGA's. Do you have a
> PGA_AGGREGATE_TARGET defined?
>
> Justin Cave <jcave_at_ddbcinc.com>
> Distributed Database Consulting, Inc.
> http://www.ddbcinc.com/askDDBC
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Ed
> Sent: Tuesday, September 21, 2004 11:01 AM
> To: oracle-l_at_freelists.org
> Subject: OS Paging/performance question
>
> Looking for some advice here.
>
> Windows 2000
> Oracle 9.2.0.4
>
> We are running several instances on the machine, but the memory
> allocated to them is far under the RAM available. ie. I shouldn't be OS
> paging as far as I can tell. I have even shut down instances to reduce
> the Oracle memory demands to much less than half the machine's RAM (4
> gig total RAM), but I'm still paging like crazy.
>
> Nonetheless, Windows Performance Monitor shows "pages/sec" going as high
> as 1500 sometimes when large batch jobs are running against the
> database. Jobs that used to run in 4 hours now run over 24 and
> sometimes fail.
>
> In addition, I have massive "db file sequential read" wait events in the
> database doing the large batch jobs, but my DB Cache Hit Ratios are over
> 90%. I don't think Oracle's tuning utilities are going to help me
> figure this one out. Any ideas? Hopefully I'm just missing something
> very obvious.
>
> The OS paging in particular is really bothering me!
>
> Thanks in advance for your time.
>
> Edward Simmonds
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l