Sunday Aug 15, 2004
Wednesday Jul 21, 2004
By gjl on Jul 21, 2004
so it's not the most thrilling subject, but I found this document on BigAdmin a while ago, and just got around to reading it. The document contains a lot of good tips on setting up Oracle on NAS (Particularly NetApps). The impressive thing I found was that the engineers use real measured data to qualify much of what they recommend. The authors are from Sun's performance group, and from NetApp themselves. Check it out for general Solaris/Oracle/NFS configuration guidelines also.
Monday Jul 19, 2004
By gjl on Jul 19, 2004
I just closed a long running escalation whereby old oracle connections would appear to hang, and new ones could not be established. A truss of a new sqlplus session showed that the oracle process was sleeping on a semop system call.
sqlplus/1: read(10, 0x10024FF66, 2064) (sleeping...)\^M oracle/1: semop(1245185, 0xFFFFFFFF7FFFAF9C, 1) (sleeping...)\^M sqlplus/1: 556.9328 Received signal #2, SIGINT, in read() \^\^\^Here we see the process is eventually killed with CTRL-CAnyhow the fix was to apply Oracle update 18.104.22.168 (9205) which according to my Oracle contacts contains around 1,100 fixes. 22.214.171.124 contained in the region of 800 compared to 126.96.36.199 Cor blimey, what a whopper .