oracle probe v 5.00 and higher
The two checkpoints in oracle probe configuration
creates a high data volume. The sql queries of this checkpoints show over 2k of rows output that takes several seconds to finish.
• SELECT name, decode(pool, null, '(total)', '('||pool||')') as pool, bytes FROM v$sgastat where name != 'free memory'
• SELECT owner,segment_name,segment_type,(max_extents-NVL(extents,0)) as extleft, partition_name FROM DBA_SEGMENTS WHERE tablespace_name IN ( SELECT DTBS.tablespace_name FROM DBA_TABLESPACES DTBS WHERE DTBS.TABLESPACE_NAME NOT IN ('SYS','SYSTEM','ROLLBACK','UNDO'))
As per design, the oracle probe checks each row to calculate the QoS/threshold as per configuration that’s why it took too much time to calculate and further leading to callback timed out causing PPM error.
Oracle probe should either be enhanced to allow a higher or configurable timeout or process the data more efficent.