A report came in from one of our partners that they are unable to collect Oracle tablespace data for some of their Pluggable databases, after some troubleshooting we noticed that the data collection for the "oracle.ts.stats" key isn't happening for pluggable databases that are large in size.
For example, here is a 200GB pluggable database that is able to collect data:

Database size 1.7TB, unable to collect data:

There was a ZBX that already improved on the performance for this item: https://support.zabbix.com/browse/ZBX-20110
The partner is using Agent2 version 6.0.22, as well as has the updated template.

The issue is that it is unclear how much this can be improved upon, to collect 1.7Tb of data in a single request. It is probably also not very feasible to increase timeout for the plugin.