Search Results

I have raised this with Oracle now .. Will update you when I get some information.

Hi radulov,

Sorry for the late reply. Thanks for your help. Was very much useful and I learnt quite a lot of Solaris commands.

The issue was not fixed but when the instance was restarted the...

No its just one physical server, we are not using any LDOMS or other virtualization techniques

edit by scottn: moved ps output (1558 lines) to .txt attachment

vmstat -S 2 10
kthr memory page disk faults cpu
r b w swap free si so pi po fr de sr m0 m1 m3 m4 in sy cs us sy id
0 0 0 5657056 4946968 0 0...

ipcs -a
IPC status from <running system> as of Thursday September 30 12:48:07 GMT 2010
T ID KEY MODE OWNER GROUP CREATOR CGROUP CBYTES QNUM QBYTES LSPID LRPID ...

root@sunfire130 # echo "::memstat" | mdb -k
Page Summary Pages MB %Tot
------------ ---------------- ---------------- ----
Kernel 572519 ...

echo "::memstat" | mdb -k
mdb: failed to open /dev/mem: Permission deniedI dont have permissions as I am not a sysadmin

kstat -m zfs
module: zfs instance: 0
name: ...

Thanks once again.

I am not sure why it should be so busy when SGA and PGA consumption are less than 11G at the moment. I do understand that PGA consumption would raise substantially during a...

Thank you very much.

This pga_aggregate_target parameter which is set is just a target value isn't it, so even if it is small and if Oracle needs more memory it would go for it, is that not the...

ORA-04030: out of process memory when trying to allocate 82456 bytes (pga heap,control file i/o buffer)

SQL> !vmstat -S
kthr memory page disk faults cpu...

We were receiving out of process memory errors - unable to allocate .. bytes of memory for PGA

vmstat - sr was increasing constantly and used oracle EM to monitor memory usage

Yes I cant...

sar -r

SunOS sunfire130 5.10 Generic_141414-07 sun4v 09/29/2010

00:00:00 freemem freeswap
00:10:00 379711 6365702
00:20:01 381464 6392244
00:30:00 370198 6201557
00:40:00 381115 ...

I am working on Oracle 2 node RAC 10.2.0.4 on Solaris 10 T2000 kit.

The box has around 32G of memory of which 24G is used by oracle user. There is 3G of free memory on the box.
Sga max is set to...