Results for “avg_mem”
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.
- STATISTICS_ID — The surrogate primary key, enforced by JTF_PREFAB_STATISTICS_PK and additionally by the unique index JTF_PREFAB_STATISTICS_U1. It uniquely identifies each statistics record.
- POLICY_ID — Foreign key to JTF_PREFAB_POLICIES_B, identifying the prefabrication policy under which the run was executed. Together with WSH_PO_ID it is a business-key candidate (JTF_PREFAB_STATISTICS_U2).
- WSH_PO_ID — Foreign key to JTF_PREFAB_WSH_POES_B, identifying the associated prefabrication order.
- START_TIME and END_TIME — The execution window of the prefabrication run, enabling duration and throughput analysis.
- LAST_UPDATE_TIME — Timestamp of the most recent statistics refresh.
- PAGES_LAST_RUN and PAGES_CRAWLED — Counts of pages processed in the latest run and cumulative pages crawled, supporting coverage reporting.
- REFRESH_RATE — The configured or observed refresh cadence for the prefabricated content.
- SYSTEM_STATUS and ERROR_STATUS — Status indicators for the run and for any errors encountered, used in exception and health reporting.
- DEPTH — The crawl or traversal depth applied during prefabrication.
- DISK_USED, AVG_MEM, and AVG_CPU — Resource consumption metrics for disk, average memory, and average CPU utilization.
- HIT_RATE — The cache hit ratio achieved, a primary measure of prefabrication benefit.
- SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org / data-security partitioning.
- Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and OBJECT_VERSION_NUMBER — provide audit and optimistic-locking support.
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, andHIT_RATEoverSTART_TIMEto assess crawl coverage and caching effectiveness. - Resource capacity reviews aggregating
DISK_USED,AVG_MEM, andAVG_CPUbyPOLICY_ID. - Housekeeping extracts correlating
ERROR_STATUSwithWSH_PO_IDto 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.
-
JTF_PREFAB_STATISTICS stores the statistics information of Prefabrication.
-
JTF_PREFAB_STATISTICS stores the statistics information of Prefabrication.
-
eTRM - JTF Tables and Views 12.2.2
Interface table to store data that needs to be displayed in Excel
-
eTRM - JTF Tables and Views 12.1.1
Interface table to store data that needs to be displayed in Excel