This discussion is archived
5 Replies Latest reply: Oct 20, 2010 11:03 AM by jariola RSS

p_trace=YES not working in XE

Martin Giffy D'Souza Oracle ACE Director
Currently Being Moderated
Hi,

I'm trying to do a trace on a report. When I append &p_trace=YES to my URL there's no trace file generated in the udump directory. Does anyone know why this wouldn't work? Here's some information about the database and OS:

Ex URL: http://fcapex40.clarifit.com:8080/apex/f?p=101:4:4002989996060036::NO&p_trace=YES
SQL> SHOW PARAMETERS user_dump_dest

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
user_dump_dest                       string      /usr/lib/oracle/xe/app/oracle/admin/XE/udump
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product
Fedora release 12 - 2.6.31.5-127.fc12.i686.PAE


Martin
-----
http://www.talkapex.com

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points