I only have access to a db2 client. but I like to know how many active connections I have to the database and their memory footprint.
Is it possible to get this info from the cli:
oracle have v$session and v$process which you can easily monitor if you have installed the dba views and have access.
mysql has show process_list etc.