Home » RDBMS Server » Server Administration » Session users
icon5.gif  Session users [message #194475] Fri, 22 September 2006 06:03 Go to next message
Messages: 81
Registered: April 2005
Location: th
Dear all,

After i exit from program. such as vb,toad. i found there are a lot of session still are in my database. and i check from v$session the status column is inactive !.
I tried test exit from toad by not commit the transaction. it's not stay !!! What happend ? Can anybody give me some advice?

(oracle9i R2 on windows2000 advance)

Thks for advance

Re: Session users [message #194501 is a reply to message #194475] Fri, 22 September 2006 07:25 Go to previous message
Messages: 121
Registered: August 2006
Senior Member
set sqlnet.expire_time to lower value in sqlnet.ora on database server.

Previous Topic: Dictionary Managed Tablespace to Locally Managed
Next Topic: How to schedule and run jobs (merged)
Goto Forum:

Current Time: Wed Apr 26 09:01:20 CDT 2017

Total time taken to generate the page: 0.08360 seconds