ORA-02395:exceeded call limit on IO usage
Some users are sometimes seeing this error.
Sometimes when re-running they don't get the error.
Sometimes other users don't get the error.
How can I verify the ceiling for the various users on this parameter to see if the users are consistently set up.
I'm guessing the best way out of this problem is to adjust the timing of running the query or to tune the query itself.
Is this parameter a ceiling across mutlitple queries? In other words, If I run a whole pile of full table scans, am I more likely to hit this ceiling than if I just run one?