{"id":1007,"date":"2006-06-29T12:00:00","date_gmt":"2006-06-29T12:00:00","guid":{"rendered":"http:\/\/orcldoug.com\/blog\/?p=1007"},"modified":"2006-06-29T12:00:00","modified_gmt":"2006-06-29T12:00:00","slug":"max_dump_file_size","status":"publish","type":"post","link":"http:\/\/orcldoug.com\/blog\/2006\/06\/29\/max_dump_file_size\/","title":{"rendered":"max_dump_file_size"},"content":{"rendered":"<p>Is it just me or is there an error in the <a href=\"http:\/\/download-west.oracle.com\/docs\/cd\/B10501_01\/server.920\/a96536\/ch1109.htm#REFRN10103\">Reference Manual<\/a>? We were having a problem with enormous trace files being generated, so wanted to limit the size system-wide. Although I&#8217;m generally used to specifying this in blocks, I thought I would try specifying it in Mb.<\/p>\n<\/p>\n<pre>920&gt; show parameter max_dump<br\/>NAME                                 TYPE        VALUE<br\/>------------------------------------ ----------- -----------------------<br\/>max_dump_file_size                   string      UNLIMITED<br\/><p><\/p><br\/>920&gt; alter system set max_dump_file_size=20m;<br\/>alter system set max_dump_file_size=20m<br\/>                                      *<br\/>ERROR at line 1:<br\/>ORA-02065: illegal option for ALTER SYSTEM<br\/><p><\/p><br\/>920&gt; alter system set max_dump_file_size=40960;<br\/>System altered.<\/pre>\n<p>I&#8217;ve tried it on a few different versions now and haven&#8217;t found an example yet where I can get it to work. Maybe it&#8217;s just lack of sleep or something.<\/p>\n<p><\/p>\n<p><strong>Updated later &#8211; based on comment from Thomazzo<\/strong><\/p>\n<pre>920&gt; alter system set max_dump_file_size='20m';<br\/><p><\/p><br\/>System altered.<\/pre>\n<p>I still think the syntax description could be a little clearer.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Is it just me or is there an error in the Reference Manual? We were having a problem with enormous trace files being generated, so wanted to limit the size system-wide. Although I&#8217;m generally used to specifying this in blocks, I thought I would try specifying it in Mb. 920&gt; show parameter max_dumpNAME TYPE VALUE&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&hellip; <a class=\"more-link\" href=\"http:\/\/orcldoug.com\/blog\/2006\/06\/29\/max_dump_file_size\/\">Continue reading <span class=\"screen-reader-text\">max_dump_file_size<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1007","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":1014,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/10\/being-open-minded\/","url_meta":{"origin":1007,"position":0},"title":"Being Open-minded","date":"July 10, 2006","format":false,"excerpt":"I think that one of the most important skills of a good DBA and one of the most difficult to maintain as your experience grows is to stay open-minded.When I got into work this morning, there was an email waiting for me from a frustrated developer who wanted to know\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1019,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/14\/alter-table-move-and-table-stats-part-ii\/","url_meta":{"origin":1007,"position":1},"title":"alter table &#8230; move and table stats (part II)","date":"July 14, 2006","format":false,"excerpt":"Following up on another comment from Howard, I took the initrans change off the alter table ... move so that it was the most basic variation and then ran it on 8i, 9i and 10g. I've trimmed lots of the output this time, but I have the log files if\u2026","rel":"","context":"Similar post","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1017,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/13\/alter-table-move-and-table-stats\/","url_meta":{"origin":1007,"position":2},"title":"alter table &#8230; move and table stats","date":"July 13, 2006","format":false,"excerpt":"Howard Rogers left a comment on my last blog, showing an example of using alter table ... move on a 10gR2 database on Linux. In his example, unlike mine, the table rebuild did not nullify the table's statistics. I admit I was surprised myself when I ran my example yesterday\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1016,"url":"http:\/\/orcldoug.com\/blog\/2006\/07\/12\/table-reorgs-and-statistics\/","url_meta":{"origin":1007,"position":3},"title":"Table reorgs and statistics","date":"July 12, 2006","format":false,"excerpt":"While working on the ITL deadlock problem (which looks like it's been fixed by the initrans increase and table rebuild), the developers highlighted another table as hitting this problem in the past. When I investigated, I found that initrans had already been set to 6 so this had obviously happened\u2026","rel":"","context":"With 10 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":901,"url":"http:\/\/orcldoug.com\/blog\/2005\/11\/19\/another-interesting-lewis-tip\/","url_meta":{"origin":1007,"position":4},"title":"Another Interesting Lewis Tip","date":"November 19, 2005","format":false,"excerpt":"Updated 24th November 2005I wouldn't normally update an existing entry but there are some very interesting and important comments on this entry, particularly from Jonathan Lewis and Howard Rogers, that I'd recommend you take the time to read. Jonathan also mentions it on his website. There's much more in the\u2026","rel":"","context":"With 15 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1570,"url":"http:\/\/orcldoug.com\/blog\/2010\/02\/28\/statistics-on-partitioned-tables-part-5\/","url_meta":{"origin":1007,"position":5},"title":"Statistics on Partitioned Tables &#8211; Part 5","date":"February 28, 2010","format":false,"excerpt":"Actually, before looking at any recent features, let me introduce one more aspect of the existing aggregation approach used by Oracle. The examples used to date have been based on INSERTing new rows into subpartitions and, although that's the approach used for some of our tables and will suit some\u2026","rel":"","context":"With 18 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1007","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1007"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1007\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1007"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}