Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Result Cache In Sga -Oracle Architecture

 When a query is executed for the very first time, the user’s process searches for the data in the database buffer cache. If data is there, it uses it. otherwise, it performs an I/O operation to retrieve data from the datafile on disk into the buffer cache, and from this data, the final result set is displayed.
 if another query requires the same data set, the process uses the data from the buffer cache to build the result set required by the user. only if it is present in buffer cache.
The Result Cache is an area in the shared pool and contains the end results of a query execution.
The Result Cache can be managed either on the client side or the server side.

Client side
 Result Cache implementation would require the application to use the Oracle Call Interface (OCI) calls.
 Server side 
 The query could be executed with a /*+ RESULT CACHE */ hint (or) the result_cache_mode parameter could be set to AUTO.
 If result_cache_mode parameter is set AUTO, It moves all query results to the Result Cache section of the shared pool.

 Cannot cache the result of:
When a query is executed for the very first time.
 when the cache is flushed.


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

Postgres Database Patch

PostgreSQL Database startup / shutdown /restart

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

PostgreSQL Pgbadger Installation On Linux