What Sizing Options Are Available to You?

When you create an Oracle Analytics Cloud instance for your production or non-production environment, you either specify the number of Oracle Compute Units (OCPUs) you want to deploy or the number of people you expect to use the service.

How Many OCPUs Do You Think You’ll Need?

Oracle Analytics Cloud offers a range of compute sizes (OCPUs) to suit different scenarios and environments. The larger the compute size, the greater the processing power. If you're not sure which size to use, contact your sales team to discuss sizing guidelines.

The compute size you select also determines some configuration limits for the different types of content that users can create:

  • Data visualizations

  • Classic analyses and dashboards

  • Classic pixel-perfect reports

For example, limits such as the maximum number of input rows you can return from a data source query or the maximum number of rows you can download from a report to a file (for example, when you export to a CSV file).

Limits Querying Data (Data Visualization Workbooks, Classic Analyses and Dashboards)

When you query a data source for visualizations or classic analyses and dashboards, the compute size determines the maximum number of rows that are returned from the data source.

Which compute size do you think you’ll need? Limits when querying data for visualizations, analyses, and dashboards
Max input rows returned from any data source query Query timeout (seconds)

1 OCPU

(non-production only)

125,000

space

660

space

2 OCPU

2,000,000

660

4 OCPU

2,000,000

660

6 OCPU

2,000,000

660

8 OCPU

2,000,000

660

10 OCPU

2,000,000

660

12 OCPU

2,000,000

660

16 OCPU

4,000,000

660

24 OCPU

4,000,000

660

36 OCPU

4,000,000

660

52 OCPU

4,000,000

660

Limits Displaying Data (Data Visualization Workbooks, Classic Analyses and Dashboards)

When you display data in visualizations or classic analyses and dashboards, the compute size determines the maximum number of summarized rows returned from the data source that are displayed.

Which compute size do you think you’ll need? Limits when displaying data in visualizations, analyses, and dashboards
Max summarized rows returned from any data source query

1 OCPU

(non-production only)

125,000

space

2 OCPU

500,000

4 OCPU

500,000

6 OCPU

500,000

8 OCPU

500,000

10 OCPU

500,000

12 OCPU

500,000

16 OCPU

1,000,000

24 OCPU

1,000,000

36 OCPU

1,000,000

52 OCPU

1,000,000

Limits Exporting Data (Data Visualization Workbooks)

When you export data from a data visualization workbook, the compute size determines the maximum number of rows you can export, number of parallel exports, and queue size for incoming export requests. If you regularly exceed export limits, you can scale up to a larger compute size or reduce the number of parallel export requests.

There are different row limits for formatted and unformatted data.

  • Unformatted data limit: Comma Separated Values (CSV)

  • Formatted data limit: Microsoft Excel (XLSX)

*The maximum row limits shown in the table are based on exports that contain up to 40 columns. Additional columns will impact the maximum number of rows you can export.

Note

Data exports are expensive operations and have a direct impact on the overall system performance. The impact on system performance increases with the number of rows and columns that you export. Oracle recommends that you export large amounts of data during non-peak hours to reduce any performance impact.
Which compute size do you think you’ll need? Limits when exporting data from data visualization workbooks
Maximum number of rows exported to CSV* Maximum number of rows exported to Microsoft Excel (XLSX)*

1 OCPU

(non-production only)

125,000

space

25,000

space

2 OCPU

2,000,000

25,000

4 OCPU

2,000,000

25,000

6 OCPU

2,000,000

25,000

8 OCPU

2,000,000

25,000

10 OCPU

2,000,000

25,000

12 OCPU

2,000,000

25,000

16 OCPU

4,000,000

25,000

24 OCPU

4,000,000

25,000

36 OCPU

4,000,000

25,000

52 OCPU

4,000,000

25,000

Limits Exporting Data (Classic Analyses and Dashboards)

When you export data from analyses and dashboards, the compute size determines the maximum number of rows you can export, number of parallel exports, and queue size for incoming export requests. If you regularly exceed export limits, you can scale up to a larger compute size or reduce the number of parallel export requests.

There are different limits for formatted reports and unformatted reports.

  • Unformatted report limits: formats such as CSV, Excel, XML, and Tab Delimited.

  • Formatted report limits: formats such as PDF, Excel, Powerpoint, and Web Archive/HTML.

    When two pivot views are laid out side by side in a union the formatted export limit will be 20,000 rows.

*The maximum row limits shown in the table are based on exports that contain up to 40 columns. Additional columns will impact the maximum number of rows you can export.

Note

Data exports are expensive operations and have a direct impact on the overall system performance. The impact on system performance increases with the number of rows and columns that you export and the output format. Oracle recommends that you export large amounts of data during non-peak hours or export unformatted data to reduce any performance impact.
Which compute size do you think you’ll need? Limits when exporting data from analyses and dashboards
Maximum number of rows exported to unformatted reports* Maximum number of rows exported to formatted reports*

1 OCPU

(non-production only)

125,000

space

1,000

space

2 OCPU

2,000,000

200,000

4 OCPU

2,000,000

200,000

6 OCPU

2,000,000

200,000

8 OCPU

2,000,000

200,000

10 OCPU

2,000,000

200,000

12 OCPU

2,000,000

200,000

16 OCPU

4,000,000

400,000

24 OCPU

4,000,000

400,000

36 OCPU

4,000,000

400,000

52 OCPU

4,000,000

400,000

Limits Delivering by Email (Classic Analyses and Dashboards)

When you send analyses and dashboards by email, the compute size determines the maximum number of rows you can deliver in a single email. There are different limits for delivering formatted reports and unformatted reports.

  • Unformatted report limits: formats such as CSV, XML, and Tab Delimited.

  • Formatted report limits: formats such as PDF, Excel, Powerpoint, and Web Archive/HTML.

Note

Content delivery by email is an expensive operation and has a direct impact on the overall system performance. The impact on system performance increases with the number of recipients, the number of rows and columns that you send, and the delivery format. Oracle recommends that you schedule deliveries during non-peak hours or change the delivery format to reduce any performance impact.
Which compute size do you think you’ll need? Limits when delivering analyses and dashboards by email
Max rows in unformatted reports delivered by email Max rows in formatted reports delivered by email

1 OCPU

(non-production only)

2,000

space

1,000

space

2 OCPU

200,000

50,000

4 OCPU

200,000

50,000

6 OCPU

200,000

50,000

8 OCPU

200,000

50,000

10 OCPU

200,000

50,000

12 OCPU

200,000

50,000

16 OCPU

300,000

100,000

24 OCPU

300,000

100,000

36 OCPU

300,000

100,000

52 OCPU

300,000

100,000

Data Size Limits (Classic Pixel-Perfect Reports)

The compute size determines several limits associated with generating reports.

Which compute size do you think you’ll need? Report data size limits when generating pixel-perfect reports
Max data size for online reports Max data size for offline (scheduled) reports Max data size for bursting reports Max data size for data generation

1 OCPU

(non-production only)

200MB

space

500MB

space

2GB

space

500MB

space

2 OCPU

500MB

2GB

4GB

2GB

4 OCPU

500MB

2GB

4GB

2GB

6 OCPU

500MB

2GB

4GB

2GB

8 OCPU

500MB

2GB

4GB

2GB

10 OCPU

500MB

2GB

4GB

2GB

12 OCPU

500MB

2GB

4GB

2GB

16 OCPU

500MB

4GB

8GB

4GB

24 OCPU

500MB

4GB

8GB

4GB

36 OCPU

500MB

4GB

8GB

4GB

52 OCPU

500MB

4GB

8GB

4GB

Processing Limits (Classic Pixel-Perfect Reports)

The compute size determines several limits associated with processing reports.

Which compute size do you think you’ll need? Data model and report processing limits when generating pixel-perfect reports
SQL Query timeout for scheduled reports (seconds) Max rows for CSV output Max number of in-memory rows in XPT layout Max number of concurrent scheduled jobs Max number of concurrent online reports

1 OCPU

(non-production only)

1,800

space

1,000,000

space

100,000

space

1

space

2

space

2 OCPU

1,800

4,000,000

200,000

4

16

4 OCPU

1,800

4,000,000

200,000

4

32

6 OCPU

1,800

4,000,000

200,000

4

48

8 OCPU

1,800

4,000,000

200,000

4

64

10 OCPU

1,800

4,000,000

200,000

4

80

12 OCPU

1,800

4,000,000

200,000

4

96

16 OCPU

3,600

6,000,000

300,000

10

320

24 OCPU

3,600

6,000,000

300,000

10

480

36 OCPU

3,600

6,000,000

300,000

10

720

52 OCPU

3,600

6,000,000

300,000

10

1040

How Many People Do You Expect to Use the Service?

With Oracle Analytics Cloud, you can opt to specify how many people you expect to use the service. Typically, services have between 10 and 3000 users. Configuration limits for user-based subscriptions are equivalent to those shown here.

Configuration Limits for User-based Subscriptions: Data Visualization Workbooks, Classic Analyses and Dashboards

Limit Description Limit Value
Limits when querying data for visualizations, analyses, and dashboards

space

Max input rows returned from any data source query 2,000,000 rows
Query timeout (seconds) 660 seconds
Limits when displaying data in visualizations, analyses, and dashboards
Max summarized rows returned from any data source query 500,000 rows
Limits when exporting data from data visualization workbooks
Maximum number of rows exported to CSV 2,000,000 rows
Maximum number of rows exported to Microsoft Excel (XLSX) 25,000 rows
Limits when exporting data from analyses and dashboards
Max rows exported to unformatted reports 2,000,000 rows
Max rows exported to formatted reports 200,000 rows
Limits when delivering analyses and dashboards by email
Max rows in unformatted reports delivered by email 200,000 rows
Max rows in formatted reports delivered by email 50,000 rows

Configuration Limits for User-based Subscriptions: Classic Pixel-Perfect Reports

Limit Description Limit Value
Report data size limits when generating pixel-perfect reports
Max data size for online reports 500MB
Max data size for offline (scheduled) reports 2GB
Max data size for bursting reports 4GB
Max data size for data generation 2GB
Data model and report processing limits when generating pixel-perfect reports
SQL Query timeout for scheduled reports (seconds) 1,800 seconds
Max rows for CSV output 4,000,000 rows
Max number of in-memory rows in XPT layout 200,000 rows
Max number of concurrent scheduled jobs 4 jobs
Max number of concurrent online reports 32 reports

What's the Difference Between Production and Non-Production Environments

  • Non-production environment: Oracle enables you to deploy a non-production environment with 1 OCPU. A non-production environment is specifically sized and designed for test, development and training purposes. Non-production services aren't intended for daily use, multiple concurrent users, or complex business scenarios.

    If you decide you want to keep the content that you create during testing, you can save it to a snapshot and copy it to a production service (minimum 2 OCPU or 10 users). See Migrate Oracle Analytics Cloud Using Snapshots. Alternatively, you can scale up your 1 OCPU environment to between 2 and 8 OCPUs.

  • Production environment: A production environment is designed for daily commercial use. You can scale some production environments up and down. For example, you can scale between 2 and 8 OCPUs and 10 and 12 OCPUs. You can also scale between various user ranges such as 10 - 400 users and 401 - 601 users. See About Scaling.