Recently I was involved in performance troubleshooting of one quite expensive system
that had performance problems during business hours.
I’ll not provide all details, but just post some pictures that will show resource usage:
Oracle memory allocation:
Linux memory allocation
or from other side:
cat /proc/meminfo MemTotal: 98848220 kB MemFree: 75109972 kB Buffers: 597460 kB
so, we have Buffer Cache sized as 368MB/(96GB*1024)=0,37% of the Total Memory!!!
To be crystal clear I have to say that this system use ASM as a storage…
So, why do you think ASM performance is so BAD ?…
Just to note – it’s 18.104.22.168 based system.
PS: sometimes I think that problems like this are based on special DNA structure…
ok, some additional comments on this system – it’s 1/4 Exadata in which ASSM feature is used and pressure from shared pool on the buffer cache was so strong, that at the end buffer cache became 256MB. It was on first node only! On the second node buffer cache was about 3.6BG and it worked like a lightning! 😉
So, SGA target was increased to 50GB and buffer pool was set from the bottom at 40GB limit.