on 07-07-2010 7:16 AM
we have a ecc6 abap system which used 13.5GB memory.
in AIX:
svmon -U oraprd 2642791*4KB=10GB
===============================================================================
User Inuse Pin Pgsp Virtual
oraprd 2642791 69044 364678 2942062
svmon -U prdadm 491989 * 4KB=2GB
===============================================================================
User Inuse Pin Pgsp Virtual
prdadm 491989 66813 45580 516309
what puzzled me is the oraprd user used 10GB memory while the sga_targe and sga_max_size are both 5GB.
why the oraprd user used 10GB memory? Could you give me some advices. thanks very very much.
oracle 10.2.0.4 parameter:
NAME TYPE VALUE
-
-
-
sga_max_size big integer 5G
sga_target big integer 5G
pga_aggregate_target big integer 400M
db_cache_advice string OFF
db_cache_size big integer 16M
shared_pool_reserved_size big integer 57982058
shared_pool_size big integer 1G
large_pool_size big integer 16M
java_pool_size big integer 160M
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.