Database Utilities (MOSC)

MOSC Banner

Not enough information for file created with tkprof

edited Dec 22, 2015 10:04AM in Database Utilities (MOSC) 5 commentsAnswered

Hi,

I used tkprof to read a trace file by submitting the command "tkprof cdprdb_mmon_25165970.trc test.txt", but the produced file only show the following lines...

"

...

Trace file: cdprdb_mmon_25165970.trc

Trace file compatibility: 11.1.0.7

Sort options: default

       1  session in tracefile.

       0  user  SQL statements in trace file.

       0  internal SQL statements in trace file.

       0  SQL statements in trace file.

       0  unique SQL statements in trace file.

   26559  lines in trace file.

       0  elapsed seconds in trace file.

...

"

Altought the trace file is not empty, why I there is no additional information in the txt file created???

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center