ORACLE SQL Tracking

Results 1 to 2 of 2

Thread: ORACLE SQL Tracking

  1. #1
    Join Date
    Dec 1969
    Posts
    915

    Default ORACLE SQL Tracking

    I was wondering if anyone has a way to track what SQL statements are sent to an ORACLE database. To assist in determining what indexes would benefit the end users, and so forth.<BR><BR>Any discussion would be appreciated.

  2. #2
    Darcy Guest

    Default RE: ORACLE SQL Tracking

    Some ideas are:<BR><BR>=&#062; ODBC trace. Turn on the IIS Server ODBC trace to trace ASP ADO sql statements. Watch it generates large files. <BR>=&#062; Oracle Trace. Turn on Oracle server for session in question. (Alter session set sql_trace = true). This can be difficult if not using persistent ASP connections. You could turn on for the entire Oracle instance if the situation permits. Follow the Oracle instructions for your Oracle environment for using tkprof to interpret trace files.<BR>=&#062; Oracle V$ tables will allow you to examine which Oracle SQL statements are using the most resources, and taking the longest to execute. <BR>=&#062; Some network sniffers understand the sqlnet protocol and display the sqlnet commands. You may have one in your shop. <BR><BR>Good Luck.

Posting Permissions

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