Raw Trace File Page
The Raw Trace File page provides potential debug information when analyzing SQL code.
To open the Raw Trace File Page
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click SQL & Application Workload | Analyze Trace | Trace Files.
- Select a Trace File.
- 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
- Click Raw Trace File
ORA-16000 on click Raw Trace File?
Actions on the Trace File
|
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:
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.
|
The Raw Trace File display
File Contents |
The text of the Oracle message or error.
Additional information is displayed in colored or hyperlink text. |
File Contents - Blue Hyperlink Text |
The start of a parse of SQL code.
Click on the blue hyperlinked text to open the Navigation dialog to navigate the current parse of SQL code.
- Start - Click to move the cursor to the initial command of the parse.
- End - Click to move the cursor to the closing command of the parse.
- Select from Exec, Binds, Fetch, Start, Parse and Error and click Previous or Next to move the cursor to the nearest selected command in the parse.
|
File Contents - Red Text |
Oracle error. |
File Contents - Green Text |
Stages of processing the SQL code. |
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.
- Find background_dump_dest on the standby database
- 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';
- Ensure the directory has been replicated to the standby (this may take some time depending on your data guard setup)
- Click the Raw Trace File tab on the standby database
Related Topics
Spotlight on Oracle Drilldowns