| Bishal |
Posted: May 08, 2008 03:52:36 AM |
Total Post: 98
Joined: Apr, 2008
|
| What are active and inactive sessions in an oracle database...Please explain in detail |
|
|
 Murtuja |
| Posted: May 08, 2008 05:30:01 AM |  |
|
Total Post: 588
Joined: Jan, 2006
|
Hi,
http://www.google.co.in/search?hl=en&q=+active+and+inactive+sessions+oracle&meta=
|
|
|
|
|
| Prakash |
| Posted: May 09, 2008 01:30:49 AM | |
|
Total Post: 112
Joined: Aug, 2006
|
A session is ACTIVE when it is making a SQL call to Oracle. A session is INACTIVE if it is not making a SQL call to Oracle (but it may still be connected to the Oracle database at the time).
An INACTIVE session becomes active when it begins making SQL calls to Oracle. Vice-versa, when an ACTIVE session stop making calls to Oracle, it becomes INACTIVE.
|
|
|
|
|
| dbavinod |
| Posted: May 12, 2008 07:59:32 AM | |
|
Total Post: 81
Joined: Sep, 2006
|
unless a session is executing some sql, it'll be "inactive" - not active
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
