Trcasst Doesn't Display the SQL Statements Sent to the Server (Doc ID 859313.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Net Services - Version: 10.2.0.3 to 11.1.0.7
This problem can occur on any platform.

Symptoms

When running trcasst -ouq, no SQL statements are displayed, even though the client trace did capture them correctly.

The output of trcasst is empty :

Trace Assistant Utility: Version 10.2.0.3.0 Production on July 13, 2009 12:39:35 PM
Copyright (c) 2001, 2006, Oracle. All rights reserved.

*************************************************************************
* Trace Assistant *
************************************************************************* 
                                                                       Bytes Bytes 
                                                                        Sent  Rcvd

Send operation(TTIPRO)                                       38   182

*************************************************************************
* Trace Assistant has completed *
*************************************************************************

 At the same time the following waning is displayed in the console :

TNS-04318: Trace Assistant warning: Would not decode TTC

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