Database Reference
In-Depth Information
At first, general information about the execution environment and the text of the SQL statement is given. Note
that information about the session attributes is displayed only when available. For example, in this case, the attribute
action name isn't displayed because the application didn't set it. Also note that SQL ID is available for trace files
generated as of version 11.1 only:
Session ID 156.29
Service Name SYS$USERS
Module Name SQL*Plus
Parsing User 34
Hash Value 166910891
SQL ID 15p0p084z5qxb
DECLARE
l_count INTEGER;
BEGIN
FOR c IN (SELECT extract(YEAR FROM d), id, pad
FROM t
ORDER BY extract(YEAR FROM d), id)
LOOP
NULL;
END LOOP;
FOR i IN 1..10
LOOP
SELECT count(n) INTO l_count
FROM t
WHERE id < i*123;
END LOOP;
END;
The execution statistics provide data in tabular form, aggregated by type of database call. Because the table
layout is based on the one generated by TKPROF, the meaning of the columns is the same. There are, however, two
additional columns:
Misses
and
LIO
. The former is the number of hard parses that occurred during each type of call.
The latter is just the sum of the
Consistent
and
Current
columns. Also notice that TVD$XTAT provides two tables.
The first also includes the statistics about all recursive SQL statements related to the current one. The second, like
TKPROF, doesn't include them:
Database Call Statistics
with Recursive Statements
**************************************************
Call Count Misses CPU Elapsed PIO LIO Consistent Current Rows
------- ----- ------ ----- ------- ------ ------ ---------- ------- ----
Parse 1 1 0.005 0.006 7 20 20 0 0
Execute 1 0 6.957 12.387 71,562 38,820 38,812 8 1
Fetch 0 0 0.000 0.000 0 0 0 0 0
------- ----- ------ ----- ------- ------ ------ ---------- ------- ----
Total 2 1 6.962 12.393 71,569 38,840 38,832 8 1
