Home » RDBMS Server » Server Administration » Inactive session (10.2.0.4.0 ,windows)
Inactive session [message #437444] Mon, 04 January 2010 07:35 Go to next message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member
Hi all,

Would inactive sessions also cause poor performance in database ?

Say for example, there are some inactive sessions in database.What would happen
if i leave the database in inactive status ?


Regards,


Re: Inactive session [message #437447 is a reply to message #437444] Mon, 04 January 2010 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Would inactive sessions also cause poor performance in database ?

Yes if they hold locks.

Quote:
What would happen if i leave the database in inactive status ?

What does this mean?
There is no inactive status for a database.

Regards
Michel
Re: Inactive session [message #437452 is a reply to message #437447] Mon, 04 January 2010 08:12 Go to previous message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member


Thank you.


"What would happen if i leave the database in inactive status "?


Leave this...
Previous Topic: DB Slow
Next Topic: About NOMOUNT & MOUNT Stage
Goto Forum:
  


Current Time: Fri Dec 09 09:29:06 CST 2016

Total time taken to generate the page: 0.06439 seconds