From oracle-l-bounce@freelists.org Thu Sep 23 08:45:10 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i8NDj9405963 for ; Thu, 23 Sep 2004 08:45:09 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i8NDj8I05955 for ; Thu, 23 Sep 2004 08:45:08 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C8B7B72CAF7; Thu, 23 Sep 2004 08:51:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12826-11; Thu, 23 Sep 2004 08:51:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EDF6472D2C5; Thu, 23 Sep 2004 08:51:07 -0500 (EST) X-Server-Uuid: 6429C5EE-306C-482B-A842-D75C76A1DB7A X-MimeOLE: Produced By Microsoft Exchange V6.0.6556.0 content-class: urn:content-classes:message MIME-Version: 1.0 Subject: RE: My 10 Commandments of Database Administration... Date: Thu, 23 Sep 2004 08:38:23 -0500 Message-ID: <7E0DB3A126BA9146AC30744E2B7E42459744DD@midhouhqxch01.net.smith.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: My 10 Commandments of Database Administration... Thread-Index: AcShcC5b/g9hvI5ASAaCK4dqqOHtzQAAgEMQ From: "Nelson, Allan" To: mwf@rsiz.com, oracle-l@freelists.org X-OriginalArrivalTime: 23 Sep 2004 13:38:33.0703 (UTC) FILETIME=[9EDFD770:01C4A172] X-WSS-ID: 6D4C0E5426G153372-08-01 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 9972 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: anelson@miswaco.com Precedence: normal Reply-To: anelson@miswaco.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Not so fast. The state for all records in fnd_login that have no corresponding record in v$session and v$process and end_date is null are both known and incorrect. Just because something was validly null at one point in time does not mean that it is true forever and this is the problem for leaving the nulls there when the user is not connected. Allan -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mark W. Farnham Sent: Thursday, September 23, 2004 8:15 AM To: oracle-l@freelists.org Subject: RE: My 10 Commandments of Database Administration... Hmm. The end_date of a login is an unknown value when the login is not yet ended. That sounds right to me. The end_date of a login is probably also unknown to Applications in the event of an abrupt termination. (And maybe the database too, if the abrupt event was a crash. Even if the database stays up, I'm not sure what value you'd like to stuff in there.) So a NULL in end_date correctly describes the information that the end_date of the login is unknown. I think this illustrates that attempting to ASCRIBE MEANING to a NULL value other than it is unknown is the problem. I think you're the one who gets to start cooking for Nuno. (Also possibly someone in documentation at Oracle if they wrote that a NULL end_date in fnd_login means anything other than it is unknown when that login ended.) Slight amendment to Ryan's #11: Thou shalt feed me whatever I want if.... (and usually it's gonna be pizza and beer, but I'm not ruling out Chinese.) mwf -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Nelson, Allan Sent: Thursday, September 23, 2004 8:42 AM To: oracle-l@freelists.org Subject: RE: My 10 Commandments of Database Administration... Dear God! Oracle Financials uses NULL in end_date on fnd_login to indicate either the current login or an abrupt termination of the user session neatly making your point and potentially providing with an enourmous number of cooks! Allan -----Original Message----- =3D46rom: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Nuno Pinto do Souto Sent: Wednesday, September 22, 2004 7:41 PM To: oracle-l@freelists.org Subject: Re: My 10 Commandments of Database Administration... Quoting from AUTHOR ryan gaffuri: > 11. Thou shalt feed me if I have to work late to fix something = you=3D20=20 > broke. > > I'm a single guy... Nuno's design corollary #1: Thou shall not use end_date =3D3D NULL to mean "current row" of = ANYTHING! NULL has NO MEANING whatsoever: it does NOT mean "current"! Under penalty of having to cook for Nuno (and I'm a heavy bloke)... -- http://www.freelists.org/webpage/oracle-l ________________________________________________________________________ ___=3D ___ This email is intended solely for the person or entity to which it is = =3D addressed and may contain confidential and/or privileged information. = =3D Copying, forwarding or distributing this message by persons or entities =3D other than the addressee is prohibited. If you have received this email in =3D error, please contact the sender immediately and delete the material from =3D any computer. This email may have been monitored for policy compliance. =3D [021216] -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l