Search Results bne_perf_statistics_b




Overview
Explore in AI Chat

Overview

The BNE_PERF_STATISTICS_B table is a core data definition table within the Web Applications Desktop Integrator (BNE) product of Oracle E-Business Suite. It serves as the master repository for defining distinct performance statistic types that can be monitored and collected. Its primary role is to provide a reference model for performance metrics, enabling the system to categorize and store historical performance data consistently. This table acts as the parent definition for actual performance measurements captured elsewhere in the system, forming a critical component of the performance monitoring infrastructure for desktop integrator operations.

Key Information Stored

While the provided metadata does not list specific column details beyond the primary key, the table's purpose and structure can be inferred. The central column is STATISTIC_CODE, which serves as the unique identifier (Primary Key: BNE_PERF_STATISTICS_B_PK) for each defined performance statistic. Typical columns in such a definition table would include a descriptive name, a measurement unit (e.g., milliseconds, count, percentage), and potentially an indicator for the statistic's category or collection method. The table stores the metadata about what is being measured—such as transaction processing time, data upload duration, or error count—rather than the actual measured values themselves.

Common Use Cases and Queries

This table is primarily accessed for administrative setup, reporting configuration, and analytical queries. Common use cases involve generating master lists of available statistics for performance dashboard setups or validating statistic codes before inserting historical data. A typical analytical query would join this table with its related history table to produce a report pairing statistic definitions with their collected values.

Sample Query:
SELECT ps.STATISTIC_CODE, ps.STATISTIC_NAME, h.STATISTIC_VALUE, h.CREATION_DATE
FROM BNE_PERF_STATISTICS_B ps,
BNE_PERF_STATISTICS_H h
WHERE ps.STATISTIC_CODE = h.STATISTIC_CODE
AND h.CREATION_DATE > SYSDATE - 7
ORDER BY ps.STATISTIC_CODE, h.CREATION_DATE DESC;

Related Objects

The BNE_PERF_STATISTICS_B table maintains defined relationships with other key tables in the BNE schema, as documented in the provided metadata.

  • Primary Key Reference: The STATISTIC_CODE column is the primary key for this table (BNE_PERF_STATISTICS_B_PK).
  • Referenced by Foreign Keys:
    • BNE_PERF_STATISTICS_H: This history table stores the actual recorded values for each statistic. It references BNE_PERF_STATISTICS_B via the foreign key column BNE_PERF_STATISTICS_H.STATISTIC_CODE.
    • BNE_PERF_SET_ITEMS: This table references BNE_PERF_STATISTICS_B via BNE_PERF_SET_ITEMS.STATISTIC_CODE, indicating it is used to group or assign statistics into specific performance sets or monitoring profiles.