how to generate addm report in oracle 12c


how to generate addm report in oracle 12c  

what is addm?

ADDM stands for Automatic Database Diagnostic Monitor.

what is addm report?

The set of awr snapshots, addmrpt.sql script is used to generate the addm report by analysing an ADDM.

how to generate addm report in oracle 12c

steps to generate addm report







  • Login to Database with privileged user.
  • Run awrrpt.sql from $ORACLE_HOME/rdbms/admin/
  • For input format, type html.
  • type in begin and end snap id.
  • provide report name.


    • &

    what is oracle

    Oracle Database Enterprise includes the Edition of all the software's features. It is designed for use by large organizations running high-volume transaction processing,analytics data warehousing, and internet applications.
    more about oracle

    ICYMI: What you ought to fathom The Oracle stockholder proceeding

    Tech big Oracle Corporation (NYSE: ORCL) nonheritable NetSuite for .3 billion back in 2016, and a recently approved stockholder proceeding accuses company executives of breaching their duties in approving the deal, Reuters reported Monday.

    What Happened
    Oracle co-founder Larry author happened to be AN earlier financier of NetSuite and in hand getting ready to four-hundredth of the corporate.
    Oracle was wanting to extend its exposure to the invasive cloud market in 2016 and viewed NetSuite as a method to create out its cloud business at a quicker pace than if it were to develop a new business line internally.
    One year once the acquisition, the Firemen's Retirement System of St. Louis took action at law against Oracle and argued the $9.3-billion tag may be a vast premium that in person benefited author.
    The legal action took a step forward Aug. 15 once 3 members of Oracle's board approved a "derivative suit" as a part of the Special proceedings Committee. Both author and Oracle business executive Safra Catz area unit in person named within the stockholder proceeding.
    Why It's Important
    The D&P Diary, a blog that focuses on officers and directors liability, said it's not uncommon for boards facing derivative lawsuits to appoint a special litigation committee.
    "These committees typically will either recommend that the claims be dropped or will conclude that the claims have merit and opt to use its own lawyers to pursue the claim."
    In Oracle's case, it's extremely uncommon for the committee to conclude that the action at law ought to proceed with the first stockholder filing the claim taking the lead.
    What's Next
    The Special proceedings Committee additionally expressed in its August. 15 letter it believes a "settlement of the claims would be the simplest result for Oracle."
    It is unclear if a settlement can be reached or when the next step in the legal process will occur.
    Oracle shares were down two.02% at $52.11 at the time of publication Friday.
    Related Links:
    Oracle Loses Legal charm Over B Government Cloud Contract
    Oracle Investors happy With this fall Revenue Beat, however Analysts Sidelined.