Hi All ,
We have database which grows by average 50 gb daily, there is only one schema (Application schema) through which connections happens to database. We need to identify how much data was loaded by each session in database. I can see different sessions info from client_info column connecting through this schema but no any means to find how much data they inserted.
I checked and found v$session_io view but this doesn't give picture of data loaded by each individual session .
Many Thanks