Difference: Oracle Session & Oracle Connection



Share this article :

Connections and sessions are closely related to user processes but are very different in meaning.

A connection is a communication pathway between a user process and an Oracle Database instance. A communication pathway is established using available interprocess communication mechanisms (on a computer that runs both the user process and Oracle Database) or network software (when different computers run the database application and Oracle Database, and communicate through a network).

A session represents the state of a current user login to the database instance. For example, when a user starts SQL*Plus, the user must provide a valid username and password, and then a session is established for that user. A session lasts from the time a user connects until the user disconnects or exits the database application.

Multiple sessions can be created and exist concurrently for a single Oracle database user using the same username. For example, a user with the username/password of HR/HR can connect to the same Oracle Database instance several times.

Related posts

ORA-00904: invalid identifier
ORA-28002: the password will expire within x days
Find Last Patches/Upgrade on Oracle
ORA-01683: unable to extend index X partition X by X in tablespace X
© 2017 ITsiti. All Rights Reserved
Powered by KEEM