You must first activate the log option with a PL/SQL command. Make sure you are logged in as a SYSTEM user prior to running the below command:
SQL> execute dbms_epg.set_global_attribute('log-level', 3)Where different log-levels are:
0 - LOG_EMERG (Default Log-Level)
1 - LOG_ALERT
2 - LOG_CRIT
3 - LOG_ERR
4 - LOG_WARNING
5 - LOG_NOTICE
6 - LOG_INFO
7 - LOG_DEBUG
This should generate a .trc file on the server file system in bdump directory. To get this location, use classic checking of parameter:
SQL> show parameter background_dump_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ background_dump_dest string c:\oracle\product\10.2.0\dbhome_1\admin\XE\bdumpNote that there will be many .trc and .trm files in this directory from different DB functions. The files of interest are the .trc files that are generated at the time of the APEX event of interest. To further identify the specific .trc file(s) containing the desired information, accomplish a unix grep or windows find for the word "APEX" in the file:
- UNIX
grep APEX
.trc - Windows
type
.trc|find "APEX"
The End
This is nothing but making one official reminder for future reference...Hope this helps someone.
Cheers!