My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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

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.