ORA-600 [ttcgcshnd-1] Using Autotrace Option Over Database Link (Doc ID 428026.1)

Last updated on JUNE 13, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 14-May-2013***

Symptoms

You are trying to get an execution plan for a query that uses a DATABASE LINK between an Oracle 10g and Oracle 8i or 9i database.
The following error is occuring when SQL*plus feature autotrace on :

SQL> set autotrace [traceonly explian]

SQL> select dummy from dual@mylink;

Execution Plan
----------------------------------------------------------
ERROR: ORA-03113: end-of-file on communication channel
SP2-0612: Error generating AUTOTRACE EXPLAIN report


In the alert log file there is an entry to a internal error :

ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] Current SQL statement for this session: INSERT INTO "PLAN_TABLE"("STATEMENT_ID","TIMESTAMP","OPERATION","OPTIONS", "OBJECT_NODE","OBJECT_OWNER","OBJECT_NAME","OBJECT_INSTANCE","OBJECT_TYPE", "SEARCH_COLUMNS","ID","PARENT_ID","POSITION","OTHER","OPTIMIZER","COST", "CARDINALITY","BYTES","OTHER_TAG","PARTITION_START","PARTITION_STOP", "PARTITION_ID","DISTRIBUTION") VALUES (:1,SYSDATE@!,:2,:3,:4,:5,:6,:7,:8,:9, :10,:11,:12,:13,:14,:15,:16,:17,:18,:19,:20,:21,:22)


You may also get a error message saying it cannot fetch plan for statement_id. See the example below :

SQL> set autotrace traceonly explain

SQL> select dummy from dual@mylink;

Execution Plan
----------------------------------------------------------
Error: cannot fetch plan for statement_id 'PLUS47'

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