Home » RDBMS Server » Server Utilities » Kill Session Software (Oracle 10G Database)
Kill Session Software [message #457351] Mon, 24 May 2010 01:23 Go to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Dear,

Is there any Free Software for Killing Sessions.
pls suggest.

Thanks in Advance,

Stanlee...
Re: Kill Session Software [message #457352 is a reply to message #457351] Mon, 24 May 2010 01:27 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
But Why you need that tool?

sriram Smile
Re: Kill Session Software [message #457353 is a reply to message #457352] Mon, 24 May 2010 01:29 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Just to kill sessions locks in the database, we get unexpected locks sometimes when the user limit crosses in the database login.

[Updated on: Mon, 24 May 2010 01:32]

Report message to a moderator

Re: Kill Session Software [message #457354 is a reply to message #457353] Mon, 24 May 2010 01:31 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
what about reading documents how to resolve lock issues?
1/ The commands provided.
2/ Causes Explianed.
Sriram Smile
Re: Kill Session Software [message #457357 is a reply to message #457354] Mon, 24 May 2010 01:35 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
We use manual kill session command to kill the sessions, sometimes number of users exceeds so the software will be usefull, in my previous company i have used that software, but i tried to download from net, i didnt get proper download channels.

pls help.

[Updated on: Mon, 24 May 2010 01:36]

Report message to a moderator

Re: Kill Session Software [message #457359 is a reply to message #457351] Mon, 24 May 2010 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Is there any Free Software for Killing Sessions

SQL*Plus.

Regards
Michel
Re: Kill Session Software [message #457360 is a reply to message #457359] Mon, 24 May 2010 01:46 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Laughing
Re: Kill Session Software [message #457361 is a reply to message #457357] Mon, 24 May 2010 01:51 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
stalin4d wrote on Mon, 24 May 2010 12:05
in my previous company i have used that software.


So whats the name of that software/tool

How about using Oracle Session Manager {I have never used this}

Goodluck

sriram Smile
Re: Kill Session Software [message #457363 is a reply to message #457361] Mon, 24 May 2010 01:54 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
I forgot that,
oracle session, i never used it!

we dont system privileges to database.
Re: Kill Session Software [message #457364 is a reply to message #457363] Mon, 24 May 2010 01:58 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
How to use Oracle Session Manager, can u tell me... i m in the server.
Re: Kill Session Software [message #457365 is a reply to message #457364] Mon, 24 May 2010 02:03 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
any Free Software for Killing Sessions

I just observered that its not free...

sriram Smile

[Updated on: Mon, 24 May 2010 02:04]

Report message to a moderator

Re: Kill Session Software [message #457366 is a reply to message #457365] Mon, 24 May 2010 02:04 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
sure must be there, coz i used it.
if found i will inform u soon
Re: Kill Session Software [message #457367 is a reply to message #457365] Mon, 24 May 2010 02:06 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
And whats your platform?
Is it windows or *nix?
If it is windows you can use "orakill" tool
sriram Smile
Re: Kill Session Software [message #457368 is a reply to message #457367] Mon, 24 May 2010 02:09 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
Windows only,

orakill tool?


Re: Kill Session Software [message #457369 is a reply to message #457368] Mon, 24 May 2010 02:10 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
orakill utility is provided with Oracle databases on Windows platforms.
The executable (orakill.exe) is available to DBAs to kill Oracle sessions
directly from the DOS command line without requiring any connection to the database.

sriram Smile
Re: Kill Session Software [message #457371 is a reply to message #457369] Mon, 24 May 2010 02:19 Go to previous messageGo to next message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
How to use it, when i give orakill.exe in Start>Run>orakill.exe, it closes.

Re: Kill Session Software [message #457372 is a reply to message #457371] Mon, 24 May 2010 02:24 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
http://www.oracle.com/technology/oramag/code/tips2003/030903.html

http://www.rampant-books.com/art_more_untapped_utils.htm
Explained
sriram Smile
Re: Kill Session Software [message #457374 is a reply to message #457372] Mon, 24 May 2010 02:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT use orakill to kill session unless you used it for an appropriate purpose which is not your case.

Regards
Michel
Re: Kill Session Software [message #457384 is a reply to message #457374] Mon, 24 May 2010 03:18 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
My bad Sad
sriram
icon7.gif  Re: Kill Session Software [message #457430 is a reply to message #457384] Mon, 24 May 2010 07:20 Go to previous message
stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...
Senior Member
sorry for not replying,
thanks a lot... for the information.

[Updated on: Mon, 24 May 2010 07:21]

Report message to a moderator

Previous Topic: Ext file being created is '0' bytes....
Next Topic: SQL loader question
Goto Forum:
  


Current Time: Thu Mar 28 17:04:07 CDT 2024