| Need info on Inactive Session [message #479980] |
Wed, 20 October 2010 10:06  |
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
|
Senior Member |
|
|
Hi,
Could someone please explain me about Inactive session.
My understanding of Inactive session is that
Quote:A user starts a program/session, then leaves it running and idle for an extended period of time. This means you are connected to a session but neither you are running any query in that session nor you have terminated the session.
My question is,
When a user submits very large report and wait for the report to complete, the status is shown as "INACTIVE" in v$session.
If we want to disconnect all the inactive users based on
"IDLE_ TIME", will the users running very large reports get disconnected as weel?
Thanks,
[Updated on: Wed, 20 October 2010 10:26] by Moderator Report message to a moderator |
|
|
|
|
|
| Re: Need info on Inactive Session [message #479988 is a reply to message #479985] |
Wed, 20 October 2010 10:42  |
ultgnp
Messages: 106
Registered: May 2010
Location: Germany
|
Senior Member |
|
|
Thanks MIchel,
In case i want to disconnect all the Inactive sessions (idle_time=10 mins), will the users running heavy reports get disconnected, i mean when they are inactive (idle_time > 10 mins) between sql statements.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
