Oracle Database Discussions

Hi!
I am trying to track down the Osuser from the view V$active_session_history. The trouble is that this view provides the session_id and session_serial# values but no Osuser. I tried using the values of session_id and session_serial# against the v$session view. But I can never be sure that it is the same user. The same problem I experience with using sql_id for the relevant sql statement.
Life would have been so much easier if they had provided sql_text and osuser columns.

Also am I mistaken in thinking that the combination of sid and serial# can be reused as with sql_id.

Has anyone worked on a solution towards mining osuser information related to costly queries/slow response queries either through v$active_session_history or for the perfstat tables (stats$...).

Thanks
Aniruddha