[GENERAL] any way to query for current connections to db?

[Coarr, Matt]

Hi,
 
Is there any way to query the database to identify what the current
connections are (connections, sessions, or whatever you want to call
them)?
 
This would be something similar to oracle's v$session view.
 
Thanks,
Matt