APEX

Guys,
Yes, you read the title correct.
We were testing our app on a new Oracle 11g 3 node RAC (with Netapp storage) / Apex 3.1.2 and noticed poor performance. Since the environment is completely new we thought we did something wrong in the configuration.
We also opened a SR with Oracle and provided them all the data for diagnostics.
(I will post the Oracle's response in the subsequent posts since I ran into issue with this forum. I don't know why nothing is working for me today)
Not only that, Oracle said, the following query is causing the system slowdown and tune this query (Again in seperate post).
Any help will be appreciated on tuning this query
Thanks
Balaji Chellappa


Note: I am posting this thread in pieces since this forum doesn't let me post in one shot.


-----
{color:#0000ff}Hi,
It looks like you may be running into Bug 4755226, which unfortunately is nto really a bug as it is expected behavior.
The issue appears to be when using the owa commands.
You will need to determine what your code is doing at the time that the issue is occurring, then the {color:#ff0000}*code will need to be modified so it is not making as many owa calls*{color}
Please review the above as well as Bug 4755226 and let me know your status.
Thanks
{color}[{color:#0000ff}https://metalink.oracle.com/CSP/main/article?cmd=show&type=BUG&id=4755226{color}|https://metalink.oracle.com/CSP/main/article?cmd=show&type=BUG&id=4755226]
{color:#0000ff}-----
The following procedure is doing a high number of GET requests causing system slowdown.
QUESTION
=========
1) Are you familiar with this procedure?
SQL ID: cp9jr3hp1jupk
declare rc__ number; simple_list__ owa_util.vc_arr; complex_list__ owa_util.vc_arr; begin owa.init_cgi_env(:n__, :nm__, :v__); htp.HTBUF_LEN := 63; null; null; simple_list__(1) := 'sys.%'; simple_list__(2) := 'dbms\_%'; simple_list__(3) := 'utl\_%'; simple_list__(4) := 'owa\_%'; simple_list__(5) := 'owa.%'; simple_list__(6) := 'htp.%'; simple_list__(7) := 'htf.%'; if ((wwv_flow_epg_include_modules.authorize('f') = false) or (owa_match.match_pattern(p_string => 'f' /* */, p_simple_pattern => simple_list__ , p_complex_pattern => complex_list__ , p_use_special_chars => false))) then rc__ := 2; else null; null; f(p=>:p); if (wpg_docload.is_file_download) then rc__ := 1; wpg_docload.get_download_file(:doc_info); null; null; null; commit; else rc__ := 0; null; null; null; commit; owa.get_page(:data__, :ndata__); end if; end if; :rc__ := rc__; end;
Thanks{color}