{"id":13924,"date":"2019-12-26T07:05:37","date_gmt":"2019-12-26T07:05:37","guid":{"rendered":"https:\/\/dbtut.com\/?p=13924"},"modified":"2019-12-26T07:05:38","modified_gmt":"2019-12-26T07:05:38","slug":"library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/","title":{"rendered":"&#8220;library cache lock, gc cr request and gc buffer busy acquire&#8221; Wait Events After Upgrade to Oracle 12.2"},"content":{"rendered":"<p>When the Exadata database is upgraded to version 12.2, &#8220;gc cr request&#8221; and &#8220;gc buffer busy acquire&#8221; wait events occur in many operations in the database. At the same time, when users try to login, it can be seen that queries such as the following cause the &#8220;library cache lock&#8221; wait event.<\/p>\n<pre class=\"lang:default decode:true \">select spare6 from user$ where user#=:1<\/pre>\n<p>or<\/p>\n<pre class=\"lang:default decode:true \">SELECT privilege# FROM sysauth$ WHERE (grantee# = 1 OR grantee# = 1) AND privilege# &gt; 0<\/pre>\n<p>It has been found that there is a query like below which causes login operations to wait. The problem will be solved when session trying to do this update is killed. However, in heavily used databases, &#8220;gc cr request and gc buffer busy acquire&#8221; wait events make the database unresponsive.<\/p>\n<pre class=\"lang:default decode:true \">update user$ set spare6=DECODE(to_char(:2, \u2018YYYY-MM-DD\u2019), \u20180000-00-00\u2019, to_date(NULL), :2) where user#=:1<\/pre>\n<p>The root cause of the problem is the following bugs. The database patch 25163866 should be applied to solve the problem completely, and if this patch does not resolve, the patch UEK4 kernel 25730857 should be applied. You can apply the patch for the kernel by following the document 2207063.1. To apply the database patch, the database must be closed. When you apply a node on RAC systems, the instance on the node that is applied does not open. Close the database, apply the patch to all nodes, and then open it.<\/p>\n<p>Internal Bug 25163866 \u2013 SAGEASM-E DB HANG AT &#8216;GC CR REQUEST'&lt;=&#8217;LIBRARY CACHE LOAD LOCK&#8217;<br \/>\nInternal Bug 25730857 \u2013 UEK4: Cache Fusion Fails Because of Data Corruption in LWIPC<\/p>\n<p>It is also solved in databases with version 18.1.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13924\" class=\"pvc_stats all  \" data-element-id=\"13924\" 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>When the Exadata database is upgraded to version 12.2, &#8220;gc cr request&#8221; and &#8220;gc buffer busy acquire&#8221; wait events occur in many operations in the database. At the same time, when users try to login, it can be seen that queries such as the following cause the &#8220;library cache lock&#8221; wait event. select spare6 from &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13924\" class=\"pvc_stats all  \" data-element-id=\"13924\" 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":13925,"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":[5987,5988,5989,5974,5975,5976,5971,5969,5972,5973,5970,5982,5981,5986,5985,5983,5978,5979,5980,5977,5990],"class_list":["post-13924","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-bug-25163866","tag-bug-25730857","tag-cache-fusion-fails-because-of-data-corruption-in-lwipc","tag-gc-buffer-busy-acquire-wait-event","tag-gc-buffer-busy-acquire-wait-event-12c","tag-gc-buffer-busy-acquire-wait-event-oracle","tag-gc-cr-request-wait-event","tag-gc-cr-request-wait-event-12-2","tag-gc-cr-request-wait-event-oracle","tag-gc-cr-request-wait-event-oracle-12c","tag-gc-cr-request-wait-event-oracle-rac","tag-internal-bug-25163866","tag-internal-bug-25163866-sageasm-e-db-hang-at-gc-cr-requestlibrary-cache-load-lock","tag-internal-bug-25730857","tag-internal-bug-25730857-uek4-cache-fusion-fails-because-of-data-corruption-in-lwipc","tag-library-cache-load-lock","tag-library-cache-lock-wait-event","tag-library-cache-lock-wait-event-oracle","tag-library-cache-lock-wait-event-oracle-12c","tag-oracle-gc-buffer-busy-acquire-wait-event","tag-uek4-cache-fusion-fails-because-of-data-corruption-in-lwipc"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>&quot;library cache lock, gc cr request and gc buffer busy acquire&quot; Wait Events After Upgrade to Oracle 12.2 - Database Tutorials<\/title>\n<meta name=\"description\" content=\"&quot;library cache lock, gc cr request and gc buffer busy acquire&quot; Wait Events After Upgrade to Oracle 12.2\" \/>\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\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"&quot;library cache lock, gc cr request and gc buffer busy acquire&quot; Wait Events After Upgrade to Oracle 12.2 - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"&quot;library cache lock, gc cr request and gc buffer busy acquire&quot; Wait Events After Upgrade to Oracle 12.2\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-26T07:05:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-26T07:05:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-60.png\" \/>\n\t<meta property=\"og:image:width\" content=\"593\" \/>\n\t<meta property=\"og:image:height\" content=\"347\" \/>\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=\"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\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"&#8220;library cache lock, gc cr request and gc buffer busy acquire&#8221; Wait Events After Upgrade to Oracle 12.2\",\"datePublished\":\"2019-12-26T07:05:37+00:00\",\"dateModified\":\"2019-12-26T07:05:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/\"},\"wordCount\":245,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-60.png\",\"keywords\":[\"Bug 25163866\",\"Bug 25730857\",\"Cache Fusion Fails Because of Data Corruption in LWIPC\",\"gc buffer busy acquire wait event\",\"gc buffer busy acquire wait event 12c\",\"gc buffer busy acquire wait event oracle\",\"gc cr request wait event\",\"gc cr request wait event 12.2\",\"gc cr request wait event oracle\",\"gc cr request wait event oracle 12c\",\"gc cr request wait event oracle rac\",\"Internal Bug 25163866\",\"Internal Bug 25163866 \u2013 SAGEASM-E DB HANG AT \u2018GC CR REQUEST'&lt;=\u2019LIBRARY CACHE LOAD LOCK\u2019\",\"Internal Bug 25730857\",\"Internal Bug 25730857 \u2013 UEK4: Cache Fusion Fails Because of Data Corruption in LWIPC\",\"LIBRARY CACHE LOAD LOCK\",\"library cache lock wait event\",\"library cache lock wait event oracle\",\"library cache lock wait event oracle 12c\",\"oracle gc buffer busy acquire wait event\",\"UEK4: Cache Fusion Fails Because of Data Corruption in LWIPC\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/\",\"name\":\"\\\"library cache lock, gc cr request and gc buffer busy acquire\\\" Wait Events After Upgrade to Oracle 12.2 - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-60.png\",\"datePublished\":\"2019-12-26T07:05:37+00:00\",\"dateModified\":\"2019-12-26T07:05:38+00:00\",\"description\":\"\\\"library cache lock, gc cr request and gc buffer busy acquire\\\" Wait Events After Upgrade to Oracle 12.2\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-60.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-60.png\",\"width\":593,\"height\":347},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"&#8220;library cache lock, gc cr request and gc buffer busy acquire&#8221; Wait Events After Upgrade to Oracle 12.2\"}]},{\"@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":"\"library cache lock, gc cr request and gc buffer busy acquire\" Wait Events After Upgrade to Oracle 12.2 - Database Tutorials","description":"\"library cache lock, gc cr request and gc buffer busy acquire\" Wait Events After Upgrade to Oracle 12.2","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\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/","og_locale":"en_US","og_type":"article","og_title":"\"library cache lock, gc cr request and gc buffer busy acquire\" Wait Events After Upgrade to Oracle 12.2 - Database Tutorials","og_description":"\"library cache lock, gc cr request and gc buffer busy acquire\" Wait Events After Upgrade to Oracle 12.2","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-26T07:05:37+00:00","article_modified_time":"2019-12-26T07:05:38+00:00","og_image":[{"width":593,"height":347,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-60.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"&#8220;library cache lock, gc cr request and gc buffer busy acquire&#8221; Wait Events After Upgrade to Oracle 12.2","datePublished":"2019-12-26T07:05:37+00:00","dateModified":"2019-12-26T07:05:38+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/"},"wordCount":245,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-60.png","keywords":["Bug 25163866","Bug 25730857","Cache Fusion Fails Because of Data Corruption in LWIPC","gc buffer busy acquire wait event","gc buffer busy acquire wait event 12c","gc buffer busy acquire wait event oracle","gc cr request wait event","gc cr request wait event 12.2","gc cr request wait event oracle","gc cr request wait event oracle 12c","gc cr request wait event oracle rac","Internal Bug 25163866","Internal Bug 25163866 \u2013 SAGEASM-E DB HANG AT \u2018GC CR REQUEST'&lt;=\u2019LIBRARY CACHE LOAD LOCK\u2019","Internal Bug 25730857","Internal Bug 25730857 \u2013 UEK4: Cache Fusion Fails Because of Data Corruption in LWIPC","LIBRARY CACHE LOAD LOCK","library cache lock wait event","library cache lock wait event oracle","library cache lock wait event oracle 12c","oracle gc buffer busy acquire wait event","UEK4: Cache Fusion Fails Because of Data Corruption in LWIPC"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/","name":"\"library cache lock, gc cr request and gc buffer busy acquire\" Wait Events After Upgrade to Oracle 12.2 - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-60.png","datePublished":"2019-12-26T07:05:37+00:00","dateModified":"2019-12-26T07:05:38+00:00","description":"\"library cache lock, gc cr request and gc buffer busy acquire\" Wait Events After Upgrade to Oracle 12.2","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-60.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-60.png","width":593,"height":347},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/26\/library-cache-lock-gc-cr-request-and-gc-buffer-busy-acquire-wait-events-after-upgrade-to-oracle-12-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"&#8220;library cache lock, gc cr request and gc buffer busy acquire&#8221; Wait Events After Upgrade to Oracle 12.2"}]},{"@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\/13924","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=13924"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13924\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13925"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13924"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13924"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13924"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}