I need to debug a problem one of our older databases is having (Oracle 7.3.4). A user is getting the snapshot too old error message. Is there a way to go through the trace file or create a trace file so that I can analyze what is happening? I'm not familiar with 7.3.4. I realize the quick fix is to increase the redo log file size or add another redo log file, but I suspect that won't solve the problem. I suspect that the user is issuing a fetch/select for update and is leaving the transaction open for an unreasonable amount of time.
Any assistance is greatly appreciated.