Thread: SQL tuning

    #1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Location
    Pune
    Posts
    9
    Rep Power
    0

    Question SQL tuning


    hi,
    i am into query tuning in oracle (9.2)
    so execution time for a query is very critical to my experiments
    unfortunately (for my purpose ofcourse) oracle caches the tables and intermediate results and therefore a query taking minutes runs in milliseconds.

    any way i could flush this case.
    restarting should be the last answer

    -- Nilesh
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Location
    Canada
    Posts
    1
    Rep Power
    0
    As far as I know ( I might be wrong) that Oracle instance only catches the query (without re-parsing it) when the syntax is exactly the same. For example, the same query written in upper case and lower case are considered as 2 different queries. I am not sure about the flushing tables part.

    Good luck!

    Vivi

IMN logo majestic logo threadwatch logo seochat tools logo