tracing events
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: tracing events

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    hi,

    I want to trace the requests ie stored procedure calls from other sources like from vb or java etc.. to ORacle.
    Is there any utility just like sql profiler in SQL2000.


    Then another one,
    i am using oracle8.1.7.
    diagnostic pack is not available.I tried to install it, but it is not found in the OEM.

    what shall i do for oracle trace manager?



  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Just execute 'alter session set sql trace=true;'
    for the user calling this procedure.

    once u finished tracing stop the trace.


    regards
    anandkl

    [Edited by anandkl on 05-16-2002 at 09:46 AM]
    anandkl

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dbms_profiler

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width