Flushing Oracle buffers    April 10, 2007

Flushing Shared Pool command is something that i have known for quite sometime

CONN sys/password AS SYSDBA

SQL>ALTER SYSTEM FLUSH SHARED_POOL;

However, flushing the data buffer is knew to me

CONN sys/password AS SYSDBA
SQL>ALTER SYSTEM FLUSH BUFFER_CACHE;

Flushing the buffer cache will  make sure that the buffered data in written to disk.

Ammar Sajdi