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

Home -> Community -> Usenet -> c.d.o.server -> Re: Memory Usage in Oracle

Re: Memory Usage in Oracle

From: EscVector <Junk_at_webthere.com>
Date: 11 Jan 2007 14:16:46 -0800
Message-ID: <1168553805.923295.113100@77g2000hsv.googlegroups.com>

jeffchirco_at_gmail.com wrote:
> Oh and the system does not page.

You are top posting, someone will yell at you....

Have you checked which processes are eating up your memory at the os level.
I mean, which Oracle process is actually eating up the memory and then check that in v$session/v$process?

This would be a good start.

Run nmon for the period in question and then process via the nmon analyzer.
http://www-128.ibm.com/developerworks/aix/library/au-analyze_aix/

select * from dictionary where table_name like '%PGA%'; Check v$pgastat

Example from AIX system dev system:
5.3.0.42
AIX53
Architecture PowerPC Implementation POWER5 64 bit

17:07:49 SYS_at_test> select * from v$pgastat;

NAME
VALUE UNIT


19 rows selected. Received on Thu Jan 11 2007 - 16:16:46 CST

Original text of this message

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