Oracle Database Discussions

Hi,

I would like to extract sql_id knowing sql_id and serial but with these select sql_id is empy!

Someone could help me please

select sample_time,session_id,session_serial#,sql_id,temp_space_allocated/1024/1024 temp_mb,

temp_space_allocated/1024/1024-lag(temp_space_allocated/1024/1024,1,0) over (order by sample_time) as temp_diff

from dba_hist_active_sess_history

--from v$active_session_history

where

session_id=xxxxxx

and session_serial#=yyyyyy

order by sample_time asc

/

REsult:

Thanks