Overcome Alert Log Error

Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.

Questions by Pragati.rch

Showing Answers 1 - 3 of 3 Answers

rajendra_thanekar

  • Mar 24th, 2008
 

Hi,Oracle write error in alert log file. Depending upon the error corrective action needs to be taken.1) DeadLock Error : Take the trace file in user dump destination and analysis it for the error.2) ORA-01555 Snapshot error. Check the query try to fine tune and check the undo size.3) Unable to extent segment : Check the tablespace size and if require add space in the tablespace by 'alter database datafile .... resize' or alter tablespace add datafile command.Regards

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions