{"id":1621,"date":"2015-11-05T19:17:37","date_gmt":"2015-11-06T01:17:37","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1621"},"modified":"2026-02-07T15:38:08","modified_gmt":"2026-02-07T21:38:08","slug":"mos-tools-for-proactive-dba","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2015\/1621\/","title":{"rendered":"MOS Tools for Proactive DBA!"},"content":{"rendered":"<p>As a DBA, you must be familiar with the various tools provided by My Oracle Support (MOS) for diagnostics and health check. Here are few every DBA must be familiar with, which will help you when everyone else in the organization is jumping on you to resolve a failure or troubleshoot a performance issue.<\/p>\n<ul>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=171609898605336&amp;id=1513912.2&amp;_adf.ctrl-state=i8ygm4y41_57\" target=\"_blank\">1513912.2<\/a> \u2013 TFA Collector &#8212; Install on all database servers to collect critical diagnostic\u00a0information.<\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=171762605432259&amp;id=1268927.2&amp;_adf.ctrl-state=i8ygm4y41_98\" target=\"_blank\">1268927.2<\/a> \u2013 ORACHK &#8212; New version comes out every quarter with patch updates and sometimes new features. A must run utility on all database servers. Take care of the recommendations to avoid an outage in the future.<\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=171802618895641&amp;id=301137.1&amp;_adf.ctrl-state=i8ygm4y41_139\" target=\"_blank\">301137.1<\/a> \u2013 OS Watcher &#8212; captures performance information from the Operating System.<\/li>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=171878890401225&amp;id=215187.1&amp;_adf.ctrl-state=i8ygm4y41_196\" target=\"_blank\">215187.1<\/a> \u2013 SQLT &#8212; diagnose poorly performing SQL statements.<\/li>\n<\/ul>\n<ul>\n<li><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=171960409054359&amp;id=1500864.1&amp;_adf.ctrl-state=i8ygm4y41_253\" target=\"_blank\">1500864.1 <\/a>\u2013 oratop &#8212;\u00a0utility similar to the unix OS utility top which gives an overview of database performance.<\/li>\n<\/ul>\n<p>In addition to the above tools, MOS also provides several troubleshooting tools such as ORA-600, ORA-1578, ORA-2730x, ORA-3137, ORA-4030, ORA-4031, ORA-7445, RAC Node Eviction and so on. All of these tools are documented in MOS note <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocumentDisplay?_afrLoop=172107671725163&amp;id=559339.1&amp;_adf.ctrl-state=i8ygm4y41_367\" target=\"_blank\">559339.1<\/a> Diagnostic Tools Catalog.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>As a DBA, you must be familiar with the various tools provided by My Oracle Support (MOS) for diagnostics and health check. Here are few every DBA must be familiar with, which will help you when everyone else in the organization is jumping on you to resolve a failure or troubleshoot a performance issue. 1513912.2 &#8230; <a title=\"MOS Tools for Proactive DBA!\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2015\/1621\/\" aria-label=\"Read more about MOS Tools for Proactive DBA!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[133],"tags":[],"class_list":["post-1621","post","type-post","status-publish","format-standard","hentry","category-oracledb"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=1621"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1621\/revisions"}],"predecessor-version":[{"id":3047,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1621\/revisions\/3047"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}