ALTER SYSTEM flush global context;
534454Nov 6 2009 — edited Nov 9 2009Hi guys,
does anyone know what this command does? I am not able to find anything googling. I know i can do the flush of shared_pool and buffer_cache but wondering what the flushing of "global context" does to my sga.
SQL> alter system flush
2 ;
alter system flush
*
ERROR at line 1:
ORA-02000: missing SHARED_POOL/BUFFER_CACHE/GLOBAL CONTEXT keyword
SQL> ALTER SYSTEM flush global;
ALTER SYSTEM flush global
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [15402], [], [], [], [], [], [], []
SQL> ALTER SYSTEM flush global context;
System altered.
--MM