How much physical memory is Oracle using?

[Haitham Hamad]

I ran the following command

ps -efl | grep oracle| awk '{T+=$10} END {print T}'

$10 is sz from the output of the ps -efl command. It gave me a value of 79488. The man pages says this is number of physical pages. Does this mean this is 317952 KB > my RAM??

[harry d brown jr]

With a physical page = 4096, that would put your sum of oracle processes just about 70mb over the amount of memory you have. Do both servers have the same patches installed, and are they identical in hardware?

This is a small oracle DB, right?

live free or die
harry

[Haitham Hamad]

Both servers are identical having HP 11.0 and Oracle 8.1.7. with same set of patches. I thought sz gives the physical pages, how come the total is larger than my RAM?. My ultimate goal from these questions is to understand HP's memory allocation and management

[harry d brown jr]

Physical memory + swap = virtual memory.

That allows you to "pretend" that you have more memory than you really have.

So, how big is your swap areas?

swapinfo


live free or die
harry

[Haitham Hamad]

I have 1G of swap area. Are you saying that the total from ps -elf is relative to virtual memory?