One of the best books I have read on any Oracle technology. Must read if you need to know practical performance tuning. Link below Oracle Performance Survival Guide
Out of Memory Problems on Oracle 10 / Solaris 10 Many kernel parameters have been replaced by so called resource controls in Solaris 10. It is possible to change resource controls using the prctl command. All shared memory and semaphore settings are now handled via resource controls, so any entries regarding shared memory or semaphores … Continue reading Avoid out of memory error on Solaris 10 for Oracle Database
ORA-27300: OS system dependent operation:fork failed with status: 12 ORA-27301: OS failure message: Not enough space ORA-27302: failure occurred at: skgpspawn3 Sun Mar 27 08:45:52 2011 This problem is most likely due to swap space being less. Ask your system administrator to increase the swap space. The rule of thumb is swap space should be … Continue reading ORA-27300 ORA-27301 ORA-27302
How to change the Size of the Redo Log files to improve the log switch frequency in Oracle database. select * from v$logfile; select * from v$log; alter database add logfile group 4 ('/u1/oradata/TEST/redo4a.log','/u1/oradata/TEST/redo4b.log') size 100M reuse; alter database add logfile group 5 ('/u2/oradata/TEST/redo5a.log','/u2/oradata/TEST/redo5b.log') size 100M reuse; alter database add logfile group 6 ('/u3/oradata/TEST/redo6a.log','/u3/oradata/TEST/redo6b.log') size … Continue reading Change size of Redo Log files and drop the old files.