SQL/MySQL/ORACLE DBA Learning

Any ideas for below thing To enhance our analytical services, we grant customers JDBC/ODBC access to our database, utilizing individual schemas for each customer. Now, we aim to meter the connections per schema, monitoring both data storage and transfer within each specific schema.