Database Tuning (MOSC)

MOSC Banner

tkprof not generating output

edited Jan 14, 2021 5:02PM in Database Tuning (MOSC) 1 commentAnswered

$ tkprof SID_ora_1475.trc' 'SID_ora_1475.txt' sort= fchela,exeela,prsela sys=no

$ cat SID_ora_1475.txt

TKPROF: Release 10.1.0.5.0 - Production on Thu Jan 14 11:45:05 2021


Copyright (c) 1982, 2005, Oracle. All rights reserved.


Trace file: SID_ora_1475.trc

Sort options: fchela exeela prsela

********************************************************************************

count   = number of times OCI procedure was executed

cpu     = cpu time in seconds executing

elapsed = elapsed time in seconds executing

disk    = number of physical reads of buffers from disk

query   = number of buffers gotten for consistent read

current = number of buffers gotten in current mode (usually for update)

rows    = number of rows processed by the fetch or execute call

********************************************************************************

Trace file: SID_ora_1475.trc

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