Search Results bne_perf_statistics_h




Overview
Explore in AI Chat

Overview

The BNE_PERF_STATISTICS_H table is a core data object within the Web Applications Desktop Integrator (BNE) product family of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It functions as a historical repository for performance statistic measurements generated by the BNE framework. This table is critical for performance monitoring and analysis, enabling administrators and developers to track the efficiency and execution characteristics of desktop integrator components over time. By storing historical performance data separately, it facilitates trend analysis and long-term performance auditing without cluttering the primary statistics table.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure is defined by its primary and foreign keys. The primary key, SEQUENCE_NUM, uniquely identifies each historical performance record, typically serving as a surrogate key for the row. A critical foreign key column is STATISTIC_CODE, which links each historical measurement entry to its corresponding definition in the BNE_PERF_STATISTICS_B table. This relationship implies that the table stores specific measurement values, timestamps, and contextual identifiers (such as USER_ID, CONCURRENT_REQUEST_ID, or INTERFACE_APPLICATION_ID) associated with the STATISTIC_CODE at the moment the historical snapshot was taken. The "H" suffix in the table name conventionally denotes it as a history table.

Common Use Cases and Queries

The primary use case is analyzing performance trends for BNE operations. Administrators can query this table to identify degradation in integration process times, monitor user activity peaks, or audit the performance impact of system changes. A common query pattern involves joining with the base statistics table to get descriptive names for the metrics being analyzed.

Sample Query Pattern:
SELECT h.SEQUENCE_NUM, b.STATISTIC_NAME, h.MEASUREMENT_VALUE, h.CREATION_DATE
FROM BNE_PERF_STATISTICS_H h,
BNE_PERF_STATISTICS_B b
WHERE h.STATISTIC_CODE = b.STATISTIC_CODE
AND b.STATISTIC_NAME LIKE '%PROCESS_TIME%'
AND h.CREATION_DATE > SYSDATE - 30
ORDER BY h.CREATION_DATE DESC;

This data is essential for generating custom performance dashboards or feeding into enterprise monitoring tools to track the health of desktop integration processes.

Related Objects

The table maintains a direct and documented foreign key relationship with another core BNE table, as per the provided metadata:

  • BNE_PERF_STATISTICS_B (Base Table): This is the primary related object. The BNE_PERF_STATISTICS_H table references it via the STATISTIC_CODE column (BNE_PERF_STATISTICS_H.STATISTIC_CODE → BNE_PERF_STATISTICS_B). This relationship ensures that every historical performance record is tied to a valid, defined statistic, providing context and meaning to the stored measurement data. The BNE_PERF_STATISTICS_B table likely contains the master definition of the statistic, including its name, category, and description.