Re: Oracle on Windows Server - a lil' help?
- From: kathy duret <katpopins21@xxxxxxxxx>
- To: Chris.Taylor@xxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 8 Oct 2008 08:01:59 -0700 (PDT)
I have a note on Metalink, turning my Windows woes into Windows Wow
There is alot of information there to help you. I found stuff all over
metalink but this is what I found worked for me.
Also here is a script. I actually have a purge job I run for some of my
sessions that don't go away BUT BE CAREFULL and test it well.
One oops and you can bring down your db! I tried to kill some old sqldeveloper
sessions and ended end killing oracle processes.
you will need to update the module and the logon-time and last logon time.
I spooled this and then submit the job once a day. I run separate ones for
separate modules as some modules I kill twice a day (like Business objects) and
look for a time out less than a day.
select 'ORAKILL', rtrim(name), spid
from v$database d, v$session s, v$process p
where s.paddr = p.addr and status = 'INACTIVE'
and (module) = 'YOUR MODULE HERE'
and logon_time <= sysdate - 3
and (SYSDATE - last_call_et / 86400) <= sysdate - 3;
Have fun.
Kathy
--- On Wed, 10/8/08, Taylor, Chris David <Chris.Taylor@xxxxxxxxxxxxxxx> wrote:
From: Taylor, Chris David <Chris.Taylor@xxxxxxxxxxxxxxx>
Subject: Oracle on Windows Server - a lil' help?
To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
Date: Wednesday, October 8, 2008, 9:22 AM
Guys & Gals,
I've got a situation where Oracle doesn't recognize disconnected apps on
Windows 2003 server. Every time a machine reboots or power goes out, or users
terminate an app, it leaves the session connected to the db, eating up our
available processes (500).
I've check the SQLNET.ORA EXPIRE_TIME parameter and that doesn't seem to
resolve the issue.
I think there are some TCP parameters on the db server itself that need to be
adjusted? Has anyone run into this and successfully corrected it?
Any good documents you would like to share? I think I have the Metalink
document on tuning windows servers for Oracle databases...going to try to dig
it back up.
Thanks!!
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx
Other related posts:
