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

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:

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 - Product
Fedora release 12 -



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