Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What is Oracle Session?

Tags:

oracle

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.?

like image 305
KurioZ7 Avatar asked Sep 10 '13 08:09

KurioZ7


1 Answers

  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

like image 167
David Aldridge Avatar answered Sep 28 '22 00:09

David Aldridge