SQL> alter system flush buffer_cache;
System altered.
Flush shared pool to clear recently created SQL parse and execution plan
SQL> alter system flush shared_pool;
System altered.
What is the Difference between “clear buffer” and “alter system flush buffer_cache”
Clear Buffer SQL* Plus Command which is use to clear the SQL*Plus screen and the screen buffer.
Syntax:
CLEAR {BREAKS|BUFFER|COLUMNS|COMPUTES|SCREEN|SQL TIMING}
SQL> clear buffer
buffer cleared
Example:
SQL> Select empno, ename from Scott.emp Where ename='KING';
EMPNO ENAME
---------- ----------
7839 KING
SQL> list;
1* Select empno, ename from Scott.emp Where ename='KING'
SQL> clear buffer;
buffer cleared
SQL> list
SP2-0223: No lines in SQL buffer.
But alter system flush buffer_cache use to clear data buffer cash in SGA.
