Using database memory efficiently is one of the "cheapest" methods of tuning databases. What is cheaper than using the available resources correctly? Oracle is banking on the in-memory trend and has always offered special techniques and technologies to store data efficiently in memory. Effective storage in the database cache is a top priority, so that "hot data", for example, can be accessed quickly.
In order to better support certain areas and applications when storing data in the cache, additional techniques have been implemented in recent years. For example, results from statement executions or PL/SQL functions can use the cache just as efficiently as tables bolivia telegram screening that are queried using "Full Table Scan" operations. Another interesting new feature has been added, particularly with the Oracle Database In-Memory technology, which can be particularly beneficial for analytical queries. It is not only characterized by a new form of cache, but also benefits from specially optimized statement access.
Since the description of all techniques would go beyond the scope of this article, selected specific techniques and their application cases are described in the following sections.