Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: re: Profiles, idle time and the web

Re:RE: re: Profiles, idle time and the web

From: <dgoulet_at_vicr.com>
Date: Tue, 17 Oct 2000 09:24:55 -0400
Message-Id: <10652.119455@fatcity.com>


Victoria,

    I must assume from your reply that you have not been bothered by WEB based applications previously. Well, I have and I can sympathize with both of you. It's just very obvious that your new at it and MLaden is not. Sure we all should not vent our frustrations in an unsympathetic manner, but you don't know how many times I'd love to wring a web developers neck over this. The problem is that whether the app is developed in house or by a third party the developer always assumes that the DB is a constant resource that they and their surfers will have UNLIMITED access to. They are also not very aware of or care about error trapping. All of these normal concepts to client/server developers seem to be unfathomable by WEB folks. Consequently your stuck with two basic options:

  1. don't monitor idle time at all (idle time limit = unlimited)
  2. reboot the web server daily and whenever an error gets reported

OH, BTW; don't do cold backups either, WEB folk can not understand why anyone would want to do a backup in such a "dynamic" environment. Also, don't try to explain the need to do recovery when the DB crashes to them, because 'nothing ever crashes' in their world.

And folks wonder why I've said that the WEB is irrelevant.

Dick Goulet

____________________Reply Separator____________________
Subject: RE: re: Profiles, idle time and the web Author: "Victoria DeVore" <DEVOREV_at_gw.lbcc.cc.or.us> Date: 10/16/00 6:55 PM

If you have nothing better to do than answer a question in such a demeaning and senseless manner, you should not be answering at all! Trust me, you would never work in my shop!

Victoria DeVore
Linn-Benton Community College
Systems & Application Programming Manager 6500 Pacific Blvd. SW
Albany, OR 97321
(541)917-4355
(541)917-4379 FAX

devorev_at_gw.lbcc.cc.or.us

>>> MGogala_at_oxhp.com 10/16/00 06:21PM >>> Of course that killing of the session will cause an exception in the running forms programs! What do you think should happen? The form should proceed normally regardless of the fact that it has just been disconnected from the database? I don't think so. Remember, the whole session and with it the whole form context is gone. What should a decent the form do? Ignore such a minute annoyance? Send the user back to Kansas? Page the DBA?

-----Original Message-----
Sent: Monday, October 16, 2000 7:21 PM
To: Multiple recipients of list ORACLE-L

I am maintaining a third party application system that is run thru the web via OAS 4.0.8.1 to D2K 1.6.1 server. I am trying to control user idle time. We set an idle time of 120 minutes in a profile on the database side. The only problem is it causes unhandled exceptions in the forms. I know I could control this in the form, but as I mentioned this is a third party product. There are 100s of forms and I do not want to modify all of the forms, let alone maintain them.

My question is, is there any other way to capture this idle timeout? Any suggestions?

Victoria DeVore
Linn-Benton Community College
Systems & Application Programming Manager 6500 Pacific Blvd. SW
Albany, OR 97321
(541)917-4355
(541)917-4379 FAX

devorev_at_gw.lbcc.cc.or.us

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Victoria DeVore
  INET: DEVOREV_at_gw.lbcc.cc.or.us 

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: Gogala, Mladen INET: MGogala_at_oxhp.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: Victoria DeVore INET: DEVOREV_at_gw.lbcc.cc.or.us 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
Received on Tue Oct 17 2000 - 08:24:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US