TKPROF: Release 8.1.6.0.0 - Production on Tue Oct 22 16:12:59 2002 (c) Copyright 1999 Oracle Corporation. All rights reserved. Trace file: /export/home/oracle/admin/web/udump/web_ora_9732.trc Sort options: exedsk ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** select SYSDATE from DUAL /* ping */ call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 615434 188.20 190.68 0 0 0 0 Execute 0 0.00 0.00 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 615434 188.20 190.68 0 0 0 0 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'DUAL' ******************************************************************************** SELECT pu_id,UPPER(pu_head),pu_subhead,pu_author,pu_image,pu_annotation, TO_CHAR(pu_date,:SYS_B_0),pu_rubric,pu_use_stat FROM an_publ WHERE pu_priority=:SYS_B_1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 6618 0.71 0.67 0 0 0 0 Fetch 6618 1826.59 1832.96 0 124027938 138978 6618 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 13236 1827.30 1833.63 0 124027938 138978 6618 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AN_PUBL' ******************************************************************************** SELECT im_author,im_text,im_width,im_height,im_mime FROM an_images WHERE im_id=:p1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 133065 10.47 9.68 0 0 0 0 Fetch 133065 9.79 9.23 0 399195 0 133065 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 266130 20.26 18.91 0 399195 0 133065 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_IMAGES' 0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'SYS_C0034680' (UNIQUE) ******************************************************************************** SELECT ru_id FROM an_rubrics WHERE ru_pid=:SYS_B_0 AND ru_show=:SYS_B_1 ORDER BY ru_ord call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 6618 0.68 0.66 0 0 0 0 Fetch 13236 2.90 2.89 0 6618 26472 86034 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 19854 3.58 3.55 0 6618 26472 86034 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AN_RUBRICS' ******************************************************************************** SELECT pu_id,UPPER(pu_head),pu_subhead,pu_author,pu_image,pu_annotation, TO_CHAR(pu_date,:SYS_B_0),pu_rubric,pu_use_stat,ru_name FROM an_publ,an_rubrics WHERE ru_pid=:SYS_B_1 AND ru_id=pu_rubric AND ru_id=:p1 AND pu_priority=:SYS_B_2 AND pu_show=:SYS_B_3 ORDER BY pu_priority DESC, pu_ord call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 86034 17.58 17.04 0 0 0 0 Fetch 86034 591.52 592.72 0 1111824 0 66180 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 172068 609.10 609.76 0 1111824 0 66180 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 NESTED LOOPS 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_RUBRICS' 0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'SYS_C0034080' (UNIQUE) 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_PUBL' 0 BITMAP CONVERSION (TO ROWIDS) 0 BITMAP AND 0 BITMAP CONVERSION (FROM ROWIDS) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_RUBRIC' (NON-UNIQUE) 0 BITMAP CONVERSION (FROM ROWIDS) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_PRIORITY' (NON-UNIQUE) 0 BITMAP MERGE 0 BITMAP INDEX (RANGE SCAN) OF 'AN_PUBL_I3' ******************************************************************************** SELECT pu_id,UPPER(pu_head),pu_subhead,pu_author,pu_image,pu_annotation, TO_CHAR(pu_date,:SYS_B_0),pu_rubric,pu_use_stat,ru_name FROM an_publ,an_rubrics WHERE ru_pid=:p1 AND ru_id=pu_rubric AND ru_show=:SYS_B_1 AND pu_priority=:SYS_B_2 AND pu_show=:SYS_B_3 ORDER BY ru_ord, pu_priority DESC, pu_ord call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 86034 14.62 14.26 0 0 0 0 Fetch 86034 787.48 789.04 0 1164768 344136 39708 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 172068 802.10 803.30 0 1164768 344136 39708 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 NESTED LOOPS 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AN_RUBRICS' 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_PUBL' 0 BITMAP CONVERSION (TO ROWIDS) 0 BITMAP AND 0 BITMAP CONVERSION (FROM ROWIDS) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_RUBRIC' (NON-UNIQUE) 0 BITMAP MERGE 0 BITMAP INDEX (RANGE SCAN) OF 'AN_PUBL_I3' 0 BITMAP CONVERSION (FROM ROWIDS) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_PRIORITY' (NON-UNIQUE) ******************************************************************************** SELECT ru_id, ru_name, ru_pid FROM an_rubrics where ru_pid=:SYS_B_0 AND ru_show=:SYS_B_1 order by ru_menu_ord call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 42078 2.45 2.37 0 0 0 0 Fetch 63117 13.89 13.61 0 42078 168312 483897 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 105195 16.34 15.98 0 42078 168312 483897 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AN_RUBRICS' ******************************************************************************** SELECT ru_id, ru_name, ru_pid FROM an_rubrics where ru_pid=:pid AND ru_show=:SYS_B_0 order by ru_menu_ord call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 273507 17.73 16.93 0 0 0 0 Fetch 273507 93.36 92.41 0 273507 1094028 441819 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 547014 111.09 109.34 0 273507 1094028 441819 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AN_RUBRICS' ******************************************************************************** SELECT day_temp,night_temp,clouds,name FROM tweather,tcities WHERE id=city AND city=:p1 AND ( w_date=TRUNC(SYSDATE) OR w_date=TRUNC(SYSDATE+:SYS_B_0)) ORDER BY w_date call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 42078 3.65 3.48 0 0 0 0 Fetch 42078 8.19 8.05 0 252468 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 84156 11.84 11.53 0 252468 0 0 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 NESTED LOOPS 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'TCITIES' 0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'SYS_C0034043' (UNIQUE) 0 INLIST ITERATOR 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'TWEATHER' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'LE_IND_WEATHER_DATE' (NON-UNIQUE) ******************************************************************************** SELECT pu_id,pu_anons_text,pu_rubric,UPPER(ru_name),pu_use_stat FROM an_publ,an_rubrics WHERE pu_rubric=ru_id AND pu_show=:SYS_B_0 AND pu_isanons=:SYS_B_1 AND pu_isanonsmain=:SYS_B_2 ORDER BY pu_date DESC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 9926 4.01 4.00 0 0 0 0 Fetch 9926 2965.64 2974.09 0 201874988 208446 49630 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 19852 2969.65 2978.09 0 201874988 208446 49630 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 HASH JOIN 0 INDEX GOAL: ANALYZED (FULL SCAN) OF 'AN_RUBRICS_I1' (NON-UNIQUE) 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AN_PUBL' ******************************************************************************** SELECT ru_id FROM an_rubrics WHERE ru_lname = :p1 ORDER BY ru_ord call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 19814 3.09 3.08 0 0 0 0 Fetch 19814 6.01 5.94 0 19814 79256 11194 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 39628 9.10 9.02 0 19814 79256 11194 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AN_RUBRICS' ******************************************************************************** SELECT pu_id,UPPER(pu_head),pu_rubric,ru_name, (select ru_name from an_rubrics where ru_id=t1.ru_pid) as pid_name, ru_pid FROM an_publ, an_rubrics t1 WHERE ru_id=pu_rubric AND pu_date>=TO_DATE( :dt1 ,:SYS_B_0) AND pu_date<(TO_DATE( :dt2 ,:SYS_B_1)+:SYS_B_2) ORDER BY ru_menu_ord, ru_name, pu_date DESC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 3250 1.88 1.91 0 0 0 0 Fetch 12617 12.25 13.43 0 120099 8680 113266 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 15867 14.13 15.34 0 120099 8680 113266 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 HASH JOIN 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_PUBL' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_DATE' (NON-UNIQUE) 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AN_RUBRICS' ******************************************************************************** SELECT ru_pid,ru_name FROM an_rubrics WHERE ru_id=:p1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 14282 1.50 1.47 0 0 0 0 Fetch 14282 1.24 1.17 0 28564 0 14282 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 28564 2.74 2.64 0 28564 0 14282 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_RUBRICS' 0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'SYS_C0034080' (UNIQUE) ******************************************************************************** SELECT pu_id,UPPER(pu_head),pu_subhead,pu_author,pu_image,pu_content,TO_CHAR(pu_date,:SYS_B_0),pu_rubric,pu_linkblock,pu_temy_dnya,pu_use_stat,pu_iscommerce FROM an_publ WHERE pu_id = :p1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 8017 0.62 0.65 0 0 0 0 Fetch 8017 4.09 4.35 0 38905 0 8014 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 16034 4.71 5.00 0 38905 0 8014 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_PUBL' 0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'SYS_C0034681' (UNIQUE) ******************************************************************************** SELECT pu_id,UPPER(pu_head),pu_subhead,pu_author,pu_image,pu_annotation,TO_CHAR(pu_date,:SYS_B_0),pu_rubric,pu_use_stat FROM an_publ WHERE pu_rubric = :ru AND pu_date>=TO_DATE( :dt1 ,:SYS_B_1) AND pu_date<(TO_DATE( :dt2 ,:SYS_B_2)+:SYS_B_3) AND pu_id != :pu ORDER BY pu_priority DESC,pu_ord call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 2573 0.28 0.30 0 0 0 0 Fetch 2777 12.36 12.37 0 36265 0 12721 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 5350 12.64 12.67 0 36265 0 12721 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_PUBL' 0 BITMAP CONVERSION (TO ROWIDS) 0 BITMAP AND 0 BITMAP CONVERSION (FROM ROWIDS) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_RUBRIC' (NON-UNIQUE) 0 BITMAP CONVERSION (FROM ROWIDS) 0 SORT (ORDER BY) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_DATE' (NON-UNIQUE) ******************************************************************************** SELECT ru_pid FROM an_rubrics WHERE ru_id=:p1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 3168 0.48 0.44 0 0 0 0 Fetch 3168 0.23 0.19 0 6336 0 3168 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6336 0.71 0.63 0 6336 0 3168 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_RUBRICS' 0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'SYS_C0034080' (UNIQUE) ******************************************************************************** SELECT COUNT(pu_id) FROM an_publ WHERE pu_show=:SYS_B_0 AND pu_isanons=:SYS_B_1 AND pu_isanonsmain=:SYS_B_2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 11113 1.93 1.88 0 0 0 0 Fetch 11113 3.18 3.15 0 33339 0 11113 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 22226 5.11 5.03 0 33339 0 11113 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (AGGREGATE) 0 BITMAP CONVERSION (COUNT) 0 BITMAP INDEX (SINGLE VALUE) OF 'AN_PUBL_I3' ******************************************************************************** SELECT pu_id,pu_anons_text,pu_rubric,UPPER(ru_name),pu_use_stat FROM an_publ,an_rubrics WHERE ru_id=pu_rubric AND pu_show=:SYS_B_0 AND pu_isanons=:SYS_B_1 AND pu_isanonsmain=:SYS_B_2 ORDER BY pu_date DESC call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 11113 3.47 3.48 0 0 0 0 Fetch 33341 3333.82 3342.71 0 226049533 233373 300068 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 44454 3337.29 3346.19 0 226049533 233373 300068 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 HASH JOIN 0 INDEX GOAL: ANALYZED (FULL SCAN) OF 'AN_RUBRICS_I1' (NON-UNIQUE) 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AN_PUBL' ******************************************************************************** SELECT li_title,li_site,li_url FROM an_links WHERE li_block=:p1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 5735 0.21 0.22 0 0 0 0 Fetch 5786 0.53 0.45 0 19259 0 25414 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 11521 0.74 0.67 0 19259 0 25414 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_LINKS' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_LINKS_BLOCK' (NON-UNIQUE) ******************************************************************************** SELECT pu_id,UPPER(pu_head),pu_subhead,pu_author,pu_image,pu_annotation,TO_CHAR(pu_date,:SYS_B_0),pu_rubric,pu_use_stat FROM an_publ WHERE pu_rubric = :ru AND pu_show=:SYS_B_1 AND pu_id != :pu ORDER BY pu_priority DESC,pu_ord call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 5443 0.69 0.72 0 0 0 0 Fetch 5446 79.04 79.19 0 100663 0 34737 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 10889 79.73 79.91 0 100663 0 34737 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_PUBL' 0 BITMAP CONVERSION (TO ROWIDS) 0 BITMAP AND 0 BITMAP CONVERSION (FROM ROWIDS) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_RUBRIC' (NON-UNIQUE) 0 BITMAP MERGE 0 BITMAP INDEX (RANGE SCAN) OF 'AN_PUBL_I3' ******************************************************************************** SELECT tdl_text,tdl_url FROM an_temy_dnya_links WHERE tdl_tdn_id=:p1 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 372 0.00 0.00 0 0 0 0 Fetch 372 7.53 7.55 0 47244 1860 2198 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 744 7.53 7.55 0 47244 1860 2198 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AN_TEMY_DNYA_LINKS' ******************************************************************************** SELECT TO_CHAR(pu_date, :SYS_B_0) FROM an_publ WHERE pu_date IN (SELECT MIN(pu_date) FROM an_publ) call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 106 0.02 0.15 0 318 0 0 Fetch 106 0.01 0.01 0 212 0 106 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 212 0.03 0.16 0 530 0 106 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_DATE' (NON-UNIQUE) 0 SORT (AGGREGATE) 0 INDEX GOAL: ANALYZED (FULL SCAN (MIN/MAX)) OF 'AN_PUBL_I4' (NON-UNIQUE) ******************************************************************************** SELECT pu_id,UPPER(pu_head),pu_subhead,pu_author,pu_image,pu_annotation,TO_CHAR(pu_date,:SYS_B_0),pu_rubric,pu_use_stat FROM an_publ WHERE pu_rubric = :ru AND pu_show=:SYS_B_1 ORDER BY pu_priority DESC,pu_ord call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 37 0.01 0.01 0 0 0 0 Fetch 37 0.43 0.43 0 512 0 170 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 74 0.44 0.44 0 512 0 170 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_PUBL' 0 BITMAP CONVERSION (TO ROWIDS) 0 BITMAP AND 0 BITMAP CONVERSION (FROM ROWIDS) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_RUBRIC' (NON-UNIQUE) 0 BITMAP MERGE 0 BITMAP INDEX (RANGE SCAN) OF 'AN_PUBL_I3' ******************************************************************************** SELECT pu_id,UPPER(pu_head),pu_subhead,pu_author,pu_image,pu_annotation,TO_CHAR(pu_date,:SYS_B_0),pu_rubric,pu_use_stat FROM an_publ WHERE pu_rubric = :ru AND pu_date>=TO_DATE( :dt1 ,:SYS_B_1) AND pu_date<(TO_DATE( :dt2 ,:SYS_B_2)+:SYS_B_3) ORDER BY pu_priority DESC,pu_ord call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 3060 1.11 1.09 0 0 0 0 Fetch 3119 6.99 6.94 0 23860 0 5689 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 6179 8.10 8.03 0 23860 0 5689 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (ORDER BY) 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'AN_PUBL' 0 BITMAP CONVERSION (TO ROWIDS) 0 BITMAP AND 0 BITMAP CONVERSION (FROM ROWIDS) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_RUBRIC' (NON-UNIQUE) 0 BITMAP CONVERSION (FROM ROWIDS) 0 SORT (ORDER BY) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'AN_IND_PUBL_DATE' (NON-UNIQUE) ******************************************************************************** UPDATE an_stat SET st_ref_value=st_ref_value+1 WHERE st_ref_type = :p1 AND st_ref_id = :p2 call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.03 0 0 0 0 Execute 3 0.01 0.10 0 3 27 3 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 4 0.01 0.13 0 3 27 3 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 30 (TIZV) Rows Execution Plan ------- --------------------------------------------------- 0 UPDATE STATEMENT GOAL: CHOOSE 0 UPDATE OF 'AN_STAT' 0 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'AN_STAT' ******************************************************************************** OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 615435 188.20 190.71 0 0 0 0 Execute 774044 87.20 84.59 0 321 27 3 Fetch 833610 9767.07 9792.88 0 555677989 2303541 1849091 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 2223089 10042.47 10068.18 0 555678310 2303568 1849094 Misses in library cache during parse: 2 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 4 0.00 0.00 0 0 0 0 Execute 5 0.00 0.03 0 0 0 0 Fetch 5 0.00 0.00 0 11 0 2 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 14 0.00 0.03 0 11 0 2 Misses in library cache during parse: 3 615458 user SQL statements in session. 4 internal SQL statements in session. 615462 SQL statements in session. 25 statements EXPLAINed in this session. ******************************************************************************** Trace file: /export/home/oracle/admin/web/udump/web_ora_9732.trc Trace file compatibility: 8.00.04 Sort options: exedsk 1 session in tracefile. 615458 user SQL statements in trace file. 4 internal SQL statements in trace file. 615462 SQL statements in trace file. 29 unique SQL statements in trace file. 25 SQL statements EXPLAINed using schema: TIZV.prof$plan_table Default table was used. Table was created. Table was dropped. 4685020 lines in trace file.