oracle中parallel暗示是否和function冲突？

Question

当我在sql语句中调用function后并发不起作用

insert into testTab
select /*+ parallel(3)*/
f_test('11')
from testTab2 A;

create or replace function F_TEST(
paramIn in varchar2
)return varchar2
as
paramRtn varchar2(20);
begin
  select to_char(sysdate,'yyyymmdd HH24:MI:ss')
  into paramRtn
  from dual;
  --dbms_lock.sleep(1);
  return paramRtn;
end;

Answer 1

parallel和function不冲突，只是强制启动多线程，在数据量大的情况下，效果才明显