How to increase the buffer size for Oracle?
lzhwxySep 2 2004 — edited Sep 2 2004After I installed the patch 9.2.0.4, I kept getting 'ORA-03113: end-of-file on communication channel' error. According to the metalink, increasing the buffer size may solve this problem. I found when I set the trace on, this problem was gone, and after I set the trace off, it came back again. I am not sure if setting the trace on increases buffer size automatically or not, but I want to start from here.
No matter how easy it is, I really didn't change buffer size before, can anyone show me how to do that?
Thanks a lot.