From: anacedent@hotmail.com   
      
   Terry Coccoli wrote:   
   > 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.   
   >   
      
   All you have done so far is trace traffic between the client & the DB   
   server.   
      
   To actually see SQL go research how to set event 10046 on a "remote"   
   session.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)