Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What kinds of logging facilities are available in mod_plsql?

April 26, 2017facilities logging mod_plsql

0

Posted

What kinds of logging facilities are available in mod_plsql?

1 Answer

0

Posted

By default, mod_plsql logs alerts/warnings/errors to the OHS error_log file ORACLE_HOME/Apache/Apache/logs/error_log. The amount of information logged by mod_plsql is controlled by the setting of OHS’ LogLevel parameter in httpd.conf. By default, this is configured to warn. You can also enable performance logging for mod_plsql on a per-request basis as follows: Edit ORACLE_HOME/Apache/Apache/conf/httpd.conf and set LogLevel to info (default is warn). Restart OHS using the following command: ORACLE_HOME/opmn/bin/opmnctl restartproc type=ohs Issue some URLs to mod_plsql and verify that the file ORACLE_HOME/Apache/Apache/logs/error_log starts showing entries as follows: [Tue Apr 01 14:54:49 2003] [info] mod_plsql: [perf] 130.35.92.145 /pls/app/htp.p status=200 user=scott reqTime=21ms connSU=(null),0ms connRO=(null),0ms connNSSO=HIT,1ms procTime=17ms sessionTidyTime=0ms cache=(null) cookie=(null),0ms pageCalls=0,0ms bytes=5 describe=No,0ms streamTime=0ms pid=175 sessFile=(null) userFile=83