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

Home -> Community -> Mailing Lists -> Oracle-L -> PGA size discrepancy

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

Original text of this message

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