V$session

[learn]

Can any one give me the syntax that I can use in v$session to find out
all informtion in v$session including the exact current sql statement being executed?
I think I might have to do a join to get that info. but I'm not sure of the syntax

The command column is just giving the number but I want more than that.

[peach_partner]

SELECT s.username, s.terminal, s.sid, s.serial#, st.sql_text
FROM v$session s, v$sqltext st
WHERE s.sql_address = st.address 
       and s.username is not null
ORDER BY s.sid, s.serial#, st.piece

Hope this answers you question.