When analyzing a big trace file (50 MB, about 1.3 million lines) in Spotlight receiving the following error:
An error occurred while refreshing the table LoadTracePgaLimit in connection
Message:
An error occurred while refreshing the table LoadTracePgaLimit in connection DB-ALIAS.
* Click OK to continue,
* Click Ignore to ignore any further errors related to this table, or
* Click Disconnect to close this connection.
--------------------------------------------------------------------------------
Details:
ORA-02291: integrity constraint (QUEST.SYS_C00968007) violated - parent key not found
ORA-06512: at QUEST.QUEST_SOO_SQLTRACE, line 2549
ORA-06512: at line 2
in table LoadTracePgaLimit
--------------------------------------------------------------------------------
WORKAROUND 1:
If running out of OS memory - increasing the Oracle ulimit might be required.
WORKAROUND 2:
Please use a text editor to split the file into smaller files.
WORKAROUND 3:
Use trcsess to extract the specific client, module or service of interest.
WORKAROUND 4:
Manually load a trace file limiting the number of lines processed: using the Spotlight function to process the first number linesof the file
BEGIN
quest_soo_sqltrace.load_trace(
file_name=><trace_file_name.trc>,
load_all_lines=>FALSE,
process_waits=>0,
process_binds=>0,
load_recursive=>0,
line_limit=>800000,
pga_limit=>21485760);
END;
Login with the Spotlight user account to run this sql statement.
