DevOps, CI/CD and Automation

Hello

I have a legacy app (VB6) that uses an ODBC connection from Win 32 client to an Oracle 10G DB.

The ODBC connection when it calls procedures/packages it seem to run a query like this before hand:

SELECT /*+ RULE */ '', a.owner, decode (b.object_type, 'PACKAGE', CONCAT( CONCAT (b.object_name, '.'), a.object_name), b.object_name),decode(a.position, 0, 'RETURN_VALUE', a.argument_name), decode(a.position, 0, 5, decode(a.in_out, 'IN', 1, 'IN/OUT', 2, 'OUT', 4)), 0, a.data_type, a.data_precision, a.data_length, a.data_scale, a.radix, 2, '' FROM ALL_ARGUMENTS a, ALL_OBJECTS b WHERE ( b.object_type = 'PROCEDURE' OR b.object_type = 'FUNCTION' ) AND b.object_id = a.object_id AND a.data_level = 0 AND UPPER(a.OBJECT_NAME) LIKE UPPER('SOME_PROC') ORDER BY a.position

These queries seem to be very intensive and use lot of CPU/disk.

Nowhere in our app do we run this queries so must be part of the ODBC stuff. Has anyone seen this before?

Any help or information greatly appreciated.

Regards
Daniel