Warning: include(/homepages/10/d653673895/htdocs/clickandbuilds/Tutarticle/wp-includes/wp-session-manager.php): failed to open stream: Permission denied in /homepages/10/d653673895/htdocs/clickandbuilds/Tutarticle/wp-load.php on line 1

Warning: include(): Failed opening 'wp-includes/wp-session-manager.php' for inclusion (include_path='.:/usr/lib/php7.0') in /homepages/10/d653673895/htdocs/clickandbuilds/Tutarticle/wp-load.php on line 1
Buffer | Tutarticle

SGA: System Global Area in Oracle

oracle-12c

System Global Area The System Global Area (SGA) is typically a very large memory area shared by all Oracle processes. It is divided into distinct areas such as the buffer cache, the shared pool, and the log buffer, whose sizes are specified in the database configuration file (pfile or spfile). The various Oracle processes coordinate their access to these areas by using an interprocess communication (IPC) mechanisms called latches. Buffer Cache Typically, the buffer cache is the largest portion of

Continue Reading

Site Footer