Shared Pool flush
For Oracle 9i and 10g (Need to test it on 11g)
Alter system flush shared_pool
Buffer Cache flush
For Oracle 9i
Alter session set events = 'immediate trace name flush_cache';
Here I found the statement and tried it on my test database and it worked fine.
For Oracle 10g, the syntax is is as follows:
alter system flush buffer_cache;
I would like to thanks you all for reading and posting comments to my post.
No comments:
Post a Comment