Simulated environment. All schemas, metrics, and run histories are synthetic; no live Oracle instance, credentials, or customer data are used.

Oracle Secure Data Engineering Lab

PL-003 · Operations

Telemetry Rollup

Micro-batch aggregation of fabricated device telemetry into hourly rollups with idempotent re-processing on replay.

healthy
Every 5 minSLA 10 minSimulated event streamDW.AGG_DEVICE_HOURLY
Stage flow
Average stage durations from the simulated run history.
  1. 1

    Batch read extract

    Offset-tracked micro-batch of synthetic events.

    ~9s average

  2. 2

    Windowed aggregate transform

    Hourly grouping with watermark for late events.

    ~26s average

  3. 3

    Idempotent upsert load

    MERGE keyed on (device_id, hour_bucket).

    ~19s average

Recent runs
Synthetic history — not sourced from a live scheduler.
RunStarted (UTC)DurationRows inRows outReject %SLAStatus
R-99022026-08-13 16:55:0051s412,3008,4200%Met
healthy
R-99012026-08-13 16:50:0049s408,1128,3900%Met
healthy
R-99002026-08-13 16:45:0055s419,8878,4600%Met
healthy
← All pipelines