{"id":8334,"date":"2020-10-15T14:35:44","date_gmt":"2020-10-15T13:35:44","guid":{"rendered":"https:\/\/blog.capdata.fr\/?p=8334"},"modified":"2020-10-15T14:35:44","modified_gmt":"2020-10-15T13:35:44","slug":"pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c","status":"publish","type":"post","link":"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/","title":{"rendered":"&#8220;PGA memory operation&#8221;, &#8220;Acknowledge over PGA limit&#8221;  et ORA-04036 apr\u00e8s migration vers 12c"},"content":{"rendered":"<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8334&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8334&#038;title=%E2%80%9CPGA%20memory%20operation%E2%80%9D%2C%20%E2%80%9CAcknowledge%20over%20PGA%20limit%E2%80%9D%20%20et%20ORA-04036%20apr%C3%A8s%20migration%20vers%2012c\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=%E2%80%9CPGA%20memory%20operation%E2%80%9D%2C%20%E2%80%9CAcknowledge%20over%20PGA%20limit%E2%80%9D%20%20et%20ORA-04036%20apr%C3%A8s%20migration%20vers%2012c&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8334\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a><p><strong>La situation :<\/strong><br \/>\nLors de migrations r\u00e9centes, des probl\u00e8mes de performances sont apparus, avec de nombreuses sessions en attente sur l&#8217;\u00e9v\u00e9nement &#8220;<em>PGA memory operation<\/em>&#8220;, et l&#8217;erreur <em>ORA-04036<\/em> \u00e9tait parfois observ\u00e9e dans l&#8217;alert_log des instances migr\u00e9es.<br \/>\nLes Migrations consistaient \u00e0 passer des versions 10g ou 11g vers 12.1, ou de la version 12.1 vers 12.2<br \/>\nCes probl\u00e8mes n&#8217;\u00e9taient pas observ\u00e9s lors de la phase de validation des bases 12c, mais l&#8217;\u00e9taient une fois que la migration \u00e9tait effectu\u00e9e et qu&#8217;une forte activit\u00e9 en base survenait.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>La PGA en 12c :<\/strong><br \/>\nLa zone de m\u00e9moire PGA est compos\u00e9e de petites espaces de m\u00e9moire, chacun d\u00e9di\u00e9 \u00e0 une session, et est utilis\u00e9e principalement pour les op\u00e9rations de tris et la g\u00e9n\u00e9ration de plans d&#8217;ex\u00e9cution.<br \/>\nAvant la version 12.1, il \u00e9tait possible de &#8220;proposer&#8221; une taille maximale pour cette zone (param\u00e8tre <em>pga_aggregate_target<\/em>) mais pas de la limiter explicitement (indirectement via l&#8217;utilisation du param\u00e8tre cach\u00e9 &#8220;<em>_pga_max_size<\/em>&#8220;).<br \/>\nCette absence de limitation pouvait occasionner des probl\u00e8mes de surconsommation de m\u00e9moire, avec des impacts dramatiques sur les performances de traitements en base.<\/p>\n<p>Le param\u00e8tre <em>PGA_AGGREGATE_LIMIT<\/em> existe depuis la version 12.1, et permet de limiter explicitement la taille de la PGA.<\/p>\n<p>Lorsqu&#8217;une session demande de la m\u00e9moire suppl\u00e9mentaire pour sa propre PGA, et que la taille totale de la PGA atteint sa limite :<br \/>\nLa session est plac\u00e9e en attente, sur l&#8217;\u00e9v\u00e9nement &#8220;<em>Acknowledge over PGA limit<\/em>&#8220;,<br \/>\nL&#8217;instance &#8220;fait le m\u00e9nage&#8221; dans les PGA des autres sessions,<br \/>\nElle peut \u00e9ventuellement terminer des sessions, qui rencontreront le code erreur <em>ORA-04036<\/em><\/p>\n<p>L&#8217;\u00e9v\u00e9nement d&#8217;attente g\u00e9n\u00e9rique &#8220;<em>PGA memory operation<\/em>&#8221; indique simplement que la session cherche \u00e0 allouer ou d\u00e9sallouer de la m\u00e9moire pour sa propre PGA.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Voil\u00e0 pour le comportement, mais d&#8217;o\u00f9 vient le probl\u00e8me ?<\/strong><\/p>\n<p>Le param\u00e8tre <em>PGA_AGGREGATE_LIMIT<\/em> a une valeur par d\u00e9faut de &#8220;la plus grande valeur entre : 2Go, 2 x PGA_AGGREGATE_TARGET et 3Mo x PROCESSES&#8221;. La valeur calcul\u00e9e peut \u00eatre bien inf\u00e9rieure \u00e0 l&#8217;utilisation r\u00e9elle de la PGA, et donc occasionner les sympt\u00f4mes d\u00e9crits plus haut.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Corriger le probl\u00e8me:<\/strong><br \/>\nA court terme (uniquement) : valoriser <em>PGA_AGGREGATE_LIMIT<\/em> \u00e0 0, pour purement et simplement supprimer la limitation de la taille de la PGA.<br \/>\nMais il est bon de limiter la m\u00e9moire totale utilisable par l&#8217;instance. Il s&#8217;agira donc de trouver une valeur correcte de la limite de la PGA, en se basant sur la taille maximale de la PGA observ\u00e9e (gr\u00e2ce, entre autres, \u00e0 la requ\u00eate <em>SELECT VALUE FROM V$PGASTATS WHERE NAME=&#8217;maximum PGA allocated&#8217;<\/em>).<\/p>\n<a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-twitter nolightbox\" data-provider=\"twitter\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Twitter\" href=\"https:\/\/twitter.com\/intent\/tweet?url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8334&#038;text=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"twitter\" title=\"Share on Twitter\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/twitter.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-linkedin nolightbox\" data-provider=\"linkedin\" target=\"_blank\" rel=\"nofollow\" title=\"Share on Linkedin\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8334&#038;title=%E2%80%9CPGA%20memory%20operation%E2%80%9D%2C%20%E2%80%9CAcknowledge%20over%20PGA%20limit%E2%80%9D%20%20et%20ORA-04036%20apr%C3%A8s%20migration%20vers%2012c\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px;margin-right:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"linkedin\" title=\"Share on Linkedin\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/linkedin.png\" \/><\/a><a class=\"synved-social-button synved-social-button-share synved-social-size-24 synved-social-resolution-single synved-social-provider-mail nolightbox\" data-provider=\"mail\" rel=\"nofollow\" title=\"Share by email\" href=\"mailto:?subject=%E2%80%9CPGA%20memory%20operation%E2%80%9D%2C%20%E2%80%9CAcknowledge%20over%20PGA%20limit%E2%80%9D%20%20et%20ORA-04036%20apr%C3%A8s%20migration%20vers%2012c&#038;body=Article%20sur%20le%20blog%20de%20la%20Capdata%20Tech%20Team%20%3A%20:%20https%3A%2F%2Fblog.capdata.fr%2Findex.php%2Fwp-json%2Fwp%2Fv2%2Fposts%2F8334\" style=\"font-size: 0px;width:24px;height:24px;margin:0;margin-bottom:5px\"><img loading=\"lazy\" decoding=\"async\" alt=\"mail\" title=\"Share by email\" class=\"synved-share-image synved-social-image synved-social-image-share\" width=\"24\" height=\"24\" style=\"display: inline;width:24px;height:24px;margin: 0;padding: 0;border: none;box-shadow: none\" src=\"https:\/\/blog.capdata.fr\/wp-content\/plugins\/social-media-feather\/synved-social\/image\/social\/regular\/48x48\/mail.png\" \/><\/a>","protected":false},"excerpt":{"rendered":"<p>La situation : Lors de migrations r\u00e9centes, des probl\u00e8mes de performances sont apparus, avec de nombreuses sessions en attente sur l&#8217;\u00e9v\u00e9nement &#8220;PGA memory operation&#8220;, et l&#8217;erreur ORA-04036 \u00e9tait parfois observ\u00e9e dans l&#8217;alert_log des instances migr\u00e9es. Les Migrations consistaient \u00e0 passer&hellip; <a href=\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/\" class=\"more-link\">Continuer la lecture <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":14,"featured_media":8336,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[368,369,367],"class_list":["post-8334","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-acknowledge-over-pga-limit","tag-ora-04036","tag-pga-memory-operation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>&quot;PGA memory operation&quot;, &quot;Acknowledge over PGA limit&quot; et ORA-04036 apr\u00e8s migration vers 12c - Capdata TECH BLOG<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"&quot;PGA memory operation&quot;, &quot;Acknowledge over PGA limit&quot; et ORA-04036 apr\u00e8s migration vers 12c - Capdata TECH BLOG\" \/>\n<meta property=\"og:description\" content=\"La situation : Lors de migrations r\u00e9centes, des probl\u00e8mes de performances sont apparus, avec de nombreuses sessions en attente sur l&#8217;\u00e9v\u00e9nement &#8220;PGA memory operation&#8220;, et l&#8217;erreur ORA-04036 \u00e9tait parfois observ\u00e9e dans l&#8217;alert_log des instances migr\u00e9es. Les Migrations consistaient \u00e0 passer&hellip; Continuer la lecture &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/\" \/>\n<meta property=\"og:site_name\" content=\"Capdata TECH BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-15T13:35:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/10\/board_card_chip_computer_data_digital_electrical_electronic-1358022.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"200\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Benjamin VESAN\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin VESAN\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/\"},\"author\":{\"name\":\"Benjamin VESAN\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e\"},\"headline\":\"&#8220;PGA memory operation&#8221;, &#8220;Acknowledge over PGA limit&#8221; et ORA-04036 apr\u00e8s migration vers 12c\",\"datePublished\":\"2020-10-15T13:35:44+00:00\",\"dateModified\":\"2020-10-15T13:35:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/\"},\"wordCount\":465,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"keywords\":[\"Acknowledge over PGA limit\",\"ORA-04036\",\"PGA memory operation\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/\",\"name\":\"\\\"PGA memory operation\\\", \\\"Acknowledge over PGA limit\\\" et ORA-04036 apr\u00e8s migration vers 12c - Capdata TECH BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.capdata.fr\/#website\"},\"datePublished\":\"2020-10-15T13:35:44+00:00\",\"dateModified\":\"2020-10-15T13:35:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/blog.capdata.fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"&#8220;PGA memory operation&#8221;, &#8220;Acknowledge over PGA limit&#8221; et ORA-04036 apr\u00e8s migration vers 12c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.capdata.fr\/#website\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"name\":\"Capdata TECH BLOG\",\"description\":\"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting\",\"publisher\":{\"@id\":\"https:\/\/blog.capdata.fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.capdata.fr\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.capdata.fr\/#organization\",\"name\":\"Capdata TECH BLOG\",\"url\":\"https:\/\/blog.capdata.fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"contentUrl\":\"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp\",\"width\":800,\"height\":254,\"caption\":\"Capdata TECH BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e\",\"name\":\"Benjamin VESAN\",\"url\":\"https:\/\/blog.capdata.fr\/index.php\/author\/bvesan\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\"PGA memory operation\", \"Acknowledge over PGA limit\" et ORA-04036 apr\u00e8s migration vers 12c - Capdata TECH BLOG","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:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/","og_locale":"fr_FR","og_type":"article","og_title":"\"PGA memory operation\", \"Acknowledge over PGA limit\" et ORA-04036 apr\u00e8s migration vers 12c - Capdata TECH BLOG","og_description":"La situation : Lors de migrations r\u00e9centes, des probl\u00e8mes de performances sont apparus, avec de nombreuses sessions en attente sur l&#8217;\u00e9v\u00e9nement &#8220;PGA memory operation&#8220;, et l&#8217;erreur ORA-04036 \u00e9tait parfois observ\u00e9e dans l&#8217;alert_log des instances migr\u00e9es. Les Migrations consistaient \u00e0 passer&hellip; Continuer la lecture &rarr;","og_url":"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/","og_site_name":"Capdata TECH BLOG","article_published_time":"2020-10-15T13:35:44+00:00","og_image":[{"width":300,"height":200,"url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2020\/10\/board_card_chip_computer_data_digital_electrical_electronic-1358022.jpg","type":"image\/jpeg"}],"author":"Benjamin VESAN","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Benjamin VESAN","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/#article","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/"},"author":{"name":"Benjamin VESAN","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e"},"headline":"&#8220;PGA memory operation&#8221;, &#8220;Acknowledge over PGA limit&#8221; et ORA-04036 apr\u00e8s migration vers 12c","datePublished":"2020-10-15T13:35:44+00:00","dateModified":"2020-10-15T13:35:44+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/"},"wordCount":465,"commentCount":1,"publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"keywords":["Acknowledge over PGA limit","ORA-04036","PGA memory operation"],"articleSection":["Oracle"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/","url":"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/","name":"\"PGA memory operation\", \"Acknowledge over PGA limit\" et ORA-04036 apr\u00e8s migration vers 12c - Capdata TECH BLOG","isPartOf":{"@id":"https:\/\/blog.capdata.fr\/#website"},"datePublished":"2020-10-15T13:35:44+00:00","dateModified":"2020-10-15T13:35:44+00:00","breadcrumb":{"@id":"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.capdata.fr\/index.php\/pga-memory-operation-acknowledge-over-pga-limit-et-ora-04036-apres-migration-vers-12c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/blog.capdata.fr\/"},{"@type":"ListItem","position":2,"name":"&#8220;PGA memory operation&#8221;, &#8220;Acknowledge over PGA limit&#8221; et ORA-04036 apr\u00e8s migration vers 12c"}]},{"@type":"WebSite","@id":"https:\/\/blog.capdata.fr\/#website","url":"https:\/\/blog.capdata.fr\/","name":"Capdata TECH BLOG","description":"Le blog technique sur les bases de donn\u00e9es de CAP DATA Consulting","publisher":{"@id":"https:\/\/blog.capdata.fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.capdata.fr\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/blog.capdata.fr\/#organization","name":"Capdata TECH BLOG","url":"https:\/\/blog.capdata.fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/","url":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","contentUrl":"https:\/\/blog.capdata.fr\/wp-content\/uploads\/2023\/01\/logo_capdata.webp","width":800,"height":254,"caption":"Capdata TECH BLOG"},"image":{"@id":"https:\/\/blog.capdata.fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/cap-data-consulting\/mycompany\/"]},{"@type":"Person","@id":"https:\/\/blog.capdata.fr\/#\/schema\/person\/ae56d1d3d5680d95ccc2c927e44bdc3e","name":"Benjamin VESAN","url":"https:\/\/blog.capdata.fr\/index.php\/author\/bvesan\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/8334","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/users\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/comments?post=8334"}],"version-history":[{"count":3,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/8334\/revisions"}],"predecessor-version":[{"id":8338,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/posts\/8334\/revisions\/8338"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media\/8336"}],"wp:attachment":[{"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/media?parent=8334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/categories?post=8334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.capdata.fr\/index.php\/wp-json\/wp\/v2\/tags?post=8334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}