Announcement

Collapse
No announcement yet.

Database Spylog for veiwing DB calls

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database Spylog for veiwing DB calls

    Hi,
    Is there any spylog available to veiw the DB calls for OTM
    My system Config
    O/S : Windows 2003 64 bit
    App server: OAS

    I have tried using P6SpyLog by changing the data-sources.xml but it is replaced when ever i restart the Application and neither it is getting recorded.

    Regards
    bscyadav
    B.S.Chakravarthy Yadav
    Product Design Head

  • #2
    Re: Database Spylog for veiwing DB calls

    OTM has a sql logging function. Not sure how to turn it on but you can set it up so that it logs all of it's db calls.

    Alternatively you could ask your DBA top set up sql trace and go through the trace files to work out what's going on.

    Comment


    • #3
      Re: Database Spylog for veiwing DB calls

      Just keep in mind that the SQL logging is VERY performance intensive, so only enable it in non-PROD environments -- or only for a limited time in PROD.

      --Chris

      Comment


      • #4
        Re: Database Spylog for veiwing DB calls

        Hi
        I am using SQL Trace but want to avoid it as we another App servers connected to the same DB and is mixing all quires

        How do i activiate or use the SQL Logging Function in OTM
        B.S.Chakravarthy Yadav
        Product Design Head

        Comment


        • #5
          Re: Database Spylog for veiwing DB calls

          These are turned on via the standard OTM logging screens.

          Depending on your version of OTM:

          Configuration and Administration > Power Data > General > Log Files

          Choose the appropriate log file and then ensure you have turned on "Sql".

          Click Finished to save the changes.

          As a reminder, the performance impact of SQL logging is very high.

          --Chris

          Comment


          • #6
            Re: Database Spylog for veiwing DB calls

            BTW - full details on how to enable and disable logging options is available via the Metalink Note # 562686.1.

            --Chris

            Comment

            Working...
            X