{"id":1067,"date":"2019-12-25T11:28:21","date_gmt":"2019-12-25T14:28:21","guid":{"rendered":"http:\/\/soudba.com.br\/?p=1067"},"modified":"2019-12-25T11:28:21","modified_gmt":"2019-12-25T14:28:21","slug":"sysaux-is-growing-a-lot","status":"publish","type":"post","link":"https:\/\/www.soudba.com.br\/?p=1067","title":{"rendered":"SYSAUX is growing a lot!"},"content":{"rendered":"\n<p>Tablespace sysaux for almost of regular sizes of databases are under 2G and for some big databases they are growing a lot. We need to stay alert with, because many of bugs are related with some jobs who can&#8217;t remove some old records on tables using sysaux.<\/p>\n\n\n<p>First step: run awrinfo.sql<\/p>\n\n\n<p>This script will help &#8211; with a report of all detailed occupants of tablespace sysaux.<\/p>\n\n\n<p>This can take a time and we have a lot of documents on MOS related with bugs who we need investigate to make sure we not hit a bug. <\/p>\n\n\n<pre class=\"wp-block-code\"><code> @?\/rdbms\/admin\/awrinfo.sql<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Tablespace sysaux for almost of regular sizes of databases are under 2G and for some big databases they are growing a lot. We need to stay alert with, because many of bugs are related with some jobs who can&#8217;t remove &hellip; <a href=\"https:\/\/www.soudba.com.br\/?p=1067\">Continue lendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[354,296,300],"tags":[398,399],"class_list":["post-1067","post","type-post","status-publish","format-standard","hentry","category-size","category-sysaux","category-tablespace","tag-tablespace-size","tag-tablespace-sysaux"],"_links":{"self":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1067","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1067"}],"version-history":[{"count":0,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=\/wp\/v2\/posts\/1067\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1067"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1067"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soudba.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1067"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}