Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews.com!nntp.comcast.com!news.comcast.com.POSTED!not-for-mail NNTP-Posting-Date: Fri, 11 Nov 2005 05:14:19 -0600 From: "VC" Newsgroups: comp.databases.oracle.server References: <1131624370.471248.169820@g14g2000cwa.googlegroups.com> <43736785.102A@yahoo.com> <1131638454.222570.192790@g44g2000cwa.googlegroups.com> <1131699867.193422.73210@g44g2000cwa.googlegroups.com> Subject: Re: FOR UPDATE WAIT Date: Fri, 11 Nov 2005 06:14:23 -0500 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original Message-ID: <9PWdndDf6ZGW4OnenZ2dnUVZ_s-dnZ2d@comcast.com> Lines: 16 NNTP-Posting-Host: 24.91.127.140 X-Trace: sv3-mz4+AqNCr13yoLgmhE9TNZgWQVYLs2/xuUJfgPWaNlJ3mZ6taBbZK+vcGnyuApAKsD4ga2WLrEixUKv!Kr7oR78oHMdpQpXpZHIH4ipZnd2QX3UA19jJlWrW911gO03fqm+2hTJKSvnxJtoqa96V/SvHvTzw!gHB2WSjnkAU= X-Complaints-To: abuse@comcast.net X-DMCA-Complaints-To: dmca@comcast.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.3.32 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:255213 wrote in message news:1131699867.193422.73210@g44g2000cwa.googlegroups.com... > No real problem. > Just to understand better how Oracle's database > is working and to explain to myself (and anyone interested) what > could be internal Oracle's motivations applying such restrictions. > The origanal question was: "Why only INTEGERs for seconds?" > You question is rather pointless if you cannot substantiate why the SFU wait precision being seconds and not say microseconds might be a problem. Apparently, the original SFU designer decided that the precision is adequate for most practical purposes, just as is in the case of DATE type.