Уважаемые господа программисты и администраторы!
Помогите, может кто то из вас сталкивался.

Проблема:
У пользователей системы в вэб броузере периодически при нажитии на какую нибудь из ссылок
возникает ПУСТАЯ СТРАНИЦА, т.е. - нет сообщении типа Page Not Found HTTP - 404 или HTTP - 500, а именно пустая страница длиной 0 байт. При чем она не возникает через какое либо время ожидания от сервера а моментально про нажатии ссылки.
При нажатии Ctrl+F5 или Back и повторном нажатии на ссылку всё работает.

В логах БД никаких сопутствующих ошибок нет.
В error логах апача тоже всё ок.
В access логах апача - мы видим запрос и ответ НТТР-200 0 байт.

Может есть у кого нибудь какие либо соображения?

Apex - 3.0.1.00.08
Oracle RDBMS 10.2.0.4

P.S.
Правда есть некоторые ошибки в error логах апача такого вида

[ecid: 1215669777:192.168.0.40:23143:0:9796,0] File does not exist: /opt/oracle/apexhome/Apache/Apache/htdocs/_vti_bin/owssvr.dll
[ecid: 1215669777:192.168.0.40:23135:0:10332,0] File does not exist: /opt/oracle/apexhome/Apache/Apache/htdocs/MSOffice/cltreq.asp
[ecid: 1215672374:192.168.0.40:23182:0:9468,0] File does not exist: /opt/oracle/apexhome/Apache/Apache/htdocs/_vti_bin/owssvr.dll
[ecid: 1215672375:192.168.0.40:23182:0:9469,0] File does not exist: /opt/oracle/apexhome/Apache/Apache/htdocs/MSOffice/cltreq.asp
[ecid: 1215672563:192.168.0.40:23163:0:9266,0] File does not exist: /opt/oracle/apexhome/Apache/Apache/htdocs/_vti_bin/owssvr.dll
[ecid: 1215672563:192.168.0.40:23163:0:9267,0] File does not exist: /opt/oracle/apexhome/Apache/Apache/htdocs/MSOffice/cltreq.asp
[ecid: 1215673270:192.168.0.40:26079:0:73,0] File does not exist: /opt/oracle/apexhome/Apache/Apache/htdocs/_vti_bin/owssvr.dll
[ecid: 1215673270:192.168.0.40:26079:0:74,0] File does not exist: /opt/oracle/apexhome/Apache/Apache/htdocs/MSOffice/cltreq.asp
[ecid: 1215674754:192.168.0.40:23168:0:10331,0] File does not exist: /opt/oracle/apexhome/Apache/Apache/htdocs/favicon.ico

- непонятно только при чём здесь *.dll и *.asp - файлы? Система на Линуксе..

YAP SergheyGo
[ecid: 1215669777:192.168.0.40:23143:0:9796,0] File does not exist: /opt/oracle/apexhome/Apache/Apache/htdocs/_vti_bin/owssvr.dll
[ecid: 1215669777:192.168.0.40:23135:0:10332,0] File does not exist: /opt/oracle/apexhome/Apache/Apache/htdocs/MSOffice/cltreq.asp

я у себя тоже такое видел, не вирусня ли какая?

а как выглядит запрос и ответ апача (выдержку из лога)?

- в error log - это единственные сообщения об ошибках и никак не привязаны к моментам появления "пустых страниц".
- access log - я смогу показать только завтра.

Завтра с утра выложу фрагменты...

192.168.0.3 - - [11/Jul/2008:09:33:11 +0300] "GET /i/themes/theme_13/left_curve.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:11 +0300] "GET /i/themes/theme_13/right_curve.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:11 +0300] "GET /i/themes/theme_13/im/printer.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:11 +0300] "GET /i/jtfunexe.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:11 +0300] "GET /i/e2.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:11 +0300] "GET /i/asfdcldr.gif HTTP/1.1" 304 -
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:33:13 +0300] "GET /pls/apex/f?p=150:46:3203375076123773:NEWDOC:NO:46:: HTTP/1.1" 200 30124
192.168.0.3 - - [11/Jul/2008:09:33:13 +0300] "GET /i/htmldb/builder/builder_find_top.png HTTP/1.1" 304 -
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:33:13 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650
192.168.0.3 - - [11/Jul/2008:09:33:13 +0300] "GET /i/htmldb/builder/builder_find_bg.png HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:13 +0300] "GET /i/list_gray.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:13 +0300] "GET /i/htmldb/builder/builder_find_bottom.png HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:13 +0300] "GET /i/themes/theme_13/1px_trans.gif HTTP/1.1" 304 -
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:33:43 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 162
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:33:43 +0300] "GET /pls/apex/f?p=150:46:3203375076123773:SEARCH_D:NO::: HTTP/1.1" 200 30234
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:33:43 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:33:46 +0300] "GET /pls/apex/wwv_flow_utilities.show_as_popup_calendar?p_element_index=p_t19&p_form_index=0&p_date_format=DD-MM-YYYY&p_bgcolor=%23666666&p_dd=&p_hh=&p_mi=&p_pm=&p_yyyy=2008&p_lang=ro&p_application_format=Y&p_application_id=150&p_security_group_id=937124799235834&p_mm=07 HTTP/1.1" 200 11779
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:33:52 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 162
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:33:54 +0300] "GET /pls/apex/f?p=150:37:3203375076123773::NO:::&success_msg=Documentul%20a%20fost%20creat%20cu%20succes%2F290734D68722DFA262A91D2FF46BB1E8%2F HTTP/1.1" 200 36909
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/themes/theme_13/im/an.css HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/themes/theme_13/theme_V3.css HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/themes/theme_13/js/jquery-1.1.3.1.pack.js HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/themes/theme_13/js/sp.js HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/themes/theme_13/js/jquery.cookie.pack.js HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/javascript/htmldb_html_elements.js HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/javascript/htmldb_get.js HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/css/core_V22.css HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/css/core_ie_V22.css HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/themes/theme_13/js/ApexLib_Field.js HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/themes/theme_13/js/ApexLib_Core.js HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/themes/theme_13/js/jscript_util.js HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/arrow_down_gray_dark.gif HTTP/1.1" 304 -
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:33:54 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/e2.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/themes/theme_13/im/printer.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/themes/theme_13/left_curve.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/themes/theme_13/right_curve.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/jtfunexe.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:54 +0300] "GET /i/asfdcldr.gif HTTP/1.1" 304 -
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:33:56 +0300] "GET /pls/apex/f?p=150:46:3203375076123773:NEWDOC:NO:46:: HTTP/1.1" 200 30124
192.168.0.3 - - [11/Jul/2008:09:33:56 +0300] "GET /i/htmldb/builder/builder_find_top.png HTTP/1.1" 304 -
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:33:56 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650
192.168.0.3 - - [11/Jul/2008:09:33:56 +0300] "GET /i/htmldb/builder/builder_find_bottom.png HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:56 +0300] "GET /i/htmldb/builder/builder_find_bg.png HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:56 +0300] "GET /i/list_gray.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:09:33:56 +0300] "GET /i/themes/theme_13/1px_trans.gif HTTP/1.1" 304 -
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:09:34:13 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 200 5
-----------------------------------------------------------------------------------------------------------
Вышла белая страница (на самом деле присутствуют теги <html></html> .... и всё.

а в чём странность логов?

вот ещё несколько фрагментов

192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:04:11 +0300] "GET /pls/apex/f?p=150:92:3203375076123773::NO:RP:: HTTP/1.1" 200 0
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:04:11 +0300] "GET /pls/apex/f?p=150:92:3203375076123773::NO:RP:: HTTP/1.1" 200 24318
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:04:11 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:04:17 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 162
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:04:20 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 162
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:04:28 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 200 5
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:04:28 +0300] "GET /pls/apex/f?p=150:92:3203375076123773::NO:RP:: HTTP/1.1" 200 0
-------------------------------------------------------------------------------------------------------------
юзер нажал Ctrl + F5
-------------------------------------------------------------------------------------------------------------
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:04:39 +0300] "GET /pls/apex/f?p=150:92:3203375076123773::NO:RP:: HTTP/1.1" 200 38667
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:04:40 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:05:30 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 162
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:05:30 +0300] "GET /pls/apex/f?p=150:64:44022275107991::NO:64:P64_ACTION,P64_ID_MES,P64_FROM_USER,P64_FOLDER,P64_TO_USER:REPLAY%2C6417%2C0971811364187%2CI%2C0982404336405 HTTP/1.1" 200 21334
192.168.0.3 - - [11/Jul/2008:10:05:31 +0300] "GET /i/themes/theme_13/im/an.css HTTP/1.1" 200 2726
192.168.0.3 - - [11/Jul/2008:10:05:31 +0300] "GET /i/themes/theme_13/theme_V3.css HTTP/1.1" 200 29138
192.168.0.3 - - [11/Jul/2008:10:05:31 +0300] "GET /i/themes/theme_13/js/jquery-1.1.3.1.pack.js HTTP/1.1" 200 21557




192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:24:43 +0300] "GET /pls/apex/f?p=150:46:44022275107991::NO::: HTTP/1.1" 200 27937
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:24:43 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:24:48 +0300] "GET /pls/apex/wwv_flow_utilities.show_as_popup_calendar?p_element_index=p_t19&p_form_index=0&p_date_format=DD-MM-YYYY&p_bgcolor=%23666666&p_dd=&p_hh=&p_mi=&p_pm=&p_yyyy=2008&p_lang=ro&p_application_format=Y&p_application_id=150&p_security_group_id=937124799235834&p_mm=07 HTTP/1.1" 200 11779
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:25:14 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 200 5
-------------------------------------------------------------------------------------------------------------
Ctrl + F5
-------------------------------------------------------------------------------------------------------------
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:26:34 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 162
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:26:35 +0300] "GET /pls/apex/f?p=150:37:44022275107991::NO:::&success_msg=Documentul%20a%20fost%20creat%20cu%20succes%2F270EEA2F03353E2FF72078A58009ECD2%2F HTTP/1.1" 200 26191
192.168.0.3 - - [11/Jul/2008:10:26:35 +0300] "GET /i/themes/theme_13/im/an.css HTTP/1.1" 200 2726
192.168.0.3 - - [11/Jul/2008:10:26:35 +0300] "GET /i/themes/theme_13/theme_V3.css HTTP/1.1" 200 29138
192.168.0.3 - - [11/Jul/2008:10:26:35 +0300] "GET /i/themes/theme_13/js/jquery-1.1.3.1.pack.js HTTP/1.1" 200 21557
192.168.0.3 - - [11/Jul/2008:10:26:35 +0300] "GET /i/themes/theme_13/js/sp.js HTTP/1.1" 200 1621
192.168.0.3 - - [11/Jul/2008:10:26:36 +0300] "GET /i/themes/theme_13/js/jquery.cookie.pack.js HTTP/1.1" 200 1053
192.168.0.3 - - [11/Jul/2008:10:26:36 +0300] "GET /i/javascript/htmldb_html_elements.js HTTP/1.1" 200 64078
192.168.0.3 - - [11/Jul/2008:10:26:36 +0300] "GET /i/javascript/htmldb_get.js HTTP/1.1" 200 11144
192.168.0.3 - - [11/Jul/2008:10:26:36 +0300] "GET /i/css/core_V22.css HTTP/1.1" 200 7153
192.168.0.3 - - [11/Jul/2008:10:26:36 +0300] "GET /i/css/core_ie_V22.css HTTP/1.1" 200 215
192.168.0.3 - - [11/Jul/2008:10:26:36 +0300] "GET /i/themes/theme_13/js/ApexLib_Field.js HTTP/1.1" 200 29570
192.168.0.3 - - [11/Jul/2008:10:26:36 +0300] "GET /i/themes/theme_13/js/ApexLib_Core.js HTTP/1.1" 200 10902
192.168.0.3 - - [11/Jul/2008:10:26:36 +0300] "GET /i/themes/theme_13/js/jscript_util.js HTTP/1.1" 200 3791
192.168.0.3 - - [11/Jul/2008:10:26:36 +0300] "GET /i/themes/theme_13/left_curve.gif HTTP/1.1" 200 188
192.168.0.3 - - [11/Jul/2008:10:26:36 +0300] "GET /i/arrow_down_gray_dark.gif HTTP/1.1" 200 98
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:26:36 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650



192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:37:15 +0300] "GET /pls/apex/f?p=150:46:44022275107991:NEWDOC:NO:46:: HTTP/1.1" 200 27829
192.168.0.3 - - [11/Jul/2008:10:37:15 +0300] "GET /i/htmldb/builder/builder_find_top.png HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:10:37:15 +0300] "GET /i/htmldb/builder/builder_find_bottom.png HTTP/1.1" 304 -
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:37:15 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650
192.168.0.3 - - [11/Jul/2008:10:37:15 +0300] "GET /i/list_gray.gif HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:10:37:15 +0300] "GET /i/htmldb/builder/builder_find_bg.png HTTP/1.1" 304 -
192.168.0.3 - - [11/Jul/2008:10:37:15 +0300] "GET /i/themes/theme_13/1px_trans.gif HTTP/1.1" 304 -
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:37:44 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 200 5
-------------------------------------------------------------------------------------------------------------
Ctrl + F5
[oracle@apptest logs]$ tail -f ./access_log.1215734400 | grep 192.168.0.3
-------------------------------------------------------------------------------------------------------------
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:39:01 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 162
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:39:01 +0300] "GET /pls/apex/f?p=150:46:44022275107991:SEARCH_D:NO::: HTTP/1.1" 200 27937
192.168.0.3 - - [11/Jul/2008:10:39:01 +0300] "GET /i/themes/theme_13/im/an.css HTTP/1.1" 200 2726
192.168.0.3 - - [11/Jul/2008:10:39:01 +0300] "GET /i/themes/theme_13/theme_V3.css HTTP/1.1" 200 29138
192.168.0.3 - - [11/Jul/2008:10:39:01 +0300] "GET /i/themes/theme_13/js/jquery-1.1.3.1.pack.js HTTP/1.1" 200 21557
192.168.0.3 - - [11/Jul/2008:10:39:01 +0300] "GET /i/themes/theme_13/js/sp.js HTTP/1.1" 200 1621
192.168.0.3 - - [11/Jul/2008:10:39:01 +0300] "GET /i/themes/theme_13/js/jquery.cookie.pack.js HTTP/1.1" 200 1053






192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:40:57 +0300] "GET /pls/apex/f?p=150:48:44022275107991::NO:48,49:P48_DOC_ID:486287: HTTP/1.1" 200 16474
192.168.0.3 - - [11/Jul/2008:10:40:57 +0300] "GET /i/themes/theme_13/1px_trans.gif HTTP/1.1" 304 -
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:40:57 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:41:25 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 200 16632
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:41:26 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:41:31 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 162
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:41:31 +0300] "GET /pls/apex/f?p=150:49:44022275107991::NO::: HTTP/1.1" 200 16581
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:41:31 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3662
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:41:32 +0300] "GET /pls/apex/f3?p_doc_id=486287 HTTP/1.1" 200 499719
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:41:34 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 162
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:41:34 +0300] "GET /pls/apex/f?p=150:37:44022275107991::NO:::&success_msg=Documentul%20a%20fost%20tip%C4%83rit%2F7B262F528DA37567DE915610E15343D6%2F HTTP/1.1" 200 5
-------------------------------------------------------------------------------------------------------------
юзер нажал Ctrl + F5
[oracle@apptest logs]$ tail -f ./access_log.1215734400 | grep 192.168.0.3
-------------------------------------------------------------------------------------------------------------
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:44:49 +0300] "GET /pls/apex/f?p=150:37:44022275107991::NO:::&success_msg=Documentul%20a%20fost%20tip%C4%83rit%2F7B262F528DA37567DE915610E15343D6%2F HTTP/1.1" 200 24027
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/themes/theme_13/im/an.css HTTP/1.1" 200 2726
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/themes/theme_13/theme_V3.css HTTP/1.1" 200 29138
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/themes/theme_13/js/jquery-1.1.3.1.pack.js HTTP/1.1" 200 21557
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/themes/theme_13/js/sp.js HTTP/1.1" 200 1621
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/themes/theme_13/js/jquery.cookie.pack.js HTTP/1.1" 200 1053
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/javascript/htmldb_html_elements.js HTTP/1.1" 200 64078
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/javascript/htmldb_get.js HTTP/1.1" 200 11144
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/css/core_V22.css HTTP/1.1" 200 7153
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/css/core_ie_V22.css HTTP/1.1" 200 215
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/themes/theme_13/js/ApexLib_Field.js HTTP/1.1" 200 29570
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/themes/theme_13/js/ApexLib_Core.js HTTP/1.1" 200 10902
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/themes/theme_13/js/jscript_util.js HTTP/1.1" 200 3791
192.168.0.3 - - [11/Jul/2008:10:44:49 +0300] "GET /i/themes/theme_13/left_curve.gif HTTP/1.1" 200 188
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:10:44:49 +0300] "GET /pls/apex/wwv_flow_file_mgr.get_file?p_security_group_id=937124799235834&p_fname=gerb2.gif HTTP/1.1" 200 3650

Здесь как видно не какая то определённая страница....
Это происходит с разными страницами.
92,46,37 - это страницы с которыми в данный момент работает юзер.

Когда пользователи работают, периодически (довольно часто) они получают "ПУСТЫЕ СТРАНИЦЫ"

Почему получается так, что при вызове сабмита (т.е. wwv_flow.accept)
один раз пользователи получают пустую станицу, а в следующий раз по (Ctrl+F5) с теми же параметрами - срабатывает нормально?
Может кто встречался с чем то подобным? Или как можно более понятно и подробно оттрассировать эти сессии?
В каком направлении ещё копать?

В алерт логе БД - всё чисто - только переключения журналов... Сейчас не могу привести выдержку, но это точно!!!

Первый сервер Oracle RDBMS 10.2.0.4 (Linux x86 32 bit Oracle Enterprise Linux 5 (RHEL))

Второй сервер
Oracle HTTP Server
Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP
- установлен с Companion CD for Oracle 10gR2.

ApEx - version 3.0.8


Вот более подробные выдержки :
============================================================
access_log
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:13:22:34 +0300] "GET /pls/apex/wwv_flow_utilities.gen_popup_list?p_name=p_t10&p_lov=227476722828107914&p_lov_checksum=0BAE475CDDA19BE2DAB43AAC0FC087C7&p_request=NEXT&p_element_index=12&p_form_index=0&p_max_elements=&p_escape_html=&p_eval_value=&p_translation=N&p_item_id=227476722828107914&p_return_key=YES&p_hidden_elem_name=p_t09&p_ok_to_query=YES&p_flow_id=150&p_page_id=36&p_session_id=44022275107991&p_company=937124799235834&p_filter=&p_min_row=1 HTTP/1.1" 200 4711
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:13:23:20 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 200 5
***************************************
* В этот момент у пользователя появилась "blank page" - только <html></html> без содержимого.
* Потом юзер нажал "Ctrl+F5" - и продолжил нормальную работу.
* И соответственно получил редирект на /f?p=150:46.
***************************************
[oracle@apptest logs]$ tail -f ./access_log.1215734400 | grep 192.168.0.3
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:13:24:57 +0300] "POST /pls/apex/wwv_flow.accept HTTP/1.1" 302 162
192.168.0.3 - APEX_PUBLIC_USER [11/Jul/2008:13:24:57 +0300] "GET /pls/apex/f?p=150:46:44022275107991::NO:36::&success_msg=Datele%20sunt%20salvate%2F270F569388A882C6675810F0BD91AB61%2F HTTP/1.1" 200 28197
192.168.0.3 - - [11/Jul/2008:13:24:57 +0300] "GET /i/themes/theme_13/theme_V3.css HTTP/1.1" 304 -

============================================================
Extras from
error_log (appropriate places with bold font)

[Fri Jul 11 13:22:34 2008] [info] [client 192.168.0.3] [ecid: 1215771754:192.168.0.40:28022:0:566,0] mod_plsql: [perf] /pls/apex/wwv_flow_utilities.gen_popup_list status=200 user=APEX_PUBLIC_USER reqTime=20ms connSU=(null),0ms connRO=(null),0ms connNSSO=HIT,0ms procTime=20ms sessionTidyTime=0ms cache=(null) cookie=(null),0ms pageCalls=0,0ms bytes=4711 describe=No,0ms streamTime=0ms pid=6d76 sessFile=(null) userFile=466/1460 sysFile=755/3610 cacheLevel=(null) cacheTime=0ms dbProcTime=20ms spid=(null) qs=(null) requestTrace=(null) cookieLen=0 cookieValue=(null) reqUserTime=20ms assertUser=(null) subid=(null) authLevel=(null) oraError=0

[Fri Jul 11 13:23:20 2008] [info] [client 192.168.0.3] [ecid: 1215771800:192.168.0.40:27973:0:487,0]
mod_plsql: [perf] /pls/apex/wwv_flow.accept status=200
user=APEX_PUBLIC_USER reqTime=10ms connSU=(null),0ms connRO=(null),0ms connNSSO=HIT,0ms procTime=10ms sessionTidyTime=0ms
cache=(null) cookie=(null),0ms pageCalls=0,0ms bytes=0 describe=No,0ms streamTime=0ms pid=6d45 sessFile=(null) userFile=234/6395
sysFile=754/1393 cacheLevel=(null) cacheTime=0ms dbProcTime=0ms spid=(null) qs=(null) requestTrace=(null) cookieLen=0
cookieValue=(null) reqUserTime=10ms assertUser=(null) subid=(null) authLevel=(null) oraError=0

[Fri Jul 11 13:24:57 2008] [info] [client 192.168.0.3] [ecid: 1215771897:192.168.0.40:27989:0:417,0]
mod_plsql: [perf] /pls/apex/f status=200
user=APEX_PUBLIC_USER reqTime=160ms connSU=(null),0ms connRO=(null),0ms connNSSO=HIT,0ms procTime=150ms sessionTidyTime=0ms
cache=(null) cookie=(null),0ms pageCalls=0,0ms bytes=28197 describe=No,0ms streamTime=10ms pid=6d55 sessFile=(null) userFile=939/8610
sysFile=184/8008 cacheLevel=(null) cacheTime=0ms dbProcTime=140ms spid=(null) qs=(null) requestTrace=(null) cookieLen=0
cookieValue=(null) reqUserTime=160ms assertUser=(null) subid=(null) authLevel=(null) oraError=0

[Fri Jul 11 13:24:58 2008] [info] [client 192.168.0.3] [ecid: 1215771898:192.168.0.40:27980:0:431,0] mod_plsql: [perf] /pls/ apex/wwv_flow_file_mgr.get_file status=200 user=APEX_PUBLIC_USER reqTime=10ms connSU=(null),0ms connRO=(null),0ms connNSSO=H IT,0ms procTime=10ms sessionTidyTime=0ms cache=(null) cookie=(null),0ms pageCalls=0,0ms bytes=3650 describe=No,0ms streamTim e=0ms pid=6d4c sessFile=(null) userFile=326/3361 sysFile=506/8279 cacheLevel=(null) cacheTime=0ms dbProcTime=0ms spid=(null) qs=(null) requestTrace=(null) cookieLen=0 cookieValue=(null) reqUserTime=10ms assertUser=(null) subid=(null) authLevel=(nul l) oraError=0

====================================================
And now dumps from mod_plsql.log

This is unsuccessful page submit:


<316051064 ms>[ReqStartTime: 11/Jul/2008:13:23:20]
<316051064 ms>Request ID ReqID:27973_1215771800
<316051064 ms>Connecting to database with connect string : "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.42)(PORT=1521)))(CONNECT_DATA=(S
<316051064 ms>OpenCursor
<316051064 ms>(wpd.c,1761) Logged in as (unknown)
<316051064 ms>(wpx.c,595) Going to select...
<316051064 ms>(wpx.c,649) Have been asked to execute a request
<316051064 ms>(wppa.c,332) Building Arglist based on Parsed Content from WRB
<316051064 ms>(wppa.c,1012) Enter ParseUrlData
<316051064 ms>POST
<316051064 ms>(wpu.c,256) Attempting to read 980 bytes
<316051064 ms>(wpu.c,261) We read 980, had 0, to get 0 bytes
<316051064 ms>[headers begin]
<316051064 ms>HTTP_COOKIE(11): (77)AnMenu=_p00011_; LOGIN_USERNAME_COOKIE=0982404336405; ANIMAL=58AB0445E15C7111
<316051064 ms>[headers end]
<316051064 ms>p_flow_id=150&p_flow_step_id=36&p_instance=44022275107991&p_page_submission_id=5213326&p_request=SAVE&p_arg_names=209374629360468065&p_t01=01000
<316051064 ms>[form_data]
<316051064 ms>p_flow_id=150&p_flow_step_id=36&p_instance=44022275107991&p_page_submission_id=5213326&p_request=SAVE&p_arg_names=209374629360468065&p_t01=01000
<316051064 ms>(wppa.c,1506) indx = 43, entryCnt = 43
<316051064 ms>(wppa.c,1605) Array bind graduated (19=>20, 19=>32)
<316051064 ms>(wppa.c,1827) Listing distinct actual names:
<316051064 ms>(wppa.c,1829) p_flow_id
<316051064 ms>(wppa.c,1829) p_flow_step_id
<316051064 ms>(wppa.c,1829) p_instance
<316051064 ms>(wppa.c,1829) p_page_submission_id
<316051064 ms>(wppa.c,1829) p_request
<316051064 ms>(wppa.c,1829) p_arg_names
<316051064 ms>(wppa.c,1829) p_t01
<316051064 ms>(wppa.c,1829) p_t02
<316051064 ms>(wppa.c,1829) p_t03
<316051064 ms>(wppa.c,1829) p_t04
<316051064 ms>(wppa.c,1829) p_t05
<316051064 ms>(wppa.c,1829) p_t06
<316051064 ms>(wppa.c,1829) p_t07
<316051064 ms>(wppa.c,1829) p_t08
<316051064 ms>(wppa.c,1829) p_t09
<316051064 ms>(wppa.c,1829) p_t11
<316051064 ms>(wppa.c,1829) p_t12
<316051064 ms>(wppa.c,1829) p_t13
<316051064 ms>(wppa.c,1829) p_t14
<316051064 ms>(wppa.c,1829) p_t15
<316051064 ms>(wppa.c,1829) p_t16
<316051064 ms>(wppa.c,1829) p_t17
<316051064 ms>(wppa.c,1829) p_t18
<316051064 ms>(wppa.c,1829) p_t19
<316051064 ms>(wppa.c,1829) p_md5_checksum
<316051064 ms>(wppa.c,1831) Listing actuals of array with large entries:
<316051064 ms>(wppa.c,1836) Listing distinct actual names and values:
<316051064 ms>(wppa.c,1868) p_flow_id, type = 0, value (4) = 150
<316051064 ms>(wppa.c,1868) p_flow_step_id, type = 0, value (3) = 36
<316051064 ms>(wppa.c,1868) p_instance, type = 0, value (15) = 44022275107991
<316051064 ms>(wppa.c,1868) p_page_submission_id, type = 0, value (8) = 5213326
<316051064 ms>(wppa.c,1868) p_request, type = 0, value (5) = SAVE
<316051064 ms>(wppa.c,1860) p_arg_names (maxlen 19), small array, values:
<316051064 ms>(wppa.c,1863) 209374629360468065
<316051064 ms>(wppa.c,1863) 209376137305475675
<316051064 ms>(wppa.c,1863) 227475931186107912
<316051064 ms>(wppa.c,1863) 227477740265107916
<316051064 ms>(wppa.c,1863) 227477121811107915
<316051064 ms>(wppa.c,1863) 227476343883107913
<316051064 ms>(wppa.c,1863) 227476121631107913
<316051064 ms>(wppa.c,1863) 227476523459107913
<316051064 ms>(wppa.c,1863) 227476722828107914
<316051064 ms>(wppa.c,1863) 0
<316051064 ms>(wppa.c,1863) 227476945791107914
<316051064 ms>(wppa.c,1863) 227477345574107915
<316051064 ms>(wppa.c,1863) 204942321852400446
<316051064 ms>(wppa.c,1863) 204942534747400447
<316051064 ms>(wppa.c,1863) 204942730225400447
<316051064 ms>(wppa.c,1863) 204942923751400447
<316051064 ms>(wppa.c,1863) 204943114092400447
<316051064 ms>(wppa.c,1863) 204943330624400447
<316051064 ms>(wppa.c,1863) 204943529770400447
<316051064 ms>(wppa.c,1868) p_t01, type = 0, value (7) = 010001
<316051064 ms>(wppa.c,1868) p_t02, type = 0, value (14) = Pleşca Maria
<316051064 ms>(wppa.c,1868) p_t03, type = 0, value (14) = 0982810492504
<316051064 ms>(wppa.c,1868) p_t04, type = 0, value (3) = 46
<316051064 ms>(wppa.c,1868) p_t05, type = 0, value (14) = 0982810492504
<316051064 ms>(wppa.c,1868) p_t06, type = 0, value (7) = Jalbă
<316051064 ms>(wppa.c,1868) p_t07, type = 0, value (7) = Vasile
<316051064 ms>(wppa.c,1868) p_t08, type = 0, value (3) = 21
<316051064 ms>(wppa.c,1868) p_t09, type = 0, value (4) = 234
<316051064 ms>(wppa.c,1868) p_t11, type = 0, value (21) = Sector Mănăstirea
<316051064 ms>(wppa.c,1868) p_t12, type = 0, value (9) = D_EVENTS
<316051064 ms>(wppa.c,1868) p_t13, type = 0, value (14) = 0982810492504
<316051064 ms>(wppa.c,1868) p_t14, type = 0, value (7) = Jalbă
<316051064 ms>(wppa.c,1868) p_t15, type = 0, value (7) = Vasile
<316051064 ms>(wppa.c,1868) p_t16, type = 0, value (9) = Ialoveni
<316051064 ms>(wppa.c,1868) p_t17, type = 0, value (8) = Răzeni
<316051064 ms>(wppa.c,1868) p_t18, type = 0, value (8) = < - - -
<316051064 ms>(wppa.c,1868) p_t19, type = 0, value (1) =
<316051064 ms>(wppa.c,1868) p_md5_checksum, type = 0, value (1) =
<316051064 ms>(wppa.c,427) Arglist built, 25 unique entries
<316051064 ms>(wpx.c,656) Going to wpprodb_OciDoBlock...
<316051064 ms>(wpd.c,2746) Cache enabled. Gathering cache information.
<316051064 ms>(wpd.c,2764) Language for this request is ru-md,ro-md;q=0.7,en-us;q=0.3
<316051064 ms>(wpd.c,2815) Using user APEX_PUBLIC_USER for caching.
<316051064 ms>cache: Checking for user level hit
<316051064 ms>cache: Cache MISS user - /opt/oracle/apexhome/Apache/modplsql/cache/plsql/234/6395
<316051064 ms>cache: Checking for system level hit
<316051064 ms>cache: Cache MISS system - /opt/oracle/apexhome/Apache/modplsql/cache/plsql/sys/754/1393
<316051064 ms>(wppr.c,459) start working with wwv_flow.accept
<316051064 ms>(wppr.c,1163) The CALL block: len=1381, bind_count=33
declare
rc__ number;
start_time__ binary_integer;
simple_list__ owa_util.vc_arr;
complex_list__ owa_util.vc_arr;
begin
start_time__ := dbms_utility.get_time;
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 ((owa_match.match_pattern('wwv_flow.accept', simple_list__, complex_list__, true))) then
rc__ := 2;
else
null;
null;
wwv_flow.accept(p_flow_id=>:p_flow_id,p_flow_step_id=>:p_flow_step_id,p_instance=>:p_instance,p_page_submission_id=>:p_page_submission_id,p_request=>:p_requ
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__;
:db_proc_time__ := dbms_utility.get_time - start_time__;
end;
<316051064 ms>(wppr.c,519) Pl/sql block parsed...
<316051064 ms>(wpdenv.c,1526) CGI Environment has 31 vars. Max name len 128, Max Value Len 512
<316051064 ms> PLSQL_GATEWAY(14)=(6)WebDb
<316051064 ms> GATEWAY_IVERSION(17)=(2)3
<316051064 ms> SERVER_SOFTWARE(16)=(60)Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server
<316051064 ms> GATEWAY_INTERFACE(18)=(8)CGI/1.1
<316051064 ms> SERVER_PORT(12)=(5)7780
<316051064 ms> SERVER_NAME(12)=(8)apptest
<316051064 ms> REQUEST_METHOD(15)=(5)POST
<316051064 ms> PATH_INFO(10)=(17)/wwv_flow.accept
<316051064 ms> SCRIPT_NAME(12)=(10)/pls/apex
<316051064 ms> REMOTE_ADDR(12)=(12)192.168.0.3
<316051064 ms> SERVER_PROTOCOL(16)=(9)HTTP/1.1
<316051064 ms> REQUEST_PROTOCOL(17)=(5)HTTP
<316051064 ms> REMOTE_USER(12)=(17)APEX_PUBLIC_USER
<316051064 ms> HTTP_CONTENT_LENGTH(20)=(4)980
<316051064 ms> HTTP_CONTENT_TYPE(18)=(34)application/x-www-form-urlencoded
<316051064 ms> HTTP_USER_AGENT(16)=(99)Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)
<316051064 ms> HTTP_HOST(10)=(18)192.168.0.40:7780
<316051064 ms> HTTP_ACCEPT(12)=(272)image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/
<316051064 ms> HTTP_ACCEPT_ENCODING(21)=(14)gzip, deflate
<316051064 ms> HTTP_ACCEPT_LANGUAGE(21)=(30)ru-md,ro-md;q=0.7,en-us;q=0.3
<316051064 ms> HTTP_COOKIE(12)=(78)AnMenu=_p00011_; LOGIN_USERNAME_COOKIE=0982404336405; ANIMAL=58AB0445E15C7111
<316051064 ms> HTTP_REFERER(13)=(182)http://192.168.0.40:7780/pls/apex/f?p=150:36:44022275107991:GETREGINFO:NO:::&success_msg=Interpelarea%20a%20fost%20efectu
<316051064 ms> HTTP_ORACLE_ECID(17)=(38)1215771800:192.168.0.40:27973:0:487,0
<316051064 ms> WEB_AUTHENT_PREFIX(19)=(1)
<316051064 ms> DAD_NAME(9)=(5)apex
<316051064 ms> DOC_ACCESS_PATH(16)=(5)docs
<316051064 ms> DOCUMENT_TABLE(15)=(23)wwv_flow_file_objects$
<316051064 ms> PATH_ALIAS(11)=(1)
<316051064 ms> REQUEST_CHARSET(16)=(9)AL32UTF8
<316051064 ms> REQUEST_IANA_CHARSET(21)=(6)UTF-8
<316051064 ms> SCRIPT_PREFIX(14)=(5)/pls
<316051064 ms>StrArrPosBind pos 2 Charset Id : 873
<316051064 ms>StrArrPosBind pos 3 Charset Id : 873
<316051064 ms>StrArrPosBind pos 9 Charset Id : 873
<316051064 ms>StrArrPosBind pos 30 Charset Id : 873
<316051074 ms>(wpd.c,2584) No data returned from procedure
<316051074 ms>(wpd.c,1958) Begin header parsing...
<316051074 ms>(wpcs.c, 76) Executed 'begin dbms_session.reset_package; end;' (rc=0)
<316051074 ms>(wpd.c,1816) Going to close cursor
<316051074 ms>DeinitCursor
<316051074 ms>(wpx.c,662) Normal completion
<316051074 ms>(wpx.c,690) Shutdown has been called
<316051074 ms>(wpx.c,702) Going to logoff
<316051074 ms>Logoff: Pooling this connection
<316051074 ms>[ReqEndtime: 11/Jul/2008:13:23:20]
<316051074 ms>[ReqExecTime: 10 ms]

*********************************************************************************
below result of Ctrl+F5
With bold font diferences between submitting of same pages with same parameters
*********************************************************************************

<316147344 ms>[ReqStartTime: 11/Jul/2008:13:24:57]
<316147344 ms>Request ID ReqID:27989_1215771897
<316147344 ms>Connecting to database with connect string : "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.42)(PORT=1521)))(CONNECT_DATA=(S
<316147344 ms>OpenCursor
<316147344 ms>(wpd.c,1761) Logged in as (unknown)
<316147344 ms>(wpx.c,595) Going to select...
<316147344 ms>(wpx.c,649) Have been asked to execute a request
<316147344 ms>(wppa.c,332) Building Arglist based on Parsed Content from WRB
<316147344 ms>(wppa.c,1012) Enter ParseUrlData
<316147344 ms>POST
<316147344 ms>(wpu.c,256) Attempting to read 980 bytes
<316147344 ms>(wpu.c,261) We read 980, had 0, to get 0 bytes
<316147344 ms>[headers begin]
<316147344 ms>HTTP_COOKIE(11): (77)AnMenu=_p00011_; LOGIN_USERNAME_COOKIE=0982404336405; ANIMAL=58AB0445E15C7111
<316147344 ms>[headers end]
<316147344 ms>p_flow_id=150&p_flow_step_id=36&p_instance=44022275107991&p_page_submission_id=5213326&p_request=SAVE&p_arg_names=209374629360468065&p_t01=01000
<316147344 ms>[form_data]
<316147344 ms>p_flow_id=150&p_flow_step_id=36&p_instance=44022275107991&p_page_submission_id=5213326&p_request=SAVE&p_arg_names=209374629360468065&p_t01=01000
<316147344 ms>(wppa.c,1506) indx = 43, entryCnt = 43
<316147344 ms>(wppa.c,1605) Array bind graduated (19=>20, 19=>32)
<316147344 ms>(wppa.c,1827) Listing distinct actual names:
<316147344 ms>(wppa.c,1829) p_flow_id
<316147344 ms>(wppa.c,1829) p_flow_step_id
<316147344 ms>(wppa.c,1829) p_instance
<316147344 ms>(wppa.c,1829) p_page_submission_id
<316147344 ms>(wppa.c,1829) p_request
<316147344 ms>(wppa.c,1829) p_arg_names
<316147344 ms>(wppa.c,1829) p_t01
<316147344 ms>(wppa.c,1829) p_t02
<316147344 ms>(wppa.c,1829) p_t03
<316147344 ms>(wppa.c,1829) p_t04
<316147344 ms>(wppa.c,1829) p_t05
<316147344 ms>(wppa.c,1829) p_t06
<316147344 ms>(wppa.c,1829) p_t07
<316147344 ms>(wppa.c,1829) p_t08
<316147344 ms>(wppa.c,1829) p_t09
<316147344 ms>(wppa.c,1829) p_t11
<316147344 ms>(wppa.c,1829) p_t12
<316147344 ms>(wppa.c,1829) p_t13
<316147344 ms>(wppa.c,1829) p_t14
<316147344 ms>(wppa.c,1829) p_t15
<316147344 ms>(wppa.c,1829) p_t16
<316147344 ms>(wppa.c,1829) p_t17
<316147344 ms>(wppa.c,1829) p_t18
<316147344 ms>(wppa.c,1829) p_t19
<316147344 ms>(wppa.c,1829) p_md5_checksum
<316147344 ms>(wppa.c,1831) Listing actuals of array with large entries:
<316147344 ms>(wppa.c,1836) Listing distinct actual names and values:
<316147344 ms>(wppa.c,1868) p_flow_id, type = 0, value (4) = 150
<316147344 ms>(wppa.c,1868) p_flow_step_id, type = 0, value (3) = 36
<316147344 ms>(wppa.c,1868) p_instance, type = 0, value (15) = 44022275107991
<316147344 ms>(wppa.c,1868) p_page_submission_id, type = 0, value (8) = 5213326
<316147344 ms>(wppa.c,1868) p_request, type = 0, value (5) = SAVE
<316147344 ms>(wppa.c,1860) p_arg_names (maxlen 19), small array, values:
<316147344 ms>(wppa.c,1863) 209374629360468065
<316147344 ms>(wppa.c,1863) 209376137305475675
<316147344 ms>(wppa.c,1863) 227475931186107912
<316147344 ms>(wppa.c,1863) 227477740265107916
<316147344 ms>(wppa.c,1863) 227477121811107915
<316147344 ms>(wppa.c,1863) 227476343883107913
<316147344 ms>(wppa.c,1863) 227476121631107913
<316147344 ms>(wppa.c,1863) 227476523459107913
<316147344 ms>(wppa.c,1863) 227476722828107914
<316147344 ms>(wppa.c,1863) 0
<316147344 ms>(wppa.c,1863) 227476945791107914
<316147344 ms>(wppa.c,1863) 227477345574107915
<316147344 ms>(wppa.c,1863) 204942321852400446
<316147344 ms>(wppa.c,1863) 204942534747400447
<316147344 ms>(wppa.c,1863) 204942730225400447
<316147344 ms>(wppa.c,1863) 204942923751400447
<316147344 ms>(wppa.c,1863) 204943114092400447
<316147344 ms>(wppa.c,1863) 204943330624400447
<316147344 ms>(wppa.c,1863) 204943529770400447
<316147344 ms>(wppa.c,1868) p_t01, type = 0, value (7) = 010001
<316147344 ms>(wppa.c,1868) p_t02, type = 0, value (14) = Pleşca Maria
<316147344 ms>(wppa.c,1868) p_t03, type = 0, value (14) = 0982810492504
<316147344 ms>(wppa.c,1868) p_t04, type = 0, value (3) = 46
<316147344 ms>(wppa.c,1868) p_t05, type = 0, value (14) = 0982810492504
<316147344 ms>(wppa.c,1868) p_t06, type = 0, value (7) = Jalbă
<316147344 ms>(wppa.c,1868) p_t07, type = 0, value (7) = Vasile
<316147344 ms>(wppa.c,1868) p_t08, type = 0, value (3) = 21
<316147344 ms>(wppa.c,1868) p_t09, type = 0, value (4) = 234
<316147344 ms>(wppa.c,1868) p_t11, type = 0, value (21) = Sector Mănăstirea
<316147344 ms>(wppa.c,1868) p_t12, type = 0, value (9) = D_EVENTS
<316147344 ms>(wppa.c,1868) p_t13, type = 0, value (14) = 0982810492504
<316147344 ms>(wppa.c,1868) p_t14, type = 0, value (7) = Jalbă
<316147344 ms>(wppa.c,1868) p_t15, type = 0, value (7) = Vasile
<316147344 ms>(wppa.c,1868) p_t16, type = 0, value (9) = Ialoveni
<316147344 ms>(wppa.c,1868) p_t17, type = 0, value (8) = Răzeni
<316147344 ms>(wppa.c,1868) p_t18, type = 0, value (8) = < - - -
<316147344 ms>(wppa.c,1868) p_t19, type = 0, value (1) =
<316147344 ms>(wppa.c,1868) p_md5_checksum, type = 0, value (1) =
<316147344 ms>(wppa.c,427) Arglist built, 25 unique entries
<316147344 ms>(wpx.c,656) Going to wpprodb_OciDoBlock...
<316147344 ms>(wpd.c,2746) Cache enabled. Gathering cache information.
<316147344 ms>(wpd.c,2764) Language for this request is ru-md,ro-md;q=0.7,en-us;q=0.3
<316147344 ms>(wpd.c,2815) Using user APEX_PUBLIC_USER for caching.
<316147344 ms>cache: Checking for user level hit
<316147344 ms>cache: Cache MISS user - /opt/oracle/apexhome/Apache/modplsql/cache/plsql/234/6395
<316147344 ms>cache: Checking for system level hit
<316147344 ms>cache: Cache MISS system - /opt/oracle/apexhome/Apache/modplsql/cache/plsql/sys/754/1393
<316147344 ms>(wppr.c,459) start working with wwv_flow.accept
<316147344 ms>(wppr.c,1163) The CALL block: len=1381, bind_count=33
declare
rc__ number;
start_time__ binary_integer;
simple_list__ owa_util.vc_arr;
complex_list__ owa_util.vc_arr;
begin
start_time__ := dbms_utility.get_time;
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 ((owa_match.match_pattern('wwv_flow.accept', simple_list__, complex_list__, true))) then
rc__ := 2;
else
null;
null;
wwv_flow.accept(p_flow_id=>:p_flow_id,p_flow_step_id=>:p_flow_step_id,p_instance=>:p_instance,p_page_submission_id=>:p_page_submission_id,p_request=>:p_requ
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__;
:db_proc_time__ := dbms_utility.get_time - start_time__;
end;
<316147344 ms>(wppr.c,519) Pl/sql block parsed...
<316147344 ms>(wpdenv.c,1526) CGI Environment has 31 vars. Max name len 128, Max Value Len 512
<316147344 ms> PLSQL_GATEWAY(14)=(6)WebDb
<316147344 ms> GATEWAY_IVERSION(17)=(2)3
<316147344 ms> SERVER_SOFTWARE(16)=(60)Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server
<316147344 ms> GATEWAY_INTERFACE(18)=(8)CGI/1.1
<316147344 ms> SERVER_PORT(12)=(5)7780
<316147344 ms> SERVER_NAME(12)=(8)apptest
<316147344 ms> REQUEST_METHOD(15)=(5)POST
<316147344 ms> PATH_INFO(10)=(17)/wwv_flow.accept
<316147344 ms> SCRIPT_NAME(12)=(10)/pls/apex
<316147344 ms> REMOTE_ADDR(12)=(12)192.168.0.3
<316147344 ms> SERVER_PROTOCOL(16)=(9)HTTP/1.1
<316147344 ms> REQUEST_PROTOCOL(17)=(5)HTTP
<316147344 ms> REMOTE_USER(12)=(17)APEX_PUBLIC_USER
<316147344 ms> HTTP_CONTENT_LENGTH(20)=(4)980
<316147344 ms> HTTP_CONTENT_TYPE(18)=(34)application/x-www-form-urlencoded
<316147344 ms> HTTP_USER_AGENT(16)=(99)Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30)
<316147344 ms> HTTP_HOST(10)=(18)192.168.0.40:7780
<316147344 ms> HTTP_ACCEPT(12)=(4)*/*
<316147344 ms> HTTP_ACCEPT_ENCODING(21)=(14)gzip, deflate
<316147344 ms> HTTP_ACCEPT_LANGUAGE(21)=(30)ru-md,ro-md;q=0.7,en-us;q=0.3
<316147344 ms> HTTP_COOKIE(12)=(78)AnMenu=_p00011_; LOGIN_USERNAME_COOKIE=0982404336405; ANIMAL=58AB0445E15C7111
<316147344 ms> HTTP_REFERER(13)=(182)http://192.168.0.40:7780/pls/apex/f?p=150:36:44022275107991:GETREGINFO:NO:::&success_msg=Interpelarea%20a%20fost%20efectu
<316147344 ms> HTTP_ORACLE_ECID(17)=(38)1215771897:192.168.0.40:27989:0:416,0
<316147344 ms> WEB_AUTHENT_PREFIX(19)=(1)
<316147344 ms> DAD_NAME(9)=(5)apex
<316147344 ms> DOC_ACCESS_PATH(16)=(5)docs
<316147344 ms> DOCUMENT_TABLE(15)=(23)wwv_flow_file_objects$
<316147344 ms> PATH_ALIAS(11)=(1)
<316147344 ms> REQUEST_CHARSET(16)=(9)AL32UTF8
<316147344 ms> REQUEST_IANA_CHARSET(21)=(6)UTF-8
<316147344 ms> SCRIPT_PREFIX(14)=(5)/pls
<316147344 ms>StrArrPosBind pos 2 Charset Id : 873
<316147344 ms>StrArrPosBind pos 3 Charset Id : 873
<316147344 ms>StrArrPosBind pos 9 Charset Id : 873
<316147344 ms>StrArrPosBind pos 30 Charset Id : 873
<316147414 ms>(wpd.c,1958) Begin header parsing...
<316147414 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<316147414 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<316147414 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<316147414 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<316147414 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<316147414 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<316147414 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<316147414 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<316147414 ms>(wpd.c,1996) Concatenated line (63 bytes): Location: f?p=150:46:44022275107991::NO:36::&success_msg=Datele
<316147414 ms>(wpd.c,2007) Got a line (174 bytes): Location: f?p=150:46:44022275107991::NO:36::&success_msg=Datele%20sunt%20salvate%2F270F569388A882C6675810F0
<316147414 ms>(wpd.c,2129) Parsed header - Location:f?p=150:46:44022275107991::NO:36::&success_msg=Datele%20sunt%20salvate%2F270F569388A882C6675810F0BD91AB61%
<316147414 ms>(wpd.c,2007) Got a line (39 bytes): Content-length: 162
<316147414 ms>(wpd.c,2080) Parsed header - Content-Length:162
<316147414 ms>(wpd.c,2007) Got a line (1 bytes):
<316147414 ms>(wpd.c,2014) End of headers detected
<316147414 ms>(wpcs.c, 76) Executed 'begin dbms_session.reset_package; end;' (rc=0)
<316147414 ms>(wpd.c,1816) Going to close cursor
<316147414 ms>DeinitCursor
<316147414 ms>(wpx.c,662) Normal completion
<316147414 ms>(wpx.c,690) Shutdown has been called
<316147414 ms>(wpx.c,702) Going to logoff
<316147414 ms>Logoff: Pooling this connection
<316147414 ms>[ReqEndtime: 11/Jul/2008:13:24:57]
<316147414 ms>[ReqExecTime: 70 ms]