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):
Tagged:
1