My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.