Chatta subito con l'assistenza
Chat con il supporto

Spotlight on Oracle 10.9 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

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.

The Raw Trace File display

Display Description

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.

  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

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione