Home » RDBMS Server » Server Administration » Session users
icon5.gif  Session users [message #194475] Fri, 22 September 2006 06:03 Go to next message
chara
Messages: 81
Registered: April 2005
Location: th
Member
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

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

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


Current Time: Thu Dec 05 15:50:18 CST 2024