altersystemflush “oracle cache”

alter system flush “oracle cache” the The following three statements are designed to refresh the oracle cache. Here is a summary. the 1) alter system flush global context   The illustration below: www.2cto.com   For a multi-tier architecture, as shown in the figure above: the application server and the data block server communicate through the connection pool, and the information about the connection pool is kept in the SGA. This statement clears the connection information. the 2) alter system flush shared_pool Will clear all the SQL execution plans previously saved in the library cache and data dictionary cache, but will not clear the recently executed entries cached in the shared sql area or the shared pl/sql area. Refreshing the shared pool can help merge small chunks, release a few shared pool resources, and temporarily solve the fragmentation problem in shared_pool. However, this practice is generally not recommended. The reasons are as follows: Flush Shared Pool will cause the currently unused cursor to be cleared out of the shared pool. If these SQLs need to be executed later, the database will undergo a lot of hard parsing, the system will experience severe CPU contention, and the database will generate intense Latch…