Low Performance of APEX Application.
Application built on APEX 22.1 (Oracle 19c) having very low performance on production environment, whereas same application is running good on stagging, only difference is that production using WebLogic and DB are on separate VMs and stagging have only one VM containing database and ORDS/TOMCAT
on the problematic node, oracle enterprise manager showing following scripts taking time
begin
wwv_flow.resolve_friendly_url(p_path => :1 );
end;
begin
f(p=>:1 ,
cs=>:2 );
commit;
end;