Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Improve Steaming Time Performance Metric

Received Response
112
Views
2
Comments

Summary:

We are looking for methods of improving the Streaming Time for our Oracle Analytics Cloud instance

Content (required):

We have a Workbook that is currently under performing. When analyzing the performance metrics we see that a bulk of the time is spent on 'Streaming'. We are looking for ways to improve this, as there are instances where the workbook will take 90 seconds to refresh, with 95+% of the time being spent on 'Streaming'

Version (include the version you are using, if applicable):

OAC 6.3

Code Snippet (add any code snippets that support your topic, if applicable):


Tagged:

Answers

  • Rank 5 - Community Champion

    This is experienced by multiple users, so it isn't isolated to my personal network performance.

  • This looks like a general database tuning situation. The numbers might be a bit misleading as the query time is 0 which is unlikely. In this case -- I would start by running the same query generated by OAC against the database directly and seeing how long this is taking. To get help with trouble shooting here you can open up a Service Request (SR). We will look to see if there is some clarification we can make in what is including in the streaming value in this kind of situation.

Welcome!

It looks like you're new here. Sign in or register to get started.