OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Session users

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Session users [message #194475]

Fri, 22 September 2006 06:03

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

Report message to a moderator

Re: Session users [message #194501 is a reply to message #194475]

Fri, 22 September 2006 07:25

email.sandeepnaik
Messages: 121
Registered: August 2006

Senior Member

set sqlnet.expire_time to lower value in sqlnet.ora on database server.

Sandeep

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:29:30 CDT 2024