Oracle Transactional Business Intelligence

Products Banner

OTBI Usage and Performance Dashboard Sample


Real Time OTBI Usage & Performance

  • Two subject areas are available to monitor OTBI usage and performance:
    • OTBI Usage Real Time: Monitors OTBI usage, including user, analysis and dashboard, and subject area usage trends.
    • OTBI Performance Real Time: Monitors usage trends and OTBI analysis execution time, execution errors, and database physical SQL execution statistics.
  • Captures OTBI Query execution data including ad-hoc queries, saved analyses and dashboards
  • Six months of OTBI execution data is available.
  • Data older than six months is purged weekly.
  • Subject areas are secured by duty roles. There’s no data security.
  • Does not contain BI Catalog change audit data. This feature is planned for a future release.

For more detailed information, please refer to the OTBI Documentation


Using the content

Attached are two catalog files containing sample dashboard, analysis and filters to demonstrate the new subject areas. 

  1. Download the zip file and extract the 2 catalog files.
  2. With a user who has Unarchive permissions, unarchive the files in the following order to Shared Folders/Custom.
    1. _filters OTBI_Usage.catalog
    2. OTBI Usage Dashboard.catalog