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: Renaming the Database
Next Topic: ORA-1652 error
Goto Forum:

Current Time: Mon Aug 21 22:41:37 CDT 2017

Total time taken to generate the page: 0.01765 seconds