select * from v$access - will show you what objects are being accessed by what users -this will be the place to start.