Home » RDBMS Server » Server Administration » user session resources reallocation (oracle 9.0.2.4)
user session resources reallocation [message #321861] Wed, 21 May 2008 10:39 Go to next message
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 #321866 is a reply to message #321861] Wed, 21 May 2008 10:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you still use the coffee machine when you stay beside it drinking your coffee?

Regards
Michel
Re: user session resources reallocation [message #322118 is a reply to message #321861] Thu, 22 May 2008 09:49 Go to previous messageGo to next message
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...
Re: user session resources reallocation [message #322131 is a reply to message #321861] Thu, 22 May 2008 10:09 Go to previous message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
> the "uptime" of our DB server doesn't change unless I asked the user to logout his session.

Please CUT & PASTE so we also can see exactly what you are seeing.
Previous Topic: Upgrade from 10.1.0.2 to 10.2.0.4
Next Topic: Decommission of a 9.2.0.8 database
Goto Forum:
  


Current Time: Sat Dec 03 10:12:18 CST 2016

Total time taken to generate the page: 0.06344 seconds