{"id":1642,"date":"2018-08-16T19:25:17","date_gmt":"2018-08-16T19:25:17","guid":{"rendered":"http:\/\/www.theSQLReport.com\/?p=1642"},"modified":"2018-08-16T19:26:21","modified_gmt":"2018-08-16T19:26:21","slug":"ora-00600-internal-error-code-arguments-723-140432-960048-memory-leak","status":"publish","type":"post","link":"https:\/\/www.theSQLReport.com\/?p=1642","title":{"rendered":"ORA-00600: internal error code, arguments: [723], [140432], [960048], [memory leak]"},"content":{"rendered":"<p>Recently, I was notified of this error in the alert log of one of my Oracle 12.1.0.2 databases:<\/p>\n<pre>ORA-00600: internal error code, arguments: [723], [140432], [960048], [memory leak], [], [], [], [], [], [], [], []<\/pre>\n<p>With the words &#8220;memory leak&#8221;, as part of the error, I reached out to Oracle support.<\/p>\n<p>After Oracle Support evaluated the trace file I sent associated with this error, they replied: &#8220;<em>can be safely ignored &#8211; it is just an internal housekeeping error and the size involved (xx bytes) is small<\/em>&#8221;<\/p>\n<p>The Oracle Support recommend:<\/p>\n<p>&#8220;<em>You can prevent the error from being reported by setting event 10262 in the init.ora or spfile and restarting the instance. eg: Add this parameter setting to either the init.ora or spfile: event = &#8220;10262 trace name context forever, level 2000000&#8221; <\/em><\/p>\n<p><em>*OR* <\/em><\/p>\n<p><em>alter system set event= &#8216;10262 trace name context forever, level 2000000&#8217; scope=spfile; <\/em><\/p>\n<p><em>In either case restart the instance so that all processes use the new setting.<\/em>&#8221;<\/p>\n<p><a href=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2018\/08\/OracleEvent.jpg\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1644 size-full\" src=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2018\/08\/OracleEvent.jpg\" alt=\"alter system set event\" width=\"950\" height=\"636\" srcset=\"http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2018\/08\/OracleEvent.jpg 950w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2018\/08\/OracleEvent-300x201.jpg 300w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2018\/08\/OracleEvent-768x514.jpg 768w, http:\/\/www.theSQLReport.com\/wp-content\/uploads\/2018\/08\/OracleEvent-210x141.jpg 210w\" sizes=\"(max-width: 950px) 100vw, 950px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently, I was notified of this error in the alert log of one of my Oracle 12.1.0.2 databases: ORA-00600: internal error code, arguments: [723], [140432], [960048], [memory leak], [], [], &hellip; <a class=\"readmore\" href=\"https:\/\/www.theSQLReport.com\/?p=1642\">Continue Reading &rarr;<\/a><\/p>\n","protected":false},"author":1,"featured_media":1644,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1642","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1642"}],"collection":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1642"}],"version-history":[{"count":7,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1642\/revisions"}],"predecessor-version":[{"id":1650,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/posts\/1642\/revisions\/1650"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=\/wp\/v2\/media\/1644"}],"wp:attachment":[{"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.theSQLReport.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}