ahf analysis

<!DOCTYPE html SYSTEM "about:legacy-compat"> <html xml:lang="en-us" lang="en-us"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="DC.Type" content="reference"> <meta name="DC.Title" content="ahf analysis"> <meta name="abstract" content="Use the ahf analysis command to generate AHF Insights and AHF Balance reports."> <meta name="description" content="Use the ahf analysis command to generate AHF Insights and AHF Balance reports."> <meta name="DC.subject" content="ahf, commands, ahf analysis"> <meta name="keywords" content="ahf, commands, ahf analysis"> <meta name="DC.Relation" scheme="URI" content="ahf-insights.html#GUID-CA1ED11D-E14B-4AF6-8D55-29D7F84D5736"> <meta name="DC.Contributor" content="Aparna Kamath"> <meta name="DC.Contributor" content="Mark Bauer"> <meta name="DC.Contributor" content="Richard Strohm"> <meta name="DC.Creator" content="Aarya Joshi"> <meta name="DC.Creator" content="Alex Wu"> <meta name="DC.Creator" content="Amar Gorla"> <meta name="DC.Creator" content="Anand Pandey"> <meta name="DC.Creator" content="Arjun Upadhyay"> <meta name="DC.Creator" content="Ashwinee Khaladkar"> <meta name="DC.Creator" content="Barry Gleeson"> <meta name="DC.Creator" content="Bill Burton"> <meta name="DC.Creator" content="Bob Caldwell"> <meta name="DC.Creator" content="Bryan Vongray"> <meta name="DC.Creator" content="Carol Colrain"> <meta name="DC.Creator" content="Chandrabhushan Nagur"> <meta name="DC.Creator" content="Christian Diaz"> <meta name="DC.Creator" content="Damian Garcia"> <meta name="DC.Creator" content="Daniel Semler"> <meta name="DC.Creator" content="Daniel Torres"> <meta name="DC.Creator" content="Deepak Tayade"> <meta name="DC.Creator" content="Erick Mendoza"> <meta name="DC.Creator" content="Gareth Chapman"> <meta name="DC.Creator" content="Girdhari Ghantiyala"> <meta name="DC.Creator" content="Guldeep Sahu"> <meta name="DC.Creator" content="Hairong Qin"> <meta name="DC.Creator" content="Harish Rajora"> <meta name="DC.Creator" content="Itzel Velazquez"> <meta name="DC.Creator" content="Jorge Flores"> <meta name="DC.Creator" content="Jose Tovany"> <meta name="DC.Creator" content="Juan Carlos Perez Castellanos"> <meta name="DC.Creator" content="Juan Manuel Sanchez"> <meta name="DC.Creator" content="Juigil Kishore"> <meta name="DC.Creator" content="Kamakshi Sethi"> <meta name="DC.Creator" content="Kavitha Dhanasekar"> <meta name="DC.Creator" content="Leela Kumaraswamy Lakkana"> <meta name="DC.Creator" content="Luis Rocholl"> <meta name="DC.Creator" content="Luis Trujillo"> <meta name="DC.Creator" content="Macharapu Prasanth"> <meta name="DC.Creator" content="Manuel Antonio Garcia Chang"> <meta name="DC.Creator" content="Maximiliano Catalan"> <meta name="DC.Creator" content="Nikhil Nischal"> <meta name="DC.Creator" content="Nishith Khandelwal"> <meta name="DC.Creator" content="Pallavi Kamath"> <meta name="DC.Creator" content="Pedro Cornejo"> <meta name="DC.Creator" content="Pradeep Ganesh Bhandarkar"> <meta name="DC.Creator" content="Praveen Kumar"> <meta name="DC.Creator" content="Rajeev Chaurasia"> <meta name="DC.Creator" content="Ravi Ranjan"> <meta name="DC.Creator" content="Raziel Zavaleta"> <meta name="DC.Creator" content="Refugio Cornejo"> <meta name="DC.Creator" content="Rishabh Vishwakarma"> <meta name="DC.Creator" content="Rohit Juyal"> <meta name="DC.Creator" content="Sarahi Partida"> <meta name="DC.Creator" content="Shirdivas Dharmabhotla"> <meta name="DC.Creator" content="Srishti Bhatia"> <meta name="DC.Creator" content="Thomas Herter"> <meta name="DC.Creator" content="Troy Anthony"> <meta name="DC.Creator" content="Vaishakha R"> <meta name="DC.Creator" content="Vern Wagman"> <meta name="DC.Creator" content="Wataru Miyoshi"> <meta name="DC.Creator" content="Nirmal Kumar"> <meta name="DC.Publisher" content="February2025"> <meta name="DC.Format" content="XHTML"> <meta name="DC.Identifier" content="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB"> <meta name="DC.Language" content="en-US"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="abstract" content="Use the ahf analysis command to generate AHF Insights and AHF Balance reports."> <meta name="description" content="Use the ahf analysis command to generate AHF Insights and AHF Balance reports."> <title>ahf analysis</title> <meta property="og:site_name" content="Oracle Help Center"> <meta property="og:title" content> <meta property="og:description" content="Use the ahf analysis command to generate AHF Insights and AHF Balance reports."> <link rel="stylesheet" href="/sp_common/book-template/ohc-book-template/css/book.css"> <link rel="shortcut icon" href="/sp_common/book-template/ohc-common/img/favicon.ico"> <meta name="application-name" content> <meta name="generator" content="DITA Open Toolkit version 1.8.5 (Mode = doc)"> <meta name="plugin" content="SP_docbuilder HTML plugin release 18.2.2"> <link rel="alternate" href="oracle-autonomous-health-framework-users-guide.pdf" title="PDF File" type="application/pdf"> <link rel="schema.dcterms" href="http://purl.org/dc/terms/"> <meta name="dcterms.created" content="2025-02-14T18:35:43-08:00"> <meta name="dcterms.dateCopyrighted" content="2016, 2025"> <meta name="dcterms.category" content="engineered-systems"> <meta name="dcterms.identifier" content="F19065-79"> <meta name="dcterms.product" content="en/engineered-systems/health-diagnostics/autonomous-health-framework"> <link rel="prev" href="ahf-insights-home.html" title="Previous" type="text/html"> <link rel="next" href="ahf-scope.html" title="Next" type="text/html"> <script> document.write('<style type="text/css">'); document.write('body > .noscript, body > .noscript ~ * { visibility: hidden; }'); document.write('</style>'); </script> <script data-main="/sp_common/book-template/ohc-book-template/js/book-config" src="/sp_common/book-template/requirejs/require.js"></script> <script> if (window.require === undefined) { document.write('<script data-main="sp_common/book-template/ohc-book-template/js/book-config" src="sp_common/book-template/requirejs/require.js"><\/script>'); document.write('<link href="sp_common/book-template/ohc-book-template/css/book.css" rel="stylesheet"/>'); } </script> <script type="application/json" id="ssot-metadata">{"primary":{"category":{"short_name":"engineered-systems","element_name":"Engineered Systems","display_in_url":true},"suite":{"short_name":"not-applicable","element_name":"Not Applicable","display_in_url":false},"product_group":{"short_name":"health-diagnostics","element_name":"Health Diagnostics","display_in_url":true},"product":{"short_name":"autonomous-health-framework","element_name":"Autonomous Health Framework","display_in_url":true},"release":{"short_name":"latest","element_name":"Latest Release","display_in_url":false}}}</script> <meta name="dcterms.title" content="Oracle Autonomous Health Framework User's Guide"> <meta name="dcterms.isVersionOf" content="AHFUG"> <meta name="dcterms.release" content="Latest Release"> <script type="application/ld+json"> {"@context":"https://schema.org","@type":"WebPage","name":"ahf analysis","description":"Use the ahf analysis command to generate AHF Insights and AHF Balance reports.","datePublished":"2019-10-17 CST","dateModified":"2025-02-14 CST"} </script> <script>window.ohcglobal || document.write('<script src="/en/dcommon/js/global.js">\x3C/script>')</script></head> <body> <div class="noscript alert alert-danger text-center" role="alert"> <a href="ahf-insights-home.html" class="pull-left"><span class="glyphicon glyphicon-chevron-left" aria-hidden="true"></span>Previous</a> <a href="ahf-scope.html" class="pull-right">Next<span class="glyphicon glyphicon-chevron-right" aria-hidden="true"></span></a> <span class="fa fa-exclamation-triangle" aria-hidden="true"></span> JavaScript must be enabled to correctly display this content </div> <article> <header> <ol class="breadcrumb" vocab="http://schema.org/" typeof="BreadcrumbList"> <li property="itemListElement" typeof="ListItem"><a href="index.html" property="item" typeof="WebPage"><span property="name"></span></a></li> <li property="itemListElement" typeof="ListItem"><a href="ahf-insights.html" property="item" typeof="WebPage"><span property="name">Explore Diagnostic Insights</span></a></li> <li class="active" property="itemListElement" typeof="ListItem">ahf analysis</li> </ol> <a id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB" name="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB"></a> <h2 id="AHFUG-GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB" class="sect2"><span class="enumeration_section">5.3 </span>ahf analysis </h2> </header> <div class="ind"> <div> <p>Use the <code class="codeph">ahf analysis</code> command to generate AHF Insights and AHF Balance reports. </p> <div class="section"> <p class="subhead1" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-8698B116-3C15-4A36-816E-2ED8FB4C39F5">AHF 24.11</p> <p>AHF Balance now allows limiting the number of databases included in performance tuning recommendations. This makes it easier to implement gradual configuration changes to enhance performance without overwhelming change management processes.</p> <p><span class="bold">AI-Driven Tuning with AHF Balance</span></p> <p>AHF Balance uses AI to provide tuning recommendations for database <code class="codeph">CPU_COUNT</code>. Database Administrators (DBAs), Cluster Administrators, and Fleet Administrators can leverage these recommendations to optimize database performance while maximizing hardware utilization. </p> <p><span class="bold">Enhanced Flexibility for Tuning Recommendations</span></p> <p>Previously, AHF Balance considered all databases within a cluster as candidates for <code class="codeph">CPU_COUNT</code> adjustments. This often led to recommendations for modifying <code class="codeph">CPU_COUNT</code> on 50 or more databases, posing challenges for implementing such extensive changes simultaneously. </p> <p>With the new <code class="codeph">--limit-db-changes</code> option, AHF Balance enables incremental performance improvement by capping the number of databases included in tuning recommendations. This allows administrators to make changes in manageable stages through successive iterations of tuning. </p> <div class="infoboxnote" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-C2F230D6-9EF4-41A8-951C-21374D205A45"> <p class="notep1">Note:</p>Before running the <code class="codeph">ahf analysis</code> command with the <code class="codeph">--type impact</code> option, ensure that you first run the configuration command: <code class="codeph">ahf configuration set --type impact --user-name <span class="variable" translate="no">USER_NAME</span> --connect-string <span class="variable" translate="no">CONNECT-STRING</span></code><p>This step is necessary to set up the required connection details before performing the analysis.</p> </div> <div class="p"><span class="bold">Command Usage Examples</span><ul style="list-style-type: disc;" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__UL_DPQ_YCR_LDC"> <li>Fleet Analysis: <div class="p">To perform an analysis for a fleet and limit the number of database changes across clusters, use:<pre class="pre codeblock"><code>ahf analysis create --type impact --scope fleet --name <<span class="variable" translate="no">fleet-name</span>> --limit-db-changes <<span class="variable" translate="no">positive-integer-number-of-databases</span>></code></pre></div> </li> <li>Cluster Analysis: <div class="p">To perform an analysis for a specific cluster and limit the number of database changes, use:<pre class="pre codeblock"><code>ahf analysis create --type impact --scope cluster --name <<span class="variable" translate="no">cluster-name</span>> --limit-db-changes <<span class="variable" translate="no">positive-integer-number-of-databases</span>></code></pre></div> </li> <li>Database Analysis within a Cluster: <div class="p">To perform an analysis for a specific database within a cluster, use:<pre class="pre codeblock"><code>ahf analysis create --type impact --scope database --name <db-name> --cluster <<span class="variable" translate="no">cluster-name</span>> --limit-db-changes <<span class="variable" translate="no">positive-integer-number-of-databases</span>></code></pre></div> </li> </ul> </div> <p>By limiting database changes, AHF Balance provides a more controlled and efficient approach to performance tuning, ensuring smoother implementation and improved results.</p> </div>  <div class="section"> <p class="subhead1" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-5D28C05F-E849-48E1-B38D-D6BA96A6671C">AHF 23.8</p> <p>Starting in AHF 23.8, you will be able to upload AHF Insights report automatically if Object Store is configured as part of AHF. Uploading AHF Insights reports helps Oracle Cloud Operations to identify, investigate, track, and resolve system health issues and divergences in best practice configurations quickly and effectively.</p> <p><span class="bold">Oracle Autonomous Database on Dedicated Exadata Infrastructure and Oracle SaaS</span></p> <div class="p">To set REST endpoints (Object Store's), run:<pre class="nocopybutton"><code>ahfctl setupload -name oss -type https -user <<span class="variable" translate="no">user</span>> -url <<span class="variable" translate="no">object_store</span>> -password</code></pre></div> <div class="p">To upload AHF Insights report to Object Store, run: <pre class="pre codeblock"><code>ahf analysis create --type insights</code></pre>.</div> </div>  <div class="section"> <p class="subhead1" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-065D5A3B-E04C-40AC-B064-71D941DB55E9">ahf analysis create</p> <pre class="pre codeblock"><code>ahf analysis create [-h] [--type {insights|impact}] [[--last n{m|h} [--refresh] | --for DATETIME | --from DATETIME --to DATETIME] [--tag TAGNAME] | [--scope SCOPE --name NAME --cluster CLUSTER --clusters CLUSTER_LIST]][--output-file PATH] [--to-json]</code></pre> </div>  <div class="section"> <p class="subhead1" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-618BD94E-E22E-42DA-A304-F416228C9D4F">Syntax: AHF Balance</p> <div class="p"> <pre class="pre codeblock"><code>ahf analysis create [-h] --type impact --scope [fleet|cluster|database] [--cluster <span class="variable" translate="no">CLUSTER_NAME</span>] [--clusters <span class="variable" translate="no">space-delimited list of clusters</span> ] [--em-group] --name <span class="variable" translate="no">NAME</span></code></pre> </div> </div>  <div class="section"> <p class="subhead1" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-44246D6E-C946-4920-A3FD-6504813F0F22">Parameters</p> <div class="tblformal" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-0C7570C2-EE5B-42B7-BA6C-FA57CE9A2F97"> <p class="titleintable">Table 5-1 ahf analysis create --type impact Command Parameters</p> <table cellpadding="4" cellspacing="0" class="Formal" title="ahf analysis create --type
 impact Command Parameters" summary="This table lists and describes ahf analysis create --type impact
 command parameters." width="100%" frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" width="20%" id="d99533e311">Parameter</th> <th align="left" valign="bottom" width="20%" id="d99533e313">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e317" headers="d99533e311 "> <p><code class="codeph">-h</code>, <code class="codeph">--help</code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e317 d99533e313 "> <p>Show this help and exit.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e332" headers="d99533e311 "> <p><code class="codeph">--type impact</code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e332 d99533e313 ">Specify the type of report to generate.</td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e341" headers="d99533e311 "> <p><code class="codeph">--scope</code> [<code class="codeph">fleet</code>|<code class="codeph">cluster</code>|<code class="codeph">database</code>] </p> </td> <td align="left" valign="top" width="20%" headers="d99533e341 d99533e313 "> <p>Specify to generate AHF Balance reports - Fleet Report, Cluster Report, and Database Report</p> <p>Specify the <code class="codeph">--scope</code> and <code class="codeph">--name</code> options to create an impact analysis. </p> <p>The <code class="codeph">--cluster</code> option is required for database impact analysis. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e378" headers="d99533e311 "> <p><code class="codeph">--output-file <span class="variable" translate="no">PATH</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e378 d99533e313 "> <p>Specify to create output file in the specified location.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e388" headers="d99533e311 "> <p><code class="codeph">--clusters <span class="variable" translate="no">clu1</span> <span class="variable" translate="no">clu2</span> <span class="variable" translate="no">clu3</span> </code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e388 d99533e313 "> <p>Specify a space-delimited list of clusters to include in the fleet scope.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e409" headers="d99533e311 "> <p><code class="codeph">--name <span class="variable" translate="no">NAME</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e409 d99533e313 "> <p>Specify the name of the fleet, EM Group, cluster, or database to report on.</p> <div class="infoboxnote" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-103218B6-1FA3-4779-BA28-6256D92B2406"> <p class="notep1">Note:</p>The name of the fleet can be anything of your choosing, such as '<span class="variable" translate="no">MyFleet</span>'. It is only used to label the report. </div> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e427" headers="d99533e311 "> <p><code class="codeph">--em-group</code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e427 d99533e313 "> <p>Specify the EM group name.</p> <div class="infoboxnote" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-841C3646-EDC4-48BD-9B53-F7F54BBE54DB"> <p class="notep1">Note:</p>This option is mutually exclusive with the <code class="codeph">--clusters</code> option and must be used with the <code class="codeph">--scope fleet</code> option. <div class="p">For example: <pre class="pre codeblock"><code>ahf analysis create --type impact --scope fleet --name <<span class="variable" translate="no">em-group-name</span>> --em-group</code></pre></div> </div> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e450" headers="d99533e311 "> <p><code class="codeph">--user-name <span class="variable" translate="no">USER_NAME</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e450 d99533e313 "> <p>Specify the Oracle Enterprise Manager Repository user name.</p> <div class="infoboxnote" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-476B77D8-4E48-4E9F-A481-07F69E0F90EF"> <p class="notep1">Note:</p>Not required if AHF Balance has been configured. For more information, see <a href="ahf-configuration.html#GUID-CEC167D0-3187-49F9-8BBC-56E66EFAA486" title="Use the ahf configuration command to change AHF configuration.">ahf configuration</a>. </div> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e471" headers="d99533e311 "> <p><code class="codeph">--connect-string <span class="variable" translate="no">CONNECT_STRING</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e471 d99533e313 "> <p>Specify the connect string for the Oracle Enterprise Manager Repository.</p> <div class="infoboxnote" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-4DE8DE5F-30AB-4C45-AA63-305442D021C2"> <p class="notep1">Note:</p>Not required if AHF Balance has been configured. For more information, see <a href="ahf-configuration.html#GUID-CEC167D0-3187-49F9-8BBC-56E66EFAA486" title="Use the ahf configuration command to change AHF configuration.">ahf configuration</a>. </div> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e492" headers="d99533e311 "> <p><code class="codeph">--limit-db-changes <span class="variable" translate="no">DB_CHANGE_LIMIT</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e492 d99533e313 "> <p>Limits the number of database changes recommended.</p> </td> </tr> </tbody> </table> </div>  </div>  <div class="section"> <p class="subhead1" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-C561BFC8-9066-4D57-B6D0-A74804EA6BB2">Syntax: AHF Insights</p> <div class="p"> <pre class="pre codeblock"><code>ahf analysis create [-h] --type insights [--last <span class="variable" translate="no">n</span>{<span class="variable" translate="no">m</span>|<span class="variable" translate="no">h</span>} | --for <span class="variable" translate="no">DATETIME</span> | --from <span class="variable" translate="no">DATETIME</span> --to <span class="variable" translate="no">DATETIME</span>] [--refresh] [--tag <span class="variable" translate="no">TAGNAME</span> ]</code></pre> </div> </div>  <div class="section"> <p class="subhead1" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-F51CC422-1D84-4490-93AC-D467575EB989">Parameters</p> <div class="tblformal" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__TABLE_D3S_SCG_BXB"> <p class="titleintable">Table 5-2 ahf analysis create --type insights Command Parameters</p> <table cellpadding="4" cellspacing="0" class="Formal" title="ahf analysis create --type
 insights Command Parameters" summary="This table lists and describes ahf analysis create --type
 insights command parameters." width="100%" frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" width="20%" id="d99533e550">Parameter</th> <th align="left" valign="bottom" width="20%" id="d99533e552">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e556" headers="d99533e550 "> <p><code class="codeph">-h</code>, <code class="codeph">--help</code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e556 d99533e552 "> <p>Show this help and exit.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e571" headers="d99533e550 "> <p><code class="codeph">--type insights</code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e571 d99533e552 ">Specify the type of report to generate.</td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e580" headers="d99533e550 "> <p><code class="codeph">--last <span class="variable" translate="no">n</span>{<span class="variable" translate="no">m</span>|<span class="variable" translate="no">h</span>}</code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e580 d99533e552 "> <p>Specify the <code class="codeph">--last</code> parameter to analyze data for the past number of minutes (m) or hours (h). </p> <p><code class="codeph">--last</code> cannot be greater than 12 hours. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e609" headers="d99533e550 "> <p><code class="codeph">--for <<span class="variable" translate="no">DATETIME</span>></code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e609 d99533e552 "> <p>Specify the <code class="codeph">--for</code> parameter to analyze data for a 2 hour period before and after the timestamp specified. </p> <div class="p">Supported time formats:<pre class="pre codeblock"><code>"YYYY-MM-DDTHH:MM:SS"</code></pre><pre class="pre codeblock"><code>"YYYY-MM-DD HH:MM:SS"</code></pre></div> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e634" headers="d99533e550 "> <p><code class="codeph">--from <<span class="variable" translate="no">DATETIME</span>></code></p> <p><code class="codeph">--to <<span class="variable" translate="no">DATETIME</span>></code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e634 d99533e552 "> <p>Specify the <code class="codeph">--from</code> and <code class="codeph">--to</code> parameters (you must use these two parameters together) to analyze data for a specific time interval. </p> <div class="p">Supported time formats:<pre class="pre codeblock"><code>"YYYY-MM-DDTHH:MM:SS"</code></pre><pre class="pre codeblock"><code>"YYYY-MM-DD HH:MM:SS"</code></pre><pre class="pre codeblock"><code>"YYYY-MM-DD"</code></pre></div> <p>Time difference between from and to time should not be more than 4 hours.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e674" headers="d99533e550 "> <p><code class="codeph">--refresh</code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e674 d99533e552 "> <p>Provides fresh data from AHF Insights sources.</p> <p>Specify <code class="codeph">--refresh</code> alone or together with <code class="codeph">--last</code> to provide fresh data from AHF Insights sources. </p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e695" headers="d99533e550 "> <p><code class="codeph">--include-cell-data</code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e695 d99533e552 "> <p>Specify to include data from cell into AHF Insights sources.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e703" headers="d99533e550 "> <p><code class="codeph">--tag <span class="variable" translate="no">TAGNAME</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e703 d99533e552 "> <p>Specify to collect the files into the <span class="variable" translate="no">TAGNAME</span> directory inside the repository. </p> </td> </tr> </tbody> </table> </div>  </div>  <div class="section"> <p class="subhead1" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-3C6FDEAF-FB17-4AEC-BE02-750228828693">Syntax: ahf analysis explore</p> <pre class="pre codeblock"><code>ahf analysis explore [-h] [--with scope] [--from-file <span class="variable" translate="no">FILE</span>]</code></pre><div class="infoboxnote" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-67FA7F6E-2AF4-475C-8720-F60C647FF970"> <p class="notep1">Note:</p>Starting with Oracle Database 23ai, the ahf <code class="codeph">analysis explore --with scope</code> command is desupported. For more information on GIMR, refer to <a href="ahf-scope.html#GUID-F48197CE-80FE-4CB1-A512-FD6D4C5AECB6" title="Autonomous Health Framework Scope (AHF Scope) is a standalone, interactive, real-time capable front-end to Cluster Health Advisor (CHA). AHF Scope requires a very small foot-print on the monitored system.">Analyze Issue Root Cause</a>. </div> </div>  <div class="section"> <p class="subhead1" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-B55E99DC-A6C5-4880-BAD0-B7E0D4BE9398">Parameters</p> <div class="tblformal" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__TABLE_ATG_F2G_BXB"> <p class="titleintable">Table 5-3 ahf analysis explore Command Parameters</p> <table cellpadding="4" cellspacing="0" class="Formal" title="ahf analysis explore Command Parameters" summary="This table lists and describes ahf analysis explore command
 parameters." width="100%" frame="hsides" border="1" rules="rows"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" width="20%" id="d99533e752">Parameter</th> <th align="left" valign="bottom" width="20%" id="d99533e754">Description</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e758" headers="d99533e752 "> <p><code class="codeph">-h</code>, <code class="codeph">--help</code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e758 d99533e754 "> <p>Show this help and exit.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" valign="top" width="20%" id="d99533e773" headers="d99533e752 "> <p><code class="codeph">--from-file <span class="variable" translate="no">FILE</span></code></p> </td> <td align="left" valign="top" width="20%" headers="d99533e773 d99533e754 "> <p>Specify to read from a file.</p> <p>If you do not specify the file extension, then AHF Scope assumes <code>.mdb</code> as the file extension. </p> </td> </tr> </tbody> </table> </div>  </div>  <div class="example" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-7BDA2C7A-1AB0-478D-9A35-C9194C223D05"> <p class="titleinexample">Example 5-2 AHF Insights Analysis Usage Examples</p> <p>Specify <code class="codeph">[--last | --for | --from --to]</code> to create an analysis for a given period of time. Maximum time interval allowed is 4 hrs. </p> <p>Specify <code class="codeph">[--refresh]</code> alone or together with <code class="codeph">[--last]</code> to provide fresh data from AHF Insights sources. </p> <ul style="list-style-type: disc;" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__UL_NYQ_VHQ_JVB"> <li>Create analysis report from the data collected in the last 3 hours:<pre class="pre codeblock"><code>ahf analysis create --type insights --last 3h</code></pre></li> <li>Create analysis for a 2-hour period centered at the specified timestamp:<pre class="pre codeblock"><code>ahf analysis create --type insights --for 2022-10-10T14:00:00</code></pre></li> <li>Create analysis for a given time range:<pre class="pre codeblock"><code>ahf analysis create --type insights --from 2022-10-10T14:00:00 --to 2022-10-10T15:30:00</code></pre></li> <li>Create analysis specifying a timezone:<pre class="pre codeblock"><code>ahf analysis create --type insights --from 2022-10-10T14:00:00 --to 2022-10-11T13:30:00</code></pre></li> <li>Create analysis with most recent data:<pre class="pre codeblock"><code>ahf analysis create --type insights --refresh</code></pre></li> <li>Create analysis with a tag:<pre class="pre codeblock"><code>ahf analysis create --type insights --tag <span class="variable" translate="no">my_tag</span></code></pre></li> </ul> </div>  <div class="example" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__GUID-6D218004-14B7-4460-A189-6C2D4AF15245"> <p class="titleinexample">Example 5-3 AHF Balance Usage Examples</p> <p>Specify <code class="codeph">[--scope]</code> and <code class="codeph">[--name]</code> options to create an impact analysis. </p> <p>The <code class="codeph">[--cluster]</code> option is required for database impact analysis. </p> <ul style="list-style-type: disc;" id="GUID-BCF33A7E-E4E1-497B-96F0-3AA298BDEBDB__UL_D4S_GNP_NVB"> <li>Create analysis for a fleet (all clusters):<pre class="pre codeblock"><code>ahf analysis create --type impact --scope fleet --name fleet1</code></pre></li> <li>Create analysis for a fleet (cluster list):<pre class="pre codeblock"><code>ahf analysis create --type impact --scope fleet --name fleet1 --clusters clu1 clu2 clu3</code></pre></li> <li>Create analysis for a cluster:<pre class="pre codeblock"><code>ahf analysis create --type impact --scope cluster --name cluster1</code></pre></li> <li>Create analysis for a database:<pre class="pre codeblock"><code>ahf analysis create --type impact --scope database --cluster cluster1 --name database1</code></pre></li> <li>Create analysis specifying the output directory:<pre class="pre codeblock"><code>ahf analysis create --type impact --scope fleet --name fleet1 --output-file /custom_path/custom_name.html</code></pre></li> <li>Create analysis specifying EM repository user name and password:<pre class="pre codeblock"><code>ahf analysis create --type impact --scope fleet --name fleet1 --user-name oracle --connect-string <<span class="variable" translate="no">cs</span>></code></pre></li> </ul> </div>  </div> <div> <div class="familylinks"> <div class="parentlink"> <p><strong>Parent topic:</strong> <a href="ahf-insights.html#GUID-CA1ED11D-E14B-4AF6-8D55-29D7F84D5736" title="Autonomous Health Framework Insights (AHF Insights) provides deeper diagnostic insights into Oracle diagnostic collections collected by AHF diagnostic utilities, Oracle Exachk, Oracle Trace File Analyzer, Exawatcher, and Cluster Health Monitor.">Explore Diagnostic Insights</a></p> </div> </div> </div> </div> </article> </body> </html>

CINXE.COM

ahf analysis