OSnya apa?
kalo UNIX pake kill -9 PID
kalo Windows bisa orakill.exe
----- Original Message -----
From: vinkymomo .
To: [email protected]
Sent: Tuesday, October 13, 2009 5:28 AM
Subject: RE: [indo-oracle] KILLED SESSION
Coba ini deh
1. Select sid, serial# from v$session where status='INACTIVE';
2. alter system kill session '<sid>,<serial#.';
CMIIW,
eldin
To: [email protected]
From: [email protected]
Date: Tue, 13 Oct 2009 15:02:42 +0700
Subject: [indo-oracle] KILLED SESSION
Dear rekan
Mohon bantuan sehubungan dengan session yang sudah killed.
saya menggunakan database 10g R1
di dalam database apabila koneksi dalam kondisi idle selama 30 menit
maka akan di putus (killed)
nah masalahnya adalah..
bila saya melihat melalui session browser di toad .. session killed
itu spid nya sudah hilang..hanya terlihat sidnya saja
bagaimana saya harus meng-kill session killed tersebut melalui OS
karena spidnya sudah tidak terlihat lagi..
terkadang session yang idle itu memakan resource yang tinggi
sekali..sehingga menghambat session yang lain
terima kasih
__________________________________________________________
Windows Live: Keep your friends up to date with what you do online.
http://www.microsoft.com/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-id:SI_SB_1:092010
[Non-text portions of this message have been removed]
------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.421 / Virus Database: 270.14.12/2431 - Release Date: 10/12/09
13:01:00
[Non-text portions of this message have been removed]
