FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 21, '05 at 1:40a
activeOct 21, '05 at 1:40a
posts1
users1
websiteoracle.com

1 user in discussion

DBA Deepak: 1 post

People

Translate

site design / logo © 2022 Grokbase