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

    Question Unanswered: reset the data cache

    Hi,
    In order to tune the same query multiple times and to compare the elapsed time, I wonder how I can reset or disable the Oracle caching mechanism of the data retrieved by the query to tune.

    thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Netherlands
    Posts
    118

    not possible

    Unfortunately this is NOT possible...

    You'll have to re-create the instance.

    remi
    http://askremi.ora-0000.com
    Remi Visser

    Oracle Database Administrator
    (OCP certified 8i)

    Homepage: http://home.remidian.com/

Posting Permissions

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