In 188.8.131.52, I had three sessions opened in three separate DBs, each with a Schema Browser and Editor window. After doing some ASH/AWR reporting and miscellaneous SQLs in the various connections, I ran this SQL in one of the sessions:
And it immediately returned the full 70K rows, seemingly ignoring the OCI Array Buffer Size setting. As a quick fix, I bounced Toad, and now everything is back to normal. In the settings, I was expecting the value for OCI Array Buffer Size to be 500, but I see at some point there’s now an “Automatic” setting (to limit LOB returns to 75, maybe?). It seems like something I did decided to either boost that value or ignore it completely, but I’m unable to replicate.
Disclaimer: While I am an oxymoron, I try to put emphasis on the “oxy” part.