{"id":9930,"date":"2017-04-07T17:27:12","date_gmt":"2017-04-07T15:27:12","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/"},"modified":"2017-04-07T17:27:12","modified_gmt":"2017-04-07T15:27:12","slug":"trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/","title":{"rendered":"Trace files segmented in multiple parts as a workaround for bug 23300142"},"content":{"rendered":"<p>Today I visited a customer, who deleted a Data Guard configuration (i.e. a temporary Data Guard setup through the broker was deleted). The LOG_ARCHIVE_DEST_STATE_2 on the primary database was set to DEFER temporarily. That resulted in trace-files with name *tt*.trc to become huge (GBytes after a couple of days). Analysis showed that this was caused by bug 23300142 in 12.1.0.2. See My Oracle Support Note<br \/>\n<code><br \/>\nBug 23300142 - TT background process trace file message: async ignored current log: kcclenal clear thread open (Doc ID 23300142.8)<br \/>\n<\/code><br \/>\nfor details.<br \/>\nUnfortunately the bug does not have a workaround.<br \/>\nDue to the fact that the affected development-databases (which were now normal single instances without Data Guard) could not be restarted, I searched for a temporary workaround to stop the trace-files from growing further. Limiting the trace-file size on the database with<br \/>\n<code><br \/>\nalter system set max_dump_file_size='100M';<br \/>\n<\/code><br \/>\ndid actually not always work to limit the file size. Here an example of a huge trace file (over 5GB):<\/p>\n<p><code><br \/>\n$ find . -name \"*tt*.trc\" -ls | tr -s \" \" | cut -d \" \" -f7-11 | sort -n<br \/>\n...<br \/>\n5437814195 Apr 7 10:46 .\/xxxxxx_site1\/XXXXXX\/trace\/XXXXXX_tt00_28304.trc<br \/>\n<\/code><\/p>\n<p>However, what came in handy was the uts-trace-segmentation feature of 12c. See Jonathan Lewis&#8217; blog here:<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"90P9XsOIOW\"><p><a href=\"https:\/\/jonathanlewis.wordpress.com\/2016\/01\/26\/trace-file-size\/\">Trace file size<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Trace file size&#8221; &#8212; Oracle Scratchpad\" src=\"https:\/\/jonathanlewis.wordpress.com\/2016\/01\/26\/trace-file-size\/embed\/#?secret=FicgTIvXvY#?secret=90P9XsOIOW\" data-secret=\"90P9XsOIOW\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>I.e. I left all DBs on max_dump_file_size=unlimited and set<\/p>\n<p><code><br \/>\nSQL&gt; alter system set \"_uts_first_segment_size\" = 52428800 scope=memory;<br \/>\nSQL&gt; alter system set \"_uts_trace_segment_size\" = 52428800 scope=memory;<br \/>\n<\/code><\/p>\n<p>Unfortunately setting the limit to the tt-background-process alone does not work:<\/p>\n<p><code><br \/>\nSQL&gt; exec dbms_system.set_int_param_in_session(sid =&gt; 199, serial# =&gt; 44511, parnam =&gt; '_uts_trace_segment_size', intval =&gt; 52428800);<br \/>\nBEGIN dbms_system.set_int_param_in_session(sid =&gt; 199, serial# =&gt; 44511, parnam =&gt; '_uts_trace_segment_size', intval =&gt; 52428800); END;<br \/>\n&nbsp;<br \/>\n*<br \/>\nERROR at line 1:<br \/>\nORA-44737: Parameter _uts_trace_segment_size did not exist.<br \/>\nORA-06512: at \"SYS.DBMS_SYSTEM\", line 117<br \/>\nORA-06512: at line 1<br \/>\n<\/code><\/p>\n<p>With the default setting of &#8220;_uts_trace_segments&#8221; (Maximum number of trace segments) = 5 I could limit the maximum size of the trace of 1 DB to 250MB (50MB * 5). Below you can see only 4 files, because of 2 tests with earlier splittings of the trace-file:<\/p>\n<p><code><br \/>\n$ ls -ltr *_tt00_28304*.trc<br \/>\n-rw-r----- 1 oracle dba 52428964 Apr  7 14:14 XXXXXX_tt00_28304_3.trc<br \/>\n-rw-r----- 1 oracle dba 52428925 Apr  7 16:07 XXXXXX_tt00_28304_4.trc<br \/>\n-rw-r----- 1 oracle dba 52428968 Apr  7 17:12 XXXXXX_tt00_28304_5.trc<br \/>\n-rw-r----- 1 oracle dba 43887950 Apr  7 18:50 XXXXXX_tt00_28304.trc<br \/>\n<\/code><\/p>\n<p>The feature of segmented trace-files may help a lot in situations like bug 23300142.<\/p>\n<p>REMARK: Do not use underscore parameters in production environments without agreement from Oracle Support.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today I visited a customer, who deleted a Data Guard configuration (i.e. a temporary Data Guard setup through the broker was deleted). The LOG_ARCHIVE_DEST_STATE_2 on the primary database was set to DEFER temporarily. That resulted in trace-files with name *tt*.trc to become huge (GBytes after a couple of days). Analysis showed that this was caused [&hellip;]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[60,96,1068,753,1069],"type_dbi":[],"class_list":["post-9930","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-oracle","tag-12c","tag-oracle","tag-segmented","tag-split","tag-trace-file"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Trace files segmented in multiple parts as a workaround for bug 23300142 - dbi 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:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Trace files segmented in multiple parts as a workaround for bug 23300142\" \/>\n<meta property=\"og:description\" content=\"Today I visited a customer, who deleted a Data Guard configuration (i.e. a temporary Data Guard setup through the broker was deleted). The LOG_ARCHIVE_DEST_STATE_2 on the primary database was set to DEFER temporarily. That resulted in trace-files with name *tt*.trc to become huge (GBytes after a couple of days). Analysis showed that this was caused [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-07T15:27:12+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Trace files segmented in multiple parts as a workaround for bug 23300142\",\"datePublished\":\"2017-04-07T15:27:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/\"},\"wordCount\":266,\"commentCount\":0,\"keywords\":[\"12c\",\"Oracle\",\"segmented\",\"SPLIT\",\"trace file\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/\",\"name\":\"Trace files segmented in multiple parts as a workaround for bug 23300142 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-04-07T15:27:12+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Trace files segmented in multiple parts as a workaround for bug 23300142\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\/\/www.dbi-services.com\",\"https:\/\/x.com\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Trace files segmented in multiple parts as a workaround for bug 23300142 - dbi 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:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/","og_locale":"en_US","og_type":"article","og_title":"Trace files segmented in multiple parts as a workaround for bug 23300142","og_description":"Today I visited a customer, who deleted a Data Guard configuration (i.e. a temporary Data Guard setup through the broker was deleted). The LOG_ARCHIVE_DEST_STATE_2 on the primary database was set to DEFER temporarily. That resulted in trace-files with name *tt*.trc to become huge (GBytes after a couple of days). Analysis showed that this was caused [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/","og_site_name":"dbi Blog","article_published_time":"2017-04-07T15:27:12+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Trace files segmented in multiple parts as a workaround for bug 23300142","datePublished":"2017-04-07T15:27:12+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/"},"wordCount":266,"commentCount":0,"keywords":["12c","Oracle","segmented","SPLIT","trace file"],"articleSection":["Database Administration &amp; Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/","url":"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/","name":"Trace files segmented in multiple parts as a workaround for bug 23300142 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-04-07T15:27:12+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/trace-files-segmented-in-multiple-parts-as-a-workaround-for-bug-23300142\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Trace files segmented in multiple parts as a workaround for bug 23300142"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9930","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=9930"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9930\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9930"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}