user session resources reallocation [message #321861] |
Wed, 21 May 2008 10:39 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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...
|
|
|
|