{"id":54600,"date":"2023-06-02T20:20:40","date_gmt":"2023-06-02T20:20:40","guid":{"rendered":"https:\/\/dbtut.com\/?p=54600"},"modified":"2023-06-02T20:22:21","modified_gmt":"2023-06-02T20:22:21","slug":"ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/","title":{"rendered":"ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT"},"content":{"rendered":"<p>In today&#8217;s article, we will cover the ORA-04036: error that comes at the end of the upgrade while performing an upgrade on the database.<\/p>\n<p>After examining it, I noticed that I got the following error.<\/p>\n<pre class=\"lang:default decode:true \">ORA-00028: your session has been killed\r\nORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT\r\nPGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT of 4000 MB<\/pre>\n<p>The problem is roughly as follows, PGA space is a space used for existing sessions and on 11G this space can grow independently depending on capacity.<\/p>\n<p>In 12C and later, \u201d pga_aggregate_limit \u201d parameter was introduced. Since this parameter limits us, it leads to error.<\/p>\n<p>In fact, the first thing to do is to find the answer to the question of why the kill process consumes so much resources.<\/p>\n<p>If we look at the quick solutions,<\/p>\n<p>For example, you can set the &#8220;pga_aggregate_limit&#8221; limit to 0.<\/p>\n<pre class=\"lang:default decode:true \">alter system set pga_aggregate_limit=0 scope=both;\r\n<\/pre>\n<p>Or you can increase the limit.<\/p>\n<pre class=\"lang:default decode:true \">alter system set pga_aggregate_limit=4096M scope=both;\r\n<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_54600\" class=\"pvc_stats all  \" data-element-id=\"54600\" 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>In today&#8217;s article, we will cover the ORA-04036: error that comes at the end of the upgrade while performing an upgrade on the database. After examining it, I noticed that I got the following error. ORA-00028: your session has been killed ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT PGA memory used by the &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_54600\" class=\"pvc_stats all  \" data-element-id=\"54600\" 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":574,"featured_media":54602,"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":[],"class_list":["post-54600","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today&#039;s article, we will cover the ORA-04036: error that comes at the end of the upgrade while performing an upgrade on the database.\" \/>\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\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today&#039;s article, we will cover the ORA-04036: error that comes at the end of the upgrade while performing an upgrade on the database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-02T20:20:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-02T20:22:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-02-231321.png\" \/>\n\t<meta property=\"og:image:width\" content=\"713\" \/>\n\t<meta property=\"og:image:height\" content=\"317\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bu\u011fra PARLAYAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bu\u011fra PARLAYAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/\"},\"author\":{\"name\":\"Bu\u011fra PARLAYAN\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2\"},\"headline\":\"ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT\",\"datePublished\":\"2023-06-02T20:20:40+00:00\",\"dateModified\":\"2023-06-02T20:22:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/\"},\"wordCount\":139,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-02-231321.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/\",\"name\":\"ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-02-231321.png\",\"datePublished\":\"2023-06-02T20:20:40+00:00\",\"dateModified\":\"2023-06-02T20:22:21+00:00\",\"description\":\"In today's article, we will cover the ORA-04036: error that comes at the end of the upgrade while performing an upgrade on the database.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-02-231321.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-02-231321.png\",\"width\":713,\"height\":317},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT\"}]},{\"@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\/f07abb2de370d35d6c93e90d8eb2b9f2\",\"name\":\"Bu\u011fra PARLAYAN\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g\",\"caption\":\"Bu\u011fra PARLAYAN\"},\"description\":\"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.\",\"sameAs\":[\"http:\/\/www.bugraparlayan.com.tr\/\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT - Database Tutorials","description":"In today's article, we will cover the ORA-04036: error that comes at the end of the upgrade while performing an upgrade on the database.","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\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/","og_locale":"en_US","og_type":"article","og_title":"ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT - Database Tutorials","og_description":"In today's article, we will cover the ORA-04036: error that comes at the end of the upgrade while performing an upgrade on the database.","og_url":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/","og_site_name":"Database Tutorials","article_published_time":"2023-06-02T20:20:40+00:00","article_modified_time":"2023-06-02T20:22:21+00:00","og_image":[{"width":713,"height":317,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-02-231321.png","type":"image\/png"}],"author":"Bu\u011fra PARLAYAN","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bu\u011fra PARLAYAN","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/"},"author":{"name":"Bu\u011fra PARLAYAN","@id":"https:\/\/dbtut.com\/#\/schema\/person\/f07abb2de370d35d6c93e90d8eb2b9f2"},"headline":"ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT","datePublished":"2023-06-02T20:20:40+00:00","dateModified":"2023-06-02T20:22:21+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/"},"wordCount":139,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-02-231321.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/","url":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/","name":"ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-02-231321.png","datePublished":"2023-06-02T20:20:40+00:00","dateModified":"2023-06-02T20:22:21+00:00","description":"In today's article, we will cover the ORA-04036: error that comes at the end of the upgrade while performing an upgrade on the database.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-02-231321.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2023\/06\/Ekran-goruntusu-2023-06-02-231321.png","width":713,"height":317},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2023\/06\/02\/ora-04036-pga-memory-used-by-the-instance-exceeds-pga_aggregate_limit-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT"}]},{"@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\/f07abb2de370d35d6c93e90d8eb2b9f2","name":"Bu\u011fra PARLAYAN","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8fe63334d745f00f79f9f47b870aa143dd0f7615580c741a3b078aa4d09fa071?s=96&d=mm&r=g","caption":"Bu\u011fra PARLAYAN"},"description":"Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical \/ relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat &amp; Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.","sameAs":["http:\/\/www.bugraparlayan.com.tr\/"],"url":"https:\/\/dbtut.com\/index.php\/author\/bugraparlayan\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54600","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\/574"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=54600"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54600\/revisions"}],"predecessor-version":[{"id":54603,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/54600\/revisions\/54603"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/54602"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=54600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=54600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=54600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}