how to view the current sql queries?

[tamilselvan]

Try this in 10g:

set lines 101 pages 10000
col sql_fulltext for a76 word_wrapped
col last_load_time for a22

select last_load_time, sql_fulltext
from v$SQL
order by 1 desc
/