Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Total memory usage sum

226032Sep 7 2011 — edited Sep 8 2011
My system is Windows 2003. Task managers reports 10.173.188K in "Mem Usage" and 33.638.920K in "VM Size"

From above i don't see why i'm using 33GB of RAM, could this by a memory leak? how do confirm?
thanks
JN
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> show sga

Total System Global Area 8992587776 bytes
Fixed Size                  2092040 bytes
Variable Size            1526727672 bytes
Database Buffers         7449083904 bytes
Redo Buffers               14684160 bytes
SQL>
SQL>
SQL> select sum(pga_used_mem), sum(pga_alloc_mem), sum(pga_max_mem) from v$process;

SUM(PGA_USED_MEM) SUM(PGA_ALLOC_MEM) SUM(PGA_MAX_MEM)
----------------- ------------------ ----------------
       2254782768         2956709500       3698110372

SQL>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2011
Added on Sep 7 2011
7 comments
439 views