Trace Files   «Prev  Next»

Setting Special Trace Events - Exercise

Trace File Matching

Objective: Match the statements related to trace files to their functions.
This exercise uses a Java applet to allow you to match items in the left column with the items in the right column. If you do not have Java active in your browser or are behind a firewall that does not allow Java applets, you will not be able to complete this exercise. If you do not see the applet below, click OK, I'm Done to continue with the course. You will receive full credit for this exercise.

Instructions

In the left column below are several commands. The actions that they accomplish are in the right column. Click a command in the left column once, then click the action in the right column once to make a match.
When you think you have all of the items matched correctly, click the Done button and you will see whether or not you've matched the items correctly--green lines mean the match is correct, red lines mean the match is incorrect. If you didn't get the matches right the first time, click Clear to erase your matches and try again.
When you have completed the exercise, click the Submit button to see the correct answers.

Exercise Scoring

You will receive 2 points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the Submit button to receive full credit.

  1. grep -I background * .ora
  2. show parameters dump
  3. tkprof ora_334907.trc x.lst
  4. DBMS_SUPPORTSTART_TRACE|||_IN_SESSION (18, 29694)
  5. ps -ef|grep ora|grep LOCAL
  1. Summarizes information from a |||SQL-related trace file
  2. Begins tracing a session
  3. Displays the background_dump_dest
  4. Lists all of the UNIX tasks andthen |||displays tasks that contain |||the specified string
  5. Looks for background_dump_dest in * .ora