it sounds like the sessions are long running and consistent (i.e not pooled). I'd expect that active_session_history would be good enough for you to identify the top modules.
-- Niall Litchfield Oracle DBA http://www.orawin.info