CODEWITHSUNDEEP
oracle-database
KurioZ7
KurioZ7

Reputation: 6349

What is Oracle Session?

I am using Oracle 11g.

I am looking for a good explanation of Oracle Sessions. I googled for this, but strangely, none of the web sites contain any explanation of what oracles sessions are. My specific questions are

1) What are oracle sessions?

2) Does one connection object always relate to one oracle session.?

3) can one oracle session be shared by another connection started by the same user.?

Upvotes: 11

Views: 18777

Answers (1)

David Aldridge
David Aldridge

Reputation: 52336

  1. A logical entity in the database instance memory that represents the state of a current user login to a database.
  2. A single connection can have 0, 1, or more sessions established on it.
  3. I can't imagine that it can

http://docs.oracle.com/cd/E28271_01/server.1111/e25789/glossary.htm

Upvotes: 3

Related Questions