Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    4

    Red face Unanswered: Finding long running queries

    Hi, I'm running oracle database 9.1.0.4 on SUN, and AS9i based application
    which becomes slower every day, as data volume becomes larger
    So, my question is: how can I find long running queries (e.g. full table
    scans) in order to improve application performance?
    Thanks in advance

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    I don't know if this is below your experience of tuning, but you could try my 'introduction to Oracle SQL statement tuning'.

    http://www.billmagee.co.uk/oracle/sqltune/index.html

    There are some suggestions from various people waiting to be included in the document, but hopefully it will help.

    HTH
    Bill

Posting Permissions

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