ORA-07445 When Executing A Trial With SQL Perf Analyzer

(Doc ID 1512840.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Using the SQL Performance Analyzer to analyze a SQL tuning set fails with ORA-3113:

begin dbms_sqlpa.execute_analysis_task(task_name => <task name>, 
execution_type =>'TEST EXECUTE',
execution_name => <execution_name>,  
execution_desc => <description>,
execution_params =>
 dbms_advisor.arglist('LOCAL_TIME_LIMIT', 'UNLIMITED','TIME_LIMIT', 'UNLIMITED','DATABASE_LINK', <db_link>));
end; 

   
  ERROR at line 1: 
  ORA-03113: end-of-file on communication channel 
   
   
  Alert log shows :- 
  Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x500000000]   [PC:0xC0000000003B1C40, _memcpy()+96] [flags: 0x0, count: 1]


The stack trace contains all or some of the following functions:


 

memcpy  <- evacom <- qerwnRowP <- qervwRowProcedure <- qeruaRowProcedure <-
 qerfiFetch  <- rwsfcd <- qeruaFetch <- qervwFetch <- qerwnFetch <- opifch2
 <- kpoal8 <- opiodr <- kpoodrc <- rpiswu2 <- kpoodr <- upirtrc <- kpurcsc <-
 kpufch0 <- kpufch <- OCIStmtFetch2 <- qksanExecSql <- qksanAnalyzeSql <- 744
 <- qksanAnalyzeSegSql <- kestsExecuteSql <- 936 <- kestsRemoteExecSqlE <-
 spefcmpa <- spefmccallstd <- pextproc  <- peftrusted <- psdexsp <-
 rpiswu2 <- psdextp <- pefccal  <- pefcal <- pevm_FCAL <- pfrinstr_FCAL <-
 pfrrun_no_tool <- pfrrun  <- plsql_run <- peicnt <- kkxexe <- opiexe


 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms