Spotlight on Oracle 10.10 - Getting Started Guide

Raw Trace File Page

The Raw Trace File page provides potential debug information when analyzing SQL code.

To open the Raw Trace File Page

1. Select the Spotlight on Oracle connection in the Spotlight Browser.

2. Click SQL & Application Workload | Analyze Trace | Trace Files.

   

3. Select a Trace File.
4. If the trace file has not been analyzed yet, right-click its row in the Trace File Details table and select Analyze Trace File. Analyze Trace Settings Dialog
5. Click Raw Trace File

ORA-16000 on click Raw Trace File? 

Actions on the Trace File

Action	Description
	Go to the top of the file
	Page up
	Page down
	Go to the end of the file
	Find a specified string of text. Open the Find dialog The options in the Find dialog are: Option Description Text to find Enter or paste in the text you want to find. Match case When selected, match the case of the text exactly. For example a search for text AbC will NOT find the text abc. Up Search only upwards through the file from the current location. Down Search only downwards through the file from the current location. From Cursor Search for the specified text from the current location of the cursor. Entire File Search the entire file for the specified text. Find Next Find the next occurrence of the text. Search Period Enter how far you want to search within the file for the text you want to find. (The direction of the search is specified by your other choices.)
	Save the file. Save File As Dialog Note: Use this command to save the file on the Spotlight client. This command cannot be used to save (update) the file on the database server.
	Close the file. Disabled for the Configuration & Memory | Alert Log Page. Disabled for the Configuration & Memory | OEM Status Page. Disabled for the Configuration & Memory | OEM Logs Viewer. Disabled for the Analyze Trace | Raw Trace File Page. Disabled for the Configuration & Memory | Alert Log Page. Enabled only for trace files opened from the Alert Log.

The Raw Trace File display

ORA-16000 on click Raw Trace File?

If you see ORA-16000 on clicking the Alert Log tab on a standby database then create the directory object on the primary and replicate it to the standby.

1. Find background_dump_dest on the standby database
2. Create two directories on the primary database (with and without the trailing slash) for example:
   • Create directory QUEST_SOO_BDUMP_DIR_STDBY_1 as '/u01/app/oracle/diag/rdbms/spotl105/spotl105/trace/';
   • Create directory QUEST_SOO_BDUMP_DIR_STDBY_2 as '/u01/app/oracle/diag/rdbms/spotl105/spotl105/trace';
3. Ensure the directory has been replicated to the standby (this may take some time depending on your data guard setup)
4. Click the Raw Trace File tab on the standby database

Related Topics

Spotlight on Oracle Drilldowns