APPNAME Application name setting. (This only applies to Oracle 7.2 and above. This can be set by using the

DBMS_APPLICATION_INFO package. See Note 30366.1.)

mod Module name.
mh Module hash value.
act Action.
ah Action hash value.

<CURSOR> Cursor number.

len Length of SQL statement.
dep Recursive depth of the cursor.
uid Schema user id of parsing user.
oct Oracle command type.
lid Privilege user id.
tim Timestamp.

Pre-Oracle9i, the times recorded by Oracle only have a
resolution of 1/100th of a second (10mS). As of Oracle9i
some times are available to microsecond accuracy
(1/1,000,000th of a second).
The timestamp can be used to determine times between points
the trace file. The value is the value in V$TIMER when the
line was written. If there are TIMESTAMPS in the file you
can use the difference between 'tim' values to determine an
absolute time.

hv Hash id.
ad SQLTEXT address (see <View:V$SQLAREA> and <View:V$SQLTEXT>).

<statement> The actual SQL statement being parsed.

PARSE ERROR In Oracle 7.2+ parse errors are reported to the trace file.
len Length of SQL statement.
dep Recursive depth of the statement
uid User id.
oct Oracle command type (if known).
lid Privilege user id.
tim Timestamp.
err Oracle error code (e.g. ORA-XXXXX) reported

<statement> The SQL statement that errored.

If this contains a password, the statement is truncated as

indicated by '...' at the end.

PARSE Parse a statement.
EXEC Execute a pre-parsed statement.
FETCH Fetch rows from a cursor.
UNMAP If the cursor uses a temporary table, when the cursor is

closed you see an UNMAP when we free up the temporary table

locks.(Ie: free the lock, delete the state object, free the

temp segment)

In tkprof, UNMAP stats get added to the EXECUTE statistics.

SORT UNMAP

As above, but for OS file sorts or TEMP table segments.

c CPU time (100th's of a second in Oracle7 ,8 and 9).
e Elapsed time (100th's of a second Oracle7, 8 and 1,000,000ths (Microseconds) in Oracle 9 onwards).
p Number of physical reads.
cr Number of buffers retrieved for CR reads.
cu Number of buffers retrieved in current mode.
mis Cursor missed in the cache.
r Number of rows processed.
dep Recursive call depth (0 = user SQL, >0 = recursive).
og Optimizer goal: 1=All_Rows, 2=First_Rows, 3=Rule, 4=Choose
tim Timestamp (large number in 100ths of a second). Use this to determine the time between any 2 operations.

BIND	Variables bound to a cursor.
bindN	The bind position being bound.
dty	Data type (see <Glossary:DataTypes>).
mxl	Maximum length of the bind variable (private max len in paren).
mal	Array length.
scl	Scale.
pre	Precision.
oacflg	Special flag indicating bind options
oacflg2	Continuation of oacflg
size	Amount of memory to be allocated for this chunk
offset	Offset into this chunk for this bind buffer
bfp	Bind address.
bln	Bind buffer length.
avl	Actual value length (array length too).
flg	Special flag indicating bind status
value	The actual value of the bind variable.
	Numbers show the numeric value, strings show the string etc...

WAIT	An event that we waited for.
nam	What was being waited for .
	The wait events here are the same as are seen in
	<View:V$SESSION_WAIT>. For any Oracle release a full list of
	wait events and the values in P1, P2 and P3 below can be
	seen in <View:V$EVENT_NAME>
ela	Elapsed time for the operation
p1	p1 for the given wait event
p2	p2 for the given wait event
p3	p3 for the given wait event

WAIT #1: nam="db file scattered read" ela= 5 p1=4 p2=1435 p3=25

WAITing under CURSOR no 1

for "db file scattered read"

We waited 0.05 seconds
For a read of: File 4, start block 1435, for 25 Oracle
blocks

WAIT #1: nam="db file sequential read" ela= 4 p1=4 p2=1224 p3=1

WAITing under CURSOR no 1
for "db file sequential read"
We waited 0.04 seconds for a single block read (p3=1)
from file 4, block 1224