1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How To Flush The Cache When I Use SQL Developer (sqldeveloper.exe)

Discussion in 'SQL PL/SQL' started by Farshad Javadi, Sep 28, 2011.

  1. Farshad Javadi

    Farshad Javadi Active Member

    Messages:
    20
    Likes Received:
    0
    Trophy Points:
    80
    Hello And Greetings,

    I am not a DBA. I use sqldeveloper.exe to write queries for my report. I need to know how efficient my queries are.
    Therefore I need to know how to flush the Cache memory in order to see the real time spent by my query without using the Cache memory.


    Thanks,
    Farshad Javadi
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Without SYSDBA privilege you can't. You'll need your DBA to do that for you.
     
  3. rajavu

    rajavu Forum Guru

    Messages:
    815
    Likes Received:
    52
    Trophy Points:
    610
    Location:
    @ Bangalore , India
    Refer this link
     
  4. alter system flush buffer_cache;
    alter system flush shared_pool;


    But for using these two queries you must have all privileges