Finding Open Oracle Connection

to find oracle open connection obviously you need to be a administrator privileges and the query to fire is

select * from v$session where username= ?,

v$session is the table to watch out for?

-Kalyan