Performance And Tunning
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Performance And Tunning

  1. #1
    Join Date
    Mar 2004
    Location
    INDIA
    Posts
    25

    Performance And Tunning

    Hey,

    Could some one give me the idea that how to enable SQL trace implicitly for a particular program (EXCEL), whenever it connect to database.
    I needed to enable the SQL TRACING only for that session which is running that program (Excel).

    Your ideas will be appreciated.

    Sh*****

  2. #2
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    You can write system level triggers for that program and then get the sid and use it to enable the trace. dbms_system is the package to enale trace for another session. Youn can get further into this..
    -nagarjuna

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    "Performance And Tunning"?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    cant even write a proper thead title? geeeez

  5. #5
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    goddam

    HI slindev.

    coudl you plz give me link for goddam
    J Gangadhar

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    surely you are joking

  7. #7
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Can't this be done through the odbc level?
    I'm stmontgo and I approve of this message

  8. #8
    Join Date
    Mar 2004
    Location
    INDIA
    Posts
    25

    Performance And tunning

    Thanks for reply.

    I like to ask you, should we enable SQL TRACING inside the EXCEL
    Program or
    IS there another approach that SQL Tracing Enable
    automatically for that session whenever it runs EXCEL.




    Your ideas will be appreciated.

    CHUCK

  9. #9
    Join Date
    Feb 2000
    Location
    Brisbane, Australia
    Posts
    46
    We should have a poll to vote for the most obnoxious correspondant, pando or slim "no OCP, no Oracle Masters, no nothing, just so far up myself you can't see me" dave.

  10. #10
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by millerg
    We should have a poll to vote for the most obnoxious correspondant, pando or slim "no OCP, no Oracle Masters, no nothing, just so far up myself you can't see me" dave.
    In that case, my vote goes to Pando.

    And it's "correspondent" -- my mission is to educate!
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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