Databases Reference
In-Depth Information
The SQL statement parsed is printed on a new line after the line starting with the string
PARSING
IN
CURSOR
. A line starting with
END
OF
STMT
marks the end of the SQL statement. The
mapping from the numeric command type (parameter
oct
) to the command name is available
by running
SELECT
action,
name
FROM
audit_actions
. Table 24-3 contains the most common
command types plus some additional command types that may be used by applications. Please
note that these numeric command types do not correspond with Oracle Call Interface SQL
command codes (
Oracle Call Interface Programmer's Guide 10g Release 2
,
Appendix A
).
Table 24-3.
SQL and PL/SQL Command Types
Numeric Command Type
SQL or PL/SQL Command
INSERT
2
SELECT
3
UPDATE
6
DELETE
7
LOCK TABLE
26
COMMIT
44
ROLLBACK
45
SAVEPOINT
46
47
PL/SQL block
SET TRANSACTION
48
SET ROLE
55
SET CONSTRAINTS
90
CALL
170
MERGE
189
PARSE Entry Format
Among other metrics,
PARSE
entries represent CPU and wall clock time consumed by parse
operations. By looking at the parameter
mis
(library cache miss) it is possible to derive the
library cache hit ratio from trace files. A low hit ratio usually indicates that the application does
not use bind variables. Details on the parameters of the
PARSE
entry are in Table 24-4.
Table 24-4.
PARSE Parameters
Parameter
Meaning
c
CPU consumption
e
Elapsed time
p
Physical reads