You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can we determine if the BIP report has reached/hit a certain number of billion logical I/O?

Summary:

We received a notification from Oracle that the one of our report is running for more than 5 hours or exceeding 4 billion Logical I/O. Hence, the report needs to be fine-tuned.

We are trying to improve the performance of the report by optimizing the query. But how can we determine how many billion logical I/O from the database were hit in every BIP report run? Because our report is working fine well within the 5-hours time limit.

We just want to understand how this other threshold criteria of 4 billion logical IO is being verified.

Content (please ensure you mask any confidential information):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!