RE: user holding session even after a re-boot

From: Koivu, Lisa <lisa.koivu_at_efairfield.com>
Date: Wed, 15 Aug 2001 10:24:38 -0700
Message-ID: <F001.0036B739.20010815092104@fatcity.com>

Well, that sounds like an optimal environment, Kevin. I've seen Oracle client zombie sessions hang around for days and chew up CPU. I had to write a shell script to identify these sessions and kill them in both the OS and in Oracle. This was HP/UX. I've seen the same thing on Solaris. And so I'm told OpenVMS does not have this problem.

Profiles will timeout a session that is idle, not one that is busy cranking away on who knows what statement it was executing when the messy app either dropped the connection unexpectedly or the user rebooted. That is, unless you set a different resource limit on the profile and assign it to the app user. I found that was very messy and I got more complaints than anything else.

Guess the bottom line is the behavior of a released connection is platform dependent.

Lisa Koivu
Gimp and Oracle DBA
Ft. Lauderdale, FL, USA

-----Original Message-----

From:   Kevin Lange [SMTP:kgel_at_ppoone.com]
Sent:   Wednesday, August 15, 2001 12:41 PM
To:     Multiple recipients of list ORACLE-L

Subject: RE: user holding session even after a re-boot

I have found that if they did not close their session properly, as in the case of a reboot, that sessions can hang around until they timeout and die on their own. You can see about the timeout settings in their profiles.

-----Original Message-----
Sent: Wednesday, August 15, 2001 11:11 AM To: Multiple recipients of list ORACLE-L

I have Oracle 7.3.4 running on Windoze NT4.0. I have been trying to determine if I have an application problem or a database problem. I have an application called MP2 that is causing a user to have their PC freeze up when they try to print from the application. I ran a trace on their session to see what is going on. I have not looked at the trace file yet but when I was doing this I noticed that when this person had a session open that I could see with the query

SELECT sid,serial#,osuser from v$session;

That when they re-booted, their original session stayed open on Oracle. Should a re-boot have ended the session. When they logged back in another session opened and the first one stayed open also. Is this normal??

Thanks,

Dave
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Farnsworth, Dave
INET: DFarnsworth_at_Ashleyfurniture.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------