Home » RDBMS Server » Server Administration » inactive connection
inactive connection [message #140931] Thu, 06 October 2005 05:24 Go to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

My question is ...I have lot of inactive connection because of this now new session is not able to connect to the database ...
do any one know any query to remove inactive session?

Note:- It is MTS not dedicated server connection.

Regards
Always Friend sunilkumar.

Report message to a moderator

Re: inactive connection [message #140934 is a reply to message #140931] Thu, 06 October 2005 05:41 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Hi
Look at

alter system kill session 'sid, serial#'

HTH
Jim

Report message to a moderator

Re: inactive connection [message #140937 is a reply to message #140934] Thu, 06 October 2005 06:06 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

thanks for your relpy ... frankly saying i was knowing that query

But i have nearly 100 inactive session so as per the query i have to execute the query 100 time.

can you tell me how to remove my 100 inactive session in a single query ?

thanks & Regards
Always friend sunilkumar

Report message to a moderator

Re: inactive connection [message #140940 is a reply to message #140937] Thu, 06 October 2005 06:24 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Not in a single query. You could use a pl/sql proc or spool out to a self generating script..

Jim

Report message to a moderator

Previous Topic: Unable to mount the database
Next Topic: cannot startup 10gR2: ORA-01092 + ORA-00704 + ORA-39700
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 03:52:29 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.