Database Reference
In-Depth Information
Table 24-4. PARSE Parameters
Parameter
Meaning
cr
Consistent reads
cu
Current blocks processed
mis
Cursor misses, 0=soft parse, i.e., statement found in library cache, 1=hard parse,
i.e., statement not found
r
Rows processed
dep
Recursive call depth
og
Optimizer goal, 1=ALL_ROWS , 2=FIRST_ROWS , 3=RULE , 4=CHOOSE ; Oracle9i default is
CHOOSE ; Oracle10 g and Oracle11 g default is ALL_ROWS
plh
Execution plan hash value; corresponds to V$SQL_PLAN.PLAN_HASH_VALUE ,
V$SQL_PLAN_STATISTICS_ALL.PLAN_HASH_VALUE , and
V$SQLSTATS.PLAN_HASH_VALUE among others—this parameter was introduced in
release 11.1.0.7 ( see the section “Execution Plan Hash Value” in this chapter for
details)
tim
Timestamp in microseconds
The following SELECT statement confirms the links between trace file entries and data
dictionary views:
SQL> SELECT s.sql_text, u1.username user_name,
u2.username schema_name, optimizer_mode
FROM v$sql s, all_users u1, all_users u2
WHERE hash_value='1369934057'
AND address=upper('66efcb10')
AND u1.user_id=s.parsing_user_id
AND u2.user_id=s.parsing_schema_id;
SQL_TEXT USER_NAME SCHEMA_NAME OPTIMIZER_MODE
-------------------------------- --------- ----------- --------------
INSERT INTO poem (author, text) NDEBES NDEBES ALL_ROWS
VALUES(:author, empty_clob())
RETURNING text INTO :lob_loc
PARSE # n may be missing, such that PARSING IN CURSOR # n is followed directly by EXEC # n ,
such as in this trace file excerpt from a call to the $dbh->do function of the Perl DBI (more on
Perl DBI in Chapter 22):
PARSING IN CURSOR #4 len=69 dep=0 uid=30 oct=42 lid=30 tim=81591952901 hv=3164292706
ad='67339f7c'
alter session set events '10046 trace name context forever, level 12'
END OF STMT
EXEC #4:c=0,e=68910,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,tim=81591952889
Search WWH ::




Custom Search