|
Code Listing 3: SQL Trace and TKPROF results of XML DB storage tests
For the CLOB-storage load, my overall totals were as follows.
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS:
call count cpu elapsed disk query current rows
------ ------ ----- -------- ------- ------- ----------- ---------------
Parse 16 0.02 0.02 0 6 1 0
Execute 16 0.80 1.08 2 10 7000 5
Fetch 6 0.00 0.00 0 16 0 3
------ ------ ----- -------- ------- ------- ----------- --------------
total 38 0.82 1.11 2 32 7001 8
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS:
call count cpu elapsed disk query current rows
------ ------ ----- -------- ------- ------- ----------- --------------
Parse 222 0.02 0.02 0 0 0 0
Execute 1606 2.74 5.16 0 4160 15433 1471
Fetch 1028 0.04 0.06 0 1256 0 954
------ ------ ----- -------- ------- ------- ----------- --------------
total 2856 2.82 5.25 0 5416 15433 2425
For the structured-storage load, my overall totals were as follows.
OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS:
call count cpu elapsed disk query current rows
------ ------ ----- -------- ------- ------- ----------- --------------
Parse 20 0.03 0.04 0 86 1 0
Execute 20 2.14 3.35 4 1825 9254 9
Fetch 6 0.00 0.00 0 16 0 3
------ ------ ----- -------- ------- ------- ----------- --------------
total 46 2.18 3.39 4 1927 9255 12
OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS:
call count cpu elapsed disk query current rows
------ ------ ----- -------- ------- ------- ----------- --------------
Parse 3160 0.36 0.34 0 264 1 0
Execute 6773 10.52 10.28 0 27108 25102 3695
Fetch 4164 1.06 1.10 0 17565 0 3568
------ ------ ----- -------- ------- ------- ----------- --------------
total 14097 11.95 11.73 0 44937 25103 7263
|