Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Memory Usage in Oracle
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