oracle db_cache_size and /etc/svc/volatile acting weird
Hi Guys, i'm running into a weird situation. i'm hoping someone with some oracle/solaris experience can help me out.
so i have 2 systems configured identically with solaris 10 running oracle 9i with 128gb ram.
Given we have so much mem we are trying to utilize the memory more.
so what we have done is configured couple parameters in init'sid'.ora file.
db_cache_size=6144M and sga_max_size=80G
before we start the DB i look at swap and it's 133GB under /etc/svc/volatile even though we have only 32g under swap -l.
when start the DB with above parameters /etc/svc/volatile goes to 53gb everytime i increase the db_cache size it takes away from volatile so even though we have 128gb of ram i can only increase the sga upto 50gb.
however i have another server where volatile stays at 32gb regardless if i'm adding or removing db_cache and i'm able to go upto 80gb.
anyhow, i hope i'm making sense to you guys here. looking forward to hear ideas or questions.
thanks
Ogie.
