Friday, January 2, 2009

Flushing Shared Pool and Buffer Cache

Flushing SGA memory areas, Shared Pool and Buffer Cache are the uncommon task that comes to a DBA. Yesterday night when I was going through Oracle Documentation I found the command for Flushing the shared pool. And on the next moment I thought for Buffer cache.

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