Streaming
A streaming service is a digital platform that delivers audio, video, or live content over the internet so users can watch or listen in real time or on demand—without downloading the full file first. This Streaming subject area enables tracking streaming, streaming pools, and their details.
Business Questions
The subject area can answer the following business questions:
- What are the partitions?
- What's the retention in hours?
- What's the streaming stream count?
- What's the streaming stream count by compartment name / tenancy / region?
- How has the number of Streaming stream counts changed over time (monthly)?
Logical Model
The Streaming subject area is based on a relationship-driven logical model.
This diagram shows how the Streaming fact table is related to its dimension tables:

Metric Details
The fact folders in this subject area include the following metrics:
| Metric | Definition |
|---|---|
| Partitions | Provides the number of partitions in the stream |
| Retention In Hours | Provides the retention period of the stream, in hours |
| Streaming Stream Count | COUNT(ocira_fact_key) from the fact view's ocira_fact_key (maps to ocira$fact_key) |