oracle执行存储过程卡顿,一个存储过程执行速度的有关问题.

SQL codeDECLARE

IN_COMMUNITY_NAME VARCHAR2(200);

IN_STANDARD_ADDR_NAME VARCHAR2(200);

IN_PROD_SPEC_ID NUMBER;

IN_BUSINESS_TYPE VARCHAR2(200);

IN_USER_TYPE NUMBER;

IN_AREA_ID NUMBER;

IN_CONDITION_TYPE VARCHAR2(200);

IN_BEGIN_ROW NUMBER;

IN_END_ROW NUMBER;

OUT_ATTRS RMS.PG_RMS_FOR_CRM_NEW.c_list;

OUT_ROW_COUNT NUMBER;

OUT_RET_CODE VARCHAR2(200);

OUT_RET_INFO VARCHAR2(200);

v_community_state number;

v_gpon_not_rsc_spec varchar2(200);

v_ocn_not_rsc_spec varchar2(200);

V_OUT_ROW_COUNT number;

v_start number;

BEGIN

IN_COMMUNITY_NAME := '%田林十四村二期%';

IN_STANDARD_ADDR_NAME := '%路%';

IN_PROD_SPEC_ID := '';

IN_BUSINESS_TYPE := 'FixPhone';

IN_USER_TYPE := 1;

IN_AREA_ID := 15;

IN_CONDITION_TYPE := '0';

IN_BEGIN_ROW := 1;

IN_END_ROW := 100;

v_community_state := 4;

v_ocn_not_rsc_spec := '10304200';

v_gpon_not_rsc_spec := '10102007';

v_start := dbms_utility.get_time;

select count(1) into v_out_row_count from regional_loc rl,regional_loc_2_community rl2c,community c

where rl.geography_loc_id = rl2c.geography_loc_id and rl2c.community_id = c.community_id and rl.display_type_cd = 1

and c.status = 4

and rl.description like IN_STANDARD_ADDR_NAME and c.name like IN_COMMUNITY_NAME

and rl.regional_simple_spell like '%%' and c.community_simple_spell like '%%'

and rl.user_type_id in ( 1 ,3)

and c.rsc_spec_id <> v_ocn_not_rsc_spec

and c.rsc_spec_id <> v_gpon_not_rsc_spec

and rl.area_id = 15 ;

DBMS_OUTPUT.PUT_LINE('OUT_ROW_COUNT = ' || v_out_row_count);

dbms_output.put_line('time = ' || (dbms_utility.get_time - v_start) * 10);

END;