Oracle Database usage report details

Overview - Total number of devices and databases

  • Database by version - Total database count by version
  • Editions Overview - Total database count by edition
  • Running Options Graph - Total Usage per Running Option
  • Oracle Databases Installed - Databases installed on which device with their:
    • Version
    • Edition
    • Instance status
    • Application status
    • Environment
    • Source
  • Oracle Options Matrix - Options status per device or database, status' include:
    • Used
    • Not Used
    • Verify - flagged for manual verification
    • Cloned - cloned from a previous database, worth investigation if required
    • Historical - evidence of historical usage, worth investigation if required
  • Options Analysis - Analysis steps and detail on the above Options Matrix showing:
    • First and Last usage date
    • Additional status levels e.g. verify + historical usage detected
    • Analysis summary showing a high level the steps conducted in the analysis
    • Detailed analysis showing in detail the steps conducted in the analysis
  • Options Usage Evidence - Surfacing of the evidence found for the concluded Option usage as per the analysis steps:
    • Option in question and which device
    • Feature name, detail and usage status
    • File name analysed
    • Licensing notes - Why it requires licensing
    • Evidence - logs showing the exact evidence in the data analysed - great for resolving disputes.