Oracle Database Discussions

Database listener should close idle connections after some time. The application should use a connection pool (a DataSource) which should ideally test its connections, and throw away dead ones. So the line of thought here is that the connection pool still holds old connections which are invalid.

What is the table that will give me a list of all users connected to my application (or database)....I basically want to see which sessions are active and test to see if sessions/connections are being dropped when InactivityTimeout is reached etc......

Thanks!