Search This Blog

Thursday, July 31, 2008

Calculate Background Process and User Process Memory Consumption for Oracle 10g R2 (10.2.0.3)

Here is a very simple formula and observation on what is the memory consumption of Oracle Process and User Connections on Linux (SLES10) for Oracle 10.2.0.3

SGA_TARGET is set to sga_target=3100 M (Approx
3 Gb
)

USER DSIZ VSZ COMMAND COMMAND
oracle 3219786 3319072 oracle ora_pmon_DB1
oracle 3266114 3365400 oracle ora_dbw0_DB1
oracle 3233590 3332876 oracle ora_lgwr_DB1
oracle 3223238 3322524 oracle ora_ckpt_DB1
oracle 3223326 3322612 oracle ora_smon_DB1
oracle 3220182 3319468 oracle ora_reco_DB1
oracle 3234162 3333448 oracle ora_arc0_DB1

oracle 3219806 3319092 oracle oracleDB1 (LOCAL=NO)
oracle 3218706 3317992 oracle oracleDB1 (LOCAL=NO)
oracle 3218706 3317992 oracle oracleDB1 (LOCAL=NO)
oracle 3218702 3317988 oracle oracleDB1 (LOCAL=NO)
oracle 3219226 3318512 oracle oracleDB1 (LOCAL=NO)
oracle 3219786 3319072 oracle oracleDB1 (LOCAL=NO)
oracle 3218702 3317988 oracle oracleDB1 (LOCAL=NO)
oracle 3219738 3319024 oracle oracleDB1 (LOCAL=NO)

So, based on the above, it is approx.
1 % of the SGA
.

Let me know if you disagree or if you have similar observations / calculations.
Note : There are system parameter that will have an impact too.

No comments: