PGA size discrepancy

From: DBA Deepak <oracle.tutorials_at_gmail.com>
Date: Fri, 21 Oct 2005 12:08:04 +0530
Message-ID: <75aa80160510202338h752dc0e1m91d5ed01b31cbd36@mail.gmail.com>

Hi All,

I executed the following statements.

SQL> select * from v$version;

BANNER

---

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production

SQL> select name,VALUE/(1024*1024) MB from v$sysstat 2 where name like '%pga%';

NAME MB

---------------------------------------------------------------- ----------

session pga memory 18184.7367
session pga memory max 19962.1279

SQL> sho parameter pga

NAME TYPE VALUE

------------------------------------ -----------
------------------------------

pga_aggregate_target big integer 24M

One query:

> The session pga memory & session pga memory max values are looking unreal
as we do not have this much amount of Physical memory. And the pga_aggregate_target is 24M only.

What might be the issue?

--
Regards,

Deepak
Oracle DBA

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 21 2005 - 01:40:31 CDT