在APPLICATION 的FORM中有如下一段语句:
v_b := sysdate;
SELECT count(*)
into v_count
FROM px_ar_invoice_print_v
WHERE (PX_AR_INVOICE_PRINT_V.TAX_PRINT_FLAG<>'Y' OR
PX_AR_INVOICE_PRINT_V.TAX_PRINT_FLAG IS NULL)
AND (PX_AR_INVOICE_PRINT_V.PRINTED<>'Y' OR
PX_AR_INVOICE_PRINT_V.PRINTED IS NULL)
AND PX_AR_INVOICE_PRINT_V.INVOICE_DATE>='6-MAY-2004'
AND PX_AR_INVOICE_PRINT_V.INVOICE_DATE<='6-MAY-2004' ;
v_e := sysdate;
fnd_message.debug(v_count||':'||(v_e-v_b));--显示查找到600条记录,花去6秒
go_block('PX_AR_INVOICE_PRINT_V');
clear_block(no_commit);
v_b := sysdate;
set_block_property('PX_AR_INVOICE_PRINT_V',default_where,v_where_1||v_where_2||v_where_3||v_where_4||v_where_5||v_where_6);
/*其中DEFAULT_WHERE的语句与上面的WHERE语句相同*/execute_query;
v_e := sysdate;fnd_message.debug('execute_query:'||(v_e-v_b));--结果执行不到这一步,程序一直在写TEMP TABLESPACE,直到TEMP TABLESPACE的空间爆掉。请高手解答,谢谢!!!
v_b := sysdate;
SELECT count(*)
into v_count
FROM px_ar_invoice_print_v
WHERE (PX_AR_INVOICE_PRINT_V.TAX_PRINT_FLAG<>'Y' OR
PX_AR_INVOICE_PRINT_V.TAX_PRINT_FLAG IS NULL)
AND (PX_AR_INVOICE_PRINT_V.PRINTED<>'Y' OR
PX_AR_INVOICE_PRINT_V.PRINTED IS NULL)
AND PX_AR_INVOICE_PRINT_V.INVOICE_DATE>='6-MAY-2004'
AND PX_AR_INVOICE_PRINT_V.INVOICE_DATE<='6-MAY-2004' ;
v_e := sysdate;
fnd_message.debug(v_count||':'||(v_e-v_b));--显示查找到600条记录,花去6秒
go_block('PX_AR_INVOICE_PRINT_V');
clear_block(no_commit);
v_b := sysdate;
set_block_property('PX_AR_INVOICE_PRINT_V',default_where,v_where_1||v_where_2||v_where_3||v_where_4||v_where_5||v_where_6);
/*其中DEFAULT_WHERE的语句与上面的WHERE语句相同*/execute_query;
v_e := sysdate;fnd_message.debug('execute_query:'||(v_e-v_b));--结果执行不到这一步,程序一直在写TEMP TABLESPACE,直到TEMP TABLESPACE的空间爆掉。请高手解答,谢谢!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货