{"id":218,"date":"2024-07-05T08:05:42","date_gmt":"2024-07-05T08:05:42","guid":{"rendered":"https:\/\/humtechno.com\/intro\/?p=218"},"modified":"2024-07-05T08:26:53","modified_gmt":"2024-07-05T08:26:53","slug":"ckpt-ospid-waits-for-event","status":"publish","type":"post","link":"https:\/\/humtechno.com\/intro\/2024\/07\/05\/ckpt-ospid-waits-for-event\/","title":{"rendered":"CKPT (OSPID : ) waits for event"},"content":{"rendered":"\n<p><strong>Error<\/strong>: CKPT (OSPID : 383463) waits for event &#8216;rdbms ipc reply&#8217; for 223 secs.<\/p>\n\n\n\n<p><strong>Diagnose<\/strong><\/p>\n\n\n\n<p>Checking: ( Top Wait Event of CKPT)<\/p>\n\n\n\n<p>select event, state, count(*) from v$session_wait group by event, state order by 3 desc; SELECT filename, status, bytes FROM v$block_change_tracking;<\/p>\n\n\n\n<p><strong>Solutions<\/strong><\/p>\n\n\n\n<p>alter system set &#8220;_bct_buffer_allocation_max&#8221;=1073741824 scope=both sid=&#8217;*&#8217;;<\/p>\n\n\n\n<p>alter system set &#8220;_bct_public_dba_buffer_maxsize&#8221;=1073741824 scope=both sid=&#8217;*&#8217;<\/p>\n\n\n\n<p>alter system set &#8220;_bct_public_dba_buffer_size&#8221;=1073741824 scope=both sid=&#8217;*&#8217;;<\/p>\n\n\n\n<p><strong>Error Message<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img fetchpriority=\"high\" decoding=\"async\" width=\"697\" height=\"479\" src=\"https:\/\/humtechno.com\/intro\/wp-content\/uploads\/2024\/07\/error.jpg\" alt=\"\" class=\"wp-image-219\" srcset=\"https:\/\/humtechno.com\/intro\/wp-content\/uploads\/2024\/07\/error.jpg 697w, https:\/\/humtechno.com\/intro\/wp-content\/uploads\/2024\/07\/error-300x206.jpg 300w\" sizes=\"(max-width: 697px) 100vw, 697px\" \/><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Error: CKPT (OSPID : 383463) waits for event &#8216;rdbms ipc reply&#8217; for 223 secs. Diagnose Checking: ( Top Wait Event of CKPT) select event, state, count(*) from v$session_wait group by event, state order by 3 desc; SELECT filename, status, bytes FROM v$block_change_tracking; Solutions alter system set &#8220;_bct_buffer_allocation_max&#8221;=1073741824 scope=both sid=&#8217;*&#8217;; alter system set &#8220;_bct_public_dba_buffer_maxsize&#8221;=1073741824 scope=both sid=&#8217;*&#8217; [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":221,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[3],"tags":[],"class_list":["post-218","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/comments?post=218"}],"version-history":[{"count":1,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":220,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/posts\/218\/revisions\/220"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media\/221"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/media?parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/categories?post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/intro\/wp-json\/wp\/v2\/tags?post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}