Hi ,
I am facing one issue in APEX version 5.1.0 , where sometimes the below query started in DB by Apex application and occupied 100% CPU usage . Tried to kill the processing of this query but its not working and i restarted the DB . But after someday same problem happened .
Can any body let me know how to avoid these kind of issue and why this query fired by apex application ?
declare rc__ number; simple_list__ owa_util.vc_a
rr; complex_list__ owa_util.vc_arr; begin owa.in
it_cgi_env(:n__,:nm__,:v__); htp.HTBUF_LEN := 63;
null; null; simple_list__(1) := 'sys.%'; simp
le_list__(2) := 'dbms\_%'; simple_list__(3) := 'u
tl\_%'; simple_list__(4) := 'owa\_%'; simple_lis
t__(5) := 'owa.%'; simple_list__(6) := 'htp.%';
simple_list__(7) := 'htf.%'; if ((wwv_flow_epg_in
clude_modules.authorize('wwv_flow.show') = false)
or (owa_match.match_pattern(p_string => 'wwv_fl
ow.show' /* */,p_simple_pattern => simple_li
st__ ,p_complex_pattern => complex_list__
,p_use_special_chars => false))) then rc__
:= 2; else null; null; wwv_flow.show(p_req
uest=>:p_request,p_flow_id=>:p_flow_id,p_flow_step
_id=>:p_flow_step_id,p_instance=>:p_instance,p_deb
ug=>:p_debug); if (wpg_docload.is_file_download)
then rc__ := 1; wpg_docload.get_download_fi
le(:doc_info); null; null; null; commi
t; else rc__ := 0; null; null; null;