UNIX for Advanced & Expert Users

hi... i want to find oracle allocate how many memory really..

i execute this code to list memory on unix system :

Code:

    ps -eo pmem,args | sort -k 1 -r -n

outputs ;

%mem command
12.9|ora_smon_RTX
12.9|ora_s000_RTX
12.9|ora_reco_RTX
12.9|ora_qmnc_RTX
12.9|ora_q002_RTX
12.9|ora_q000_RTX
12.9|ora_psp0_RTX
12.9|ora_pmon_RTX
12.9|ora_mmon_RTX
12.9|ora_mmnl_RTX
12.9|ora_mman_RTX
12.9|ora_lgwr_RTX
12.9|ora_dbw1_RTX
12.9|ora_dbw0_RTX
12.9|ora_d000_RTX
12.9|ora_ckpt_RTX
12.9|ora_cjq0_RTX
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|oracleBSPR
6.5|ora_smon_BSPR
6.5|ora_reco_BSPR
6.5|ora_qmnc_BSPR
6.5|ora_q001_BSPR
6.5|ora_q000_BSPR
6.5|ora_psp0_BSPR
6.5|ora_pmon_BSPR
6.5|ora_mmon_BSPR
6.5|ora_mmnl_BSPR
6.5|ora_mman_BSPR
6.5|ora_lgwr_BSPR
6.5|ora_dbw1_BSPR
6.5|ora_dbw0_BSPR
6.5|ora_ckpt_BSPR
6.5|ora_cjq0_BSPR

if i will sum all used memory ,it is greather then total memory of system...

i want to find real used memory for oracle ?

The column of ps you're interested in is RSS, or "resident set size". This measures only pages that actually exist and are paged in.

Let's tie this down a bit.

What Operating System and version do you have?
What version of Oracle are you using?

Because Oracle makes extensive use of Shared Memory segments and most modern versions of unix use paged memory it is remarkably difficult to find out how much memory Oracle is using. The Oracle installation manuals are very good on the subject of configuring unix and Oracle for a given memory size. It is very important to know your Oracle Database Block Size because many Oracle startup parameters are in units of Blocks.

You can find out a lot from Oracle itself.

For example to find out about the System Global Area with sqlplus:

Code:

select *  from v$sgastat;