Best Performance Tuning Book for Oracle Database

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 

Avoid out of memory error on Solaris 10 for Oracle Database

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 ORA-27301 ORA-27302

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

Change size of Redo Log files and drop the old files.

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.