Oracle Trouble Shooting Question and Answers

33. How can you enable a trace for a session?
  You can use either the DBMS_SESSION.SET_SQL_TRACE or ALTER SESSION SET SQL_TRACE = TRUE; statement to enable a trace for a session.
 
Your Name Your Email-ID
Your Answer
34. Name a few places you will look to get more details on a performance issue?
  Oracle records the information about different kind of errors and the processes in the files, such as ALERT log, user process trace files and background process trace files.
 
Your Name Your Email-ID
Your Answer
35. Which trace file is used for performance tuning and why?
 
  • User process trace file is used for performance tuning because it contains information about execution plan and resource consumption. This information can be used for performance tuning.
  • These files are located in the directory specified in the BACKGROUND_DUMP_DIRECTORY parameter.
 
Your Name Your Email-ID
Your Answer
36. How do you handle ORA-01403: no data found error?
  You can handle ORA- 01403: no data found error by terminating the processing for the select statement.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 9 of 10