Hello Manish,
you may run the following queries for 2 to 3 times in a row to measure the time it takes to get the results.
. 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'))
If these 2 checkpoints have lots of amount of data around 2K rows or more the query can take 5-8 sec time to fetch data from table.
As per design, probe check the each row to calculate the QoS/threshold as per configuration that’s why it took too much time to calculate further which leads to callback timed out causing such problems.
If you are not interessed in the two callback you may disable it.
Kind regards,
Britta Hoffner
CA Support