If I have to find history all the sqls executed from a particular host in 10g, what should be the qu

11g has new columns added to dba_hist_active_sess_history "machine" , "port" with which we can find history of all sql_ids executed.

If I have to get such details in 10g, what would be the alternative query.

Below query did not solve my purpose.

select snap_id, sql_id,CLIENT_ID,PROGRAM,MODULE from dba_hist_active_sess_history where (client_id not like 'SYSMAN%' and client_id is not null) and rownum<10;

Any suggestions.

Thanks,

Rashmi