I have a few queries about sessions:-

1) what does 'ACTIVE' & 'INACTIVE' mean for sessions?

2) our system is showing too many active/inactive sessions even though the users claim they log in only once. How is this possible?

3) the users connect to the database thru an application. Could it be that the application is implicitly causing multiple sessions for a user?

4) even if a session is inactive, are the memory resources etc. still kept locked for the user or are they automatically released?

Would appreciate any help on this.

Thanks & regards
Lynn