{"id":857,"date":"2018-07-21T16:59:31","date_gmt":"2018-07-21T16:59:31","guid":{"rendered":"http:\/\/dbtut.com\/?p=857"},"modified":"2019-12-31T13:03:18","modified_gmt":"2019-12-31T13:03:18","slug":"oracle-memory-components-sga-and-pga","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/","title":{"rendered":"Oracle Memory Components(SGA and PGA)"},"content":{"rendered":"<p><span style=\"font-size: 1.125rem; font-family: var(--text-font);\">Oracle stores the following components in Memory.<\/span><\/p>\n<ul>\n<li>Program Code<\/li>\n<li>Connected sessions even if not active<\/li>\n<li>Information required during Query Execution. For example, if the query fetches which rows<\/li>\n<li>Information shared and communicated between Oracle processes. For example, lock information<\/li>\n<li>Data blocks and redo log records are kept in memory for caching purposes.<\/li>\n<\/ul>\n<p>We can examine Memory in two main chapters. First you should look at the below screenshot to understand memory components.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-14529 aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-3.png\" alt=\"\" width=\"576\" height=\"457\" \/><\/p>\n<h2>SGA(System Global Area):<\/h2>\n<p>It is a memory area shared by all server and background processes.<\/p>\n<p>It is also known as the &#8220;Shared Global Area&#8221;.<\/p>\n<p>The SGA consists of the following components.<\/p>\n<ul>\n<li><strong>Database buffer cache<\/strong><\/li>\n<li><strong>Redo log buffer<\/strong><\/li>\n<li><strong>Shared pool<\/strong><\/li>\n<li><strong>Java pool<\/strong><\/li>\n<li><strong>Large pool (optional)<\/strong><\/li>\n<li><strong>Streams pool<\/strong><\/li>\n<\/ul>\n<h3>Automatic Shared Memory Management<\/h3>\n<p>All SGA components allocote and deallocate areas in units of granules.<\/p>\n<p>In many SGAs smaller than 1 GB, the granule size is 4 MB. In large SGAs the granule size is 16 MB.<\/p>\n<h4>What is SGA_TARGET?<\/h4>\n<p>If you do not set the SGA_TARGET initialization parameter, you must set the above components one by one.<\/p>\n<p>If you set the SGA_TARGET parameter, you do not need to set these components.<\/p>\n<p>Oracle shares the SGA_TARGET value you set with these components.<\/p>\n<p>This process is called <strong>Automatic Shared Memory Management<\/strong>.<\/p>\n<h4>What is SGA_MAX_SIZE?<\/h4>\n<p>There is a SGA_MAX_SIZE parameter. This parameter specifies the maximum memory that the SGA can reach.<\/p>\n<p>When you change this parameter, you need to restart the instances used by the database.<\/p>\n<p>You can increase SGA_TARGET to SGA_MAX_SIZE without performing any restart operation.<\/p>\n<p>After setting SGA_TARGET, oracle analyze the system workload and distribute memory among the above sga components.\u00a0If you set SGA_TARGET in the sp_file, memory distribution is automatically performed according to the last known memory distribution in case of instance restart. Thus, unnecessary workload on the system is not re-analyzed.<\/p>\n<p>If you set SGA_TARGET, the <strong>keep buffer pool<\/strong> (to keep the data blocks of the specified schema in memory) and the <strong>recycle buffer pool<\/strong> (to remove unnecessary data blocks from memory) are not automatically set.<\/p>\n<p>You can make the configurations using the parameters DB_KEEP_CACHE_SIZE and DB_RECYCLE_CACHE_SIZE.<\/p>\n<h3>Automatic Memory Management<\/h3>\n<p>If you set MEMORY_TARGET, the SGA and PGA are automatically set by oracle. This process is called Automatic Memory Management.<\/p>\n<h3>Manual Memory Management<\/h3>\n<p>If you manually set all components, this process is called Manual Memory Management.<\/p>\n<p>With the V$BUFFER_POOL view you can check the size of the cache.<\/p>\n<p>With the V$SGASTAT view, you can get information about SGA components.<\/p>\n<h3>SGA Components<\/h3>\n<p>Let&#8217;s examine the SGA components one by one.<\/p>\n<h3>Database Buffer Cache<\/h3>\n<p>It is a part of the SGA that stores the data blocks read from the data files.<\/p>\n<p>First, let&#8217;s examine the following two concepts for database buffer cache.<\/p>\n<h5><strong>Write List<\/strong><\/h5>\n<p>The Write List contains data that has changed since it was received in memory but has not been written to the disk.<\/p>\n<h5><strong>LRU(Least Recently Used) List<\/strong><\/h5>\n<p>Free buffers, pinned buffers, and dirty buffers that have not been transferred to the write list are kept in the LRU List.<\/p>\n<p>Free Buffer is a ready-to-use buffer.<\/p>\n<p>A pinned buffer is a buffer that is accessed by some processes at that time.<\/p>\n<h5>What is the role of the database buffer cache?<\/h5>\n<p>When an Oracle process needs a dataset, it first looks in the database buffer cache.<\/p>\n<p>If it does not find it here, than it fetches the data from the disk to the buffer cache and reads it from database buffer cache.<\/p>\n<p>When data is transferred to the database buffer cache, it is first checked whether there is a free buffer in memory.<\/p>\n<p>When\u00a0 searching for a free buffer, if there is a dirty buffer in the LRU List, this dirty buffer will be transferred to the Write List.<\/p>\n<p>There is a limit to the search data in the buffer cache.<\/p>\n<p>If the free buffer is not found until this limit is reached, the search is terminated and the DBWn background process is signaled to write the dirty pages to the disk.<\/p>\n<p>When free buffer is found, the data is transferred to MRU(Most Recently Used) at the end of the LRU List.<\/p>\n<p><strong>In Full Table Scan<\/strong>, the data is passed to the PGA by bypassing the SGA.<\/p>\n<p>In some cases, if you want data that causes a full table scan to be transferred to the database buffer cache, you can provide it with the following script.<\/p>\n<p>But when you run this script, getting large table scans into the database buffer cache can cause other queries to not be found in the cache and cause performance problems.<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE ... CACHE<\/pre>\n<p>If you want to keep the table in keep pool in memory, you can use the following script.<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE ... STORAGE BUFFER_POOL KEEP<\/pre>\n<p>If you want to keep the database in the buffer cache completely, you can use the following script.<\/p>\n<p>But your buffer cache size must be larger than your database size.<\/p>\n<pre class=\"lang:default decode:true\">ALTER DATABASE ... FORCE FULL DATABASE CACHING<\/pre>\n<h3>Redo Log Buffer<\/h3>\n<p>This is the memory area which the queries are stored in the memory before being written to the redo log.<\/p>\n<p>For redo log buffers, usually small values \u200b\u200bare set.<\/p>\n<p>It is almost real-time to write the redo logs from the redo log buffer.<\/p>\n<p>When a commit operation is performed, the data in the redo log buffer is written to the redo log in real time.<\/p>\n<p>If the space in the redo log buffer is large, the amount of space required to write to the disk will increase when commit is performed.<\/p>\n<p>Therefore, setting the redo log buffer to large can cause performance problems.<\/p>\n<p>The <strong>LGWR<\/strong>(Log Writer Background Process) process writes the data in the Redo Log Buffer to the redo log.<\/p>\n<p>If the speed of the LGWR does not reach the density of the records written to the redo log buffer, the solution is RAC technology.<\/p>\n<p>In RAC technology, each instance has its own LGWR, so this problem can be solved.<\/p>\n<p>The Redo Log Buffer Cache is set to the beginning of the instance and can not be changed without restarting the instance. If you want to learn more about oracle background processes, you may want to read the article named &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/25\/oracle-background-processes\/\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Background Processes<\/a>&#8221;<\/p>\n<h3>Shared Pool<\/h3>\n<p>Shared Pool is the most complex part of SGA. It consists of many sub-structures. I will explain some of these.<\/p>\n<h4><strong>The library cache<\/strong><\/h4>\n<p>Records of parsed queries are stored in the library cache.<\/p>\n<p>Thus, when a query is run again, it does not have to be parse again.<\/p>\n<p>The performance gain is obtained because the parse operation is not repeated.<\/p>\n<h5>Parsing in Oracle<\/h5>\n<p>The processes of the parse process are as follows;<\/p>\n<ul>\n<li>Is there a table specified in the query?<\/li>\n<li>what columns are in the table if there is a &#8220;* FROM&#8221; expression in the query<\/li>\n<li>Does the user have the necessary permission?<\/li>\n<li>Should it use an index?<\/li>\n<\/ul>\n<p>Once the parse operation is done, the query can be executed.<\/p>\n<h4><strong>The data dictionary cache<\/strong><\/h4>\n<p>Sometimes referred to as row cache.<\/p>\n<p>The definitions of the last used objects (table, index, user, etc.) are stored.<\/p>\n<p>These definitions can be read from memory by all sessions.<\/p>\n<p>Thus, each session does not need to go to the data dictionary on disk to read these definitions.<\/p>\n<p>Thus, the performance of the parsing process also increases.<\/p>\n<h4><strong>The PL\/SQL area<\/strong><\/h4>\n<p>It is the memory area where &#8220;Stored PL\/SQL objects&#8221; (procedures, functions, packaged procedures, packaged functions, object type definitions, and triggers) are stored.<\/p>\n<p>Normally &#8220;stored PL\/SQL objects&#8221; are stored in the data dictionary.<\/p>\n<p>By storing these objects in the PL\/SQL Area which is the part of the Shared Pool, you do not need to access these source codes every time from the data dictionary.<\/p>\n<p>&#8220;Anonymous PL\/SQLs&#8221; are not stored in the PL\/SQL area of \u200b\u200bthe shared pool.<\/p>\n<p>Therefore, application developers should be encouraged to use Stored PL\/SQL instead of Anonymous PL\/SQL.<\/p>\n<h4>The SQL query and PL\/SQL function result caches<\/h4>\n<p>The results of some SQL queries are stored in this area.<\/p>\n<p>If the same query is called again, the cached value is returned.<\/p>\n<p>Likewise, when a function is executed, the result of the function is stored here.<\/p>\n<p>If the function is executed in the same way as the same parameter, the result stored in this area is returned.<\/p>\n<h3>Large Pool<\/h3>\n<p>An optional area in Memory.<\/p>\n<p>Used for many operations (Shared Server Processes, Parallel Execution Server, Backup operations).<\/p>\n<p>If you are using Shared Server and Parallel Execution Server, you should set up a large pool.<\/p>\n<p>If not set, the shared pool is used, which can cause problems in the Shared Pool.<\/p>\n<p>If a query that needs space in the Large Pool does not find the space it needs, it will fail.<\/p>\n<p>If the large pool does not have the space needed for the query, it will not go to the shared pool.<\/p>\n<p>If you give more memory to large pool, performance will not increase.<\/p>\n<p>If you increase the Memory of the large pool, queries will be able to find the memory they need to work in the large pool.<\/p>\n<h3>Java Pool<\/h3>\n<p>You only need it if you are using Java Stored Procedures.<\/p>\n<h3>Streams Pool<\/h3>\n<p>Used for Oracle Streams.<\/p>\n<p>You can see the current, minimum, and maximum sizes of the memory areas in the SGA with the following query.<\/p>\n<pre class=\"lang:default decode:true\">select COMPONENT,CURRENT_SIZE,MIN_SIZE,MAX_SIZE\nfrom v$sga_dynamic_components;<\/pre>\n<h2>PGA(Program Global Area)<\/h2>\n<p>It is a special memory area for processes.<\/p>\n<p>Users connected to Oracle use this area as memory.<\/p>\n<p>PGA_AGGREGATE_TARGET value gives the total pga available for that instance.<\/p>\n<p>You can see this value with the below command while connected to the database.<\/p>\n<pre class=\"lang:default decode:true\">show parameter pga<\/pre>\n<p>For other memory components, you can use the below command.<\/p>\n<pre class=\"lang:default decode:true\">show parameter mem<\/pre>\n<p>The default value is 10 mb or 20% of the SGA.<\/p>\n<p>The following screen images from Oracle&#8217;s site can give you an idea of \u200b\u200bthe PGA.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/639.png\" width=\"297\" height=\"307\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/600-1.png\" width=\"526\" height=\"128\" \/><\/p>\n<p>You can get an idea about SGA and PGA from the screenshots below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/916.png\" width=\"577\" height=\"914\" \/><\/p>\n<p lang=\"en-US\">You can see how much memory is allocated for the PGA with the following query.<\/p>\n<pre class=\"lang:default decode:true \">select name,value from v$pgastat\nwhere name in ('maximum PGA allocated','total PGA allocated');<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_857\" class=\"pvc_stats all  \" data-element-id=\"857\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Oracle stores the following components in Memory. Program Code Connected sessions even if not active Information required during Query Execution. For example, if the query fetches which rows Information shared and communicated between Oracle processes. For example, lock information Data blocks and redo log records are kept in memory for caching purposes. We can examine &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_857\" class=\"pvc_stats all  \" data-element-id=\"857\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":14533,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[1080,1101,1092,1061,1062,1055,1063,1083,1082,1098,1043,1085,1059,1060,1076,1075,7215,1074,1084,1072,1109,1051,1046,7209,1047,1069,1070,1087,1086,1096,1089,1088,1071,1068,1064,1057,1079,1078,1077,1093,1052,1039,1094,1091,1037,7214,1038,1113,1105,1054,1103,1073,1100,1042,1049,1104,7210,1090,1044,1036,1035,1050,1111,1110,1112,1056,1053,1041,1045,1058,1081,1102,1048,1040,1097,1095,1099,1065,1106,1066,1107,1108,7208,7206,7212,7211,1067],"class_list":["post-857","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-alter-table-cache","tag-anonymous-pl-sqls","tag-archive-log","tag-automatic-memory-management","tag-automatic-memory-management-on-oracle","tag-automatic-shared-memory-management","tag-automatic-shared-memory-management-on-oracle","tag-buffer_pool","tag-buffer_pool-keep","tag-data-dictionary-cache","tag-database-buffer-cache","tag-database-caching","tag-db_keep_cache_size","tag-db_recycle_cache_size","tag-dbwn","tag-dbwn-background-process","tag-difference-between-anonymous-pl-sqls-and-stored-pl-sqls","tag-dirty-buffers","tag-force-full-database-caching","tag-free-buffers","tag-ga_dynamic_components","tag-granules","tag-java-pool","tag-keep-buffer-pool","tag-large-pool","tag-least-recently-used","tag-least-recently-used-list","tag-lgwr","tag-lgwrlog-writer-background-process","tag-library-cache","tag-log-writer","tag-log-writer-background-process","tag-lru-list","tag-lruleast-recently-used-list","tag-manual-memory-management","tag-memory_target","tag-most-recently-used","tag-mru","tag-mrumost-recently-used","tag-oracle-archive-log","tag-oracle-granules","tag-oracle-pga","tag-oracle-rac","tag-oracle-redo-log","tag-oracle-sga","tag-parsing-in-oracle","tag-pga","tag-pga-usage","tag-pga_aggregate_target","tag-pga_target","tag-pgaprogram-global-area","tag-pinned-buffers","tag-pl-sql-area","tag-private-global-area","tag-program-code","tag-program-global-area","tag-recycle-buffer-pool","tag-redo-log","tag-redo-log-buffer","tag-sga","tag-sga-and-pga","tag-sga-components","tag-sga-maximum-size","tag-sga-minimum-size","tag-sga-usage","tag-sga_max_size","tag-sga_target","tag-shared-global-area","tag-shared-pool","tag-spfile","tag-storage-buffer_pool-keep","tag-stored-pl-sqls","tag-streams-pool","tag-system-global-area","tag-the-data-dictionary-cache","tag-the-library-cache","tag-the-pl-sql-area","tag-vbuffer_pool","tag-vpgastat","tag-vsgastat","tag-view-pga-memory","tag-view-sga-memory","tag-what-is-sga_max_size","tag-what-is-sga_target","tag-what-is-the-role-of-the-database-buffer-cache","tag-write-and-lru-list","tag-write-list"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":10255,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Memory Components(SGA and PGA) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Oracle Memory Components(SGA and PGA)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Memory Components(SGA and PGA) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Oracle Memory Components(SGA and PGA)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-21T16:59:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-31T13:03:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"496\" \/>\n\t<meta property=\"og:image:height\" content=\"302\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"9 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"Oracle Memory Components(SGA and PGA)\",\"datePublished\":\"2018-07-21T16:59:31+00:00\",\"dateModified\":\"2019-12-31T13:03:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/\"},\"wordCount\":1672,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-4.png\",\"keywords\":[\"ALTER TABLE ... CACHE\",\"Anonymous PL\/SQLs\",\"archive log\",\"Automatic Memory Management\",\"Automatic Memory Management On Oracle\",\"Automatic Shared Memory Management\",\"Automatic Shared Memory Management On Oracle\",\"BUFFER_POOL\",\"BUFFER_POOL KEEP\",\"data dictionary cache\",\"Database buffer cache\",\"DATABASE CACHING\",\"DB_KEEP_CACHE_SIZE\",\"DB_RECYCLE_CACHE_SIZE\",\"DBWn\",\"DBWn background process\",\"difference between Anonymous PL\/SQLs and stored PL\/SQLs\",\"dirty buffers\",\"FORCE FULL DATABASE CACHING\",\"Free buffers\",\"ga_dynamic_components\",\"granules\",\"Java pool\",\"keep buffer pool\",\"Large pool\",\"Least Recently Used\",\"Least Recently Used List\",\"LGWR\",\"LGWR(Log Writer Background Process)\",\"library cache\",\"Log Writer\",\"Log Writer Background Process\",\"LRU List\",\"LRU(Least Recently Used) List\",\"Manual Memory Management\",\"MEMORY_TARGET\",\"Most Recently Used\",\"MRU\",\"MRU(Most Recently Used)\",\"oracle archive log\",\"oracle granules\",\"ORACLE PGA\",\"oracle rac\",\"oracle redo log\",\"ORACLE SGA\",\"Parsing in Oracle\",\"PGA\",\"pga usage\",\"PGA_AGGREGATE_TARGET\",\"PGA_TARGET\",\"PGA(Program Global Area)\",\"pinned buffers\",\"PL\/SQL area\",\"Private Global Area\",\"Program Code\",\"Program Global Area\",\"recycle buffer pool\",\"redo log\",\"Redo log buffer\",\"SGA\",\"SGA and PGA\",\"SGA Components\",\"sga maximum size\",\"sga minimum size\",\"sga usage\",\"SGA_MAX_SIZE\",\"SGA_TARGET\",\"Shared Global Area\",\"Shared pool\",\"spfile\",\"STORAGE BUFFER_POOL KEEP\",\"Stored PL\/SQLs\",\"Streams pool\",\"System Global Area\",\"The data dictionary cache\",\"The library cache\",\"The PL\/SQL area\",\"V$BUFFER_POOL\",\"v$pgastat\",\"V$SGASTAT\",\"view pga memory\",\"view sga memory\",\"What is SGA_MAX_SIZE\",\"What is SGA_TARGET?\",\"What is the role of the database buffer cache?\",\"Write and LRU List\",\"Write List\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/\",\"name\":\"Oracle Memory Components(SGA and PGA) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-4.png\",\"datePublished\":\"2018-07-21T16:59:31+00:00\",\"dateModified\":\"2019-12-31T13:03:18+00:00\",\"description\":\"Oracle Memory Components(SGA and PGA)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-4.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-4.png\",\"width\":496,\"height\":302},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Memory Components(SGA and PGA)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Memory Components(SGA and PGA) - Database Tutorials","description":"Oracle Memory Components(SGA and PGA)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Memory Components(SGA and PGA) - Database Tutorials","og_description":"Oracle Memory Components(SGA and PGA)","og_url":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/","og_site_name":"Database Tutorials","article_published_time":"2018-07-21T16:59:31+00:00","article_modified_time":"2019-12-31T13:03:18+00:00","og_image":[{"width":496,"height":302,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-4.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"Oracle Memory Components(SGA and PGA)","datePublished":"2018-07-21T16:59:31+00:00","dateModified":"2019-12-31T13:03:18+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/"},"wordCount":1672,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-4.png","keywords":["ALTER TABLE ... CACHE","Anonymous PL\/SQLs","archive log","Automatic Memory Management","Automatic Memory Management On Oracle","Automatic Shared Memory Management","Automatic Shared Memory Management On Oracle","BUFFER_POOL","BUFFER_POOL KEEP","data dictionary cache","Database buffer cache","DATABASE CACHING","DB_KEEP_CACHE_SIZE","DB_RECYCLE_CACHE_SIZE","DBWn","DBWn background process","difference between Anonymous PL\/SQLs and stored PL\/SQLs","dirty buffers","FORCE FULL DATABASE CACHING","Free buffers","ga_dynamic_components","granules","Java pool","keep buffer pool","Large pool","Least Recently Used","Least Recently Used List","LGWR","LGWR(Log Writer Background Process)","library cache","Log Writer","Log Writer Background Process","LRU List","LRU(Least Recently Used) List","Manual Memory Management","MEMORY_TARGET","Most Recently Used","MRU","MRU(Most Recently Used)","oracle archive log","oracle granules","ORACLE PGA","oracle rac","oracle redo log","ORACLE SGA","Parsing in Oracle","PGA","pga usage","PGA_AGGREGATE_TARGET","PGA_TARGET","PGA(Program Global Area)","pinned buffers","PL\/SQL area","Private Global Area","Program Code","Program Global Area","recycle buffer pool","redo log","Redo log buffer","SGA","SGA and PGA","SGA Components","sga maximum size","sga minimum size","sga usage","SGA_MAX_SIZE","SGA_TARGET","Shared Global Area","Shared pool","spfile","STORAGE BUFFER_POOL KEEP","Stored PL\/SQLs","Streams pool","System Global Area","The data dictionary cache","The library cache","The PL\/SQL area","V$BUFFER_POOL","v$pgastat","V$SGASTAT","view pga memory","view sga memory","What is SGA_MAX_SIZE","What is SGA_TARGET?","What is the role of the database buffer cache?","Write and LRU List","Write List"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/","url":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/","name":"Oracle Memory Components(SGA and PGA) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-4.png","datePublished":"2018-07-21T16:59:31+00:00","dateModified":"2019-12-31T13:03:18+00:00","description":"Oracle Memory Components(SGA and PGA)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-4.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2018\/07\/Ads\u0131z-4.png","width":496,"height":302},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/07\/21\/oracle-memory-components-sga-and-pga\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Oracle Memory Components(SGA and PGA)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=857"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/857\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14533"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}