Results for “avg_cpu”

12 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_PREFAB_STATISTICS is a table in the JTF (CRM Foundation) schema of Oracle E-Business Suite, present in both the 12.1.1 and 12.2.2 releases. It stores statistical information relating to the Prefabrication framework, a CRM Foundation component used to assemble, stage, and pre-render frequently accessed content and page structures. The table captures runtime measurements generated as prefabrication jobs are executed against one or more prefabrication policies, providing the operational history that administrators and performance tuners rely on to evaluate caching effectiveness and resource consumption.

From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying this object as a link. It joins two principal business entities — a prefabrication policy and a Workflow Shipping (WSH) prefabrication order entry — through the POLICY_ID and WSH_PO_ID columns, which together form the JTF_PREFAB_STATISTICS_U2 unique index. This heuristic classification indicates the table is best understood as a relationship record with associated descriptive metrics rather than as a standalone reference or a pure transactional event.

Key Information Stored

The table's physical schema comprises 23 columns. The most significant are summarized below.

Common Use Cases and Queries

Typical use cases include monitoring prefabrication performance, diagnosing elevated error rates, and validating cache hit efficiency before and after policy changes. A representative query joining policy and order context is:

  • SELECT s.STATISTICS_ID, p.POLICY_NAME, s.START_TIME, s.END_TIME, s.HIT_RATE, s.DISK_USED, s.AVG_CPU FROM JTF.JTF_PREFAB_STATISTICS s, JTF.JTF_PREFAB_POLICIES_B p WHERE s.POLICY_ID = p.POLICY_ID AND s.SYSTEM_STATUS = 'ERROR';
  • Trend reporting on PAGES_CRAWLED, REFRESH_RATE, and HIT_RATE over START_TIME to assess crawl coverage and caching effectiveness.
  • Resource capacity reviews aggregating DISK_USED, AVG_MEM, and AVG_CPU by POLICY_ID.
  • Housekeeping extracts correlating ERROR_STATUS with WSH_PO_ID to trace failed prefabrication orders back to their order entries.

Related Objects

The most significant related objects are those tied to this table through its documented foreign keys:

  • JTF_PREFAB_POLICIES_B — referenced via POLICY_ID; the policy definition driving each prefabrication run.
  • JTF_PREFAB_WSH_POES_B — referenced via WSH_PO_ID; the prefabrication order entry associated with the statistics record.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; governs data-security partitioning of statistics rows.
  • JTF_PREFAB_POLICIES_TL — the translated policy entity joined through the base table's POLICY_ID to obtain user-facing policy names.
  • JTF_PREFAB_STATISTICS_PK / _U1 / _U2 — the primary key and unique indexes constraining this table.

Because the object is internal to the CRM Foundation prefabrication framework, direct DML is generally discouraged; consumers should treat it as a read-only reporting source and rely on the prefabrication administration flows to populate it.