home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,272 of 2,288   
   Terry Coccoli to All   
   Running Oracle Trace   
   12 Apr 04 17:49:50   
   
   From: request@ifneeded.com   
      
   After opening up a ticket with a 3rd party vendor to find out what SQL   
   they use behind the scenes, they advised and gave me instructions on   
   running an Oracle trace.   
      
   Basically, they told me to set TRACE_LEVEL_CLIENT to USER and to set the   
   TRACE_DIRECTORY_CLIENT and TRACE_FILE_CLIENT parameters.  I did, and the   
   trace file gets generated, but I don't see any actual SQL calls.   
      
   Am I missing anything else?  Also, is there a good reference for running   
     Oracle traces?   
      
   Thanks.   
      
      
   P.S. I reran the trace setting the TRACE_LEVEL_CLIENT to ADMIN, and that   
   generated more data, but no visible SQL.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca