Database Software

How to investigate applications programs ,NET or plsql packages invoked   generating these lines   without closing it ? 

select * from sys.reg$ where subscription_name like 'CHNF%' AND location_name = 'net8://?PR=0';

SELECT R.LOCATION_NAME, R.USER#, U.USERNAME , COUNT(*)

FROM DBA_SUBSCR_REGISTRATIONS R, DBA_USERS  U

WHERE R.USER#=U.USER_ID

and SUBSCRIPTION_NAME like 'CHNF%' and LOCATION_NAME = 'net8://?PR=0'

GROUP BY R.LOCATION_NAME, R.USER#, U.USERNAME ORDER BY 4 DESC;