| user session resources reallocation [message #321861] |
Wed, 21 May 2008 10:39  |
gaoradba
Messages: 2
Registered: May 2008
Location: ga, usa
|
Junior Member |
|
|
I would like to know if a session consumes 35% of the CPU at a certain point of it's processing, will that resources be returned back to the server when it's no longer in use while the user session remains login but idle on the database?
Thanks for your input in advance.
|
|
|
|
|
|
| Re: user session resources reallocation [message #322118 is a reply to message #321861] |
Thu, 22 May 2008 09:49  |
gaoradba
Messages: 2
Registered: May 2008
Location: ga, usa
|
Junior Member |
|
|
The reason being for me raising the this question is that we noticed that after a session completed it's processing, the "uptime" of our DB server doesn't change unless I asked the user to logout his session. As soon as the user logouts the uptime started to come down...
I also noticed that v$sysstat captures cummulative information and not at point in time information.
Anyways, any input is appreciated...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
