In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
As soon as each snapshot is generated, the addm-related background process starts automatically, and an addm report is generated after startup. When there is no problem, there is nothing in the automatically generated addm report.
In em, if the value after ADDM Findings is greater than 0, there is a reminder in the ADDM report.
Home- > Diagnostic Summary- > ADDM Findings (value greater than 0)
The method of generating ADDM comparison report of two SNAP
To manually generate an ADDM during two historically non-adjacent snap_shot, use @? / rdbms/admin/addmrpt.sql
SQL > @? / rdbms/admin/addmrpt.sql
The format of the generated report is txt format by default. If the html suffix name is forced during the generation process, the generated report will be opened in a browser with an unfriendly interface, which is not as good as txt format.
Query the statement of ADDM corresponding to SNAP
Select task_id,task_name,description from dba_advisor_tasks order by 1 desc
Export the latest ADDM report (requires sys users)
Select dbms_advisor.get_task_report (task_name) from dba_advisor_tasks
Where task_id = (
Select max (t.task_id) from dba_advisor_tasks t, dba_advisor_log l where
T.task_id=l.task_id and t.advisorship nameplate ADDM' and l.statussubmission)
Export an ADDM report for a task_id (sys user is required)
Select dbms_advisor.get_task_report (task_name) from dba_advisor_tasks where task_id = XX
Export a report with a task_name name of ADDM:1866763731_1_31374 (sys user required)
Select dbms_advisor.get_task_report ('ADDM:1866763731_1_31374') from dual
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 0
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.