Tuesday, 8 October 2013

How to clear /flush buffer_cache;



SQL> clear buffer;
buffer cleared

SQL> alter system flush buffer_cache;

System altered.


SQL> alter system flush shared_pool;

System altered.



SQL> purge dba_recyclebin;

DBA Recyclebin purged.

No comments:

Post a Comment