Re: open_time in v$thread

From: james ellis <jellis24_gso_at_yahoo.com>
Date: Thu, 17 Aug 2000 06:09:26 -0700 (PDT)
Message-Id: <10592.114826@fatcity.com>

Alert Log Maybe?

• "O'Neill, Sean" <Sean.ONeill_at_organon.ie> wrote:
  > Hi Folks,
  >
  > I've noticed that open_time field in v$thread is
  > varchar2(20) in V7.3 Oracle
  > but in 8.0.5 it's a Date format field. The net
  > result is that with 8.0.5
  > you only see date but not time that database was
  > opened. Does anyone know
  > if the "time" titbit of information is available
  > from some other view?.
  >
  > Sean :)
  >
  > ###### ###### ###### ######
  > # # # # # # # # Rookie
  > #### # # ###### ###### Data
  > # # # # # # # # Base
  > # # ####### ###### # # Adminstrator
  > -------------------------------- ------------
  > Organon (Ireland) Ltd.
  > E-mail: sean.oneill_at_organon.ie [subscribed: Digest
  > Mode]
  >
  > The only man who never makes a mistake is the man
  > who never does anything.
  > - Theodore Roosevelt
  >
  > --
  > Author: O'Neill, Sean
  > INET: Sean.ONeill_at_organon.ie
  >
  > 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).
  

  ---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. Received on Thu Aug 17 2000 - 08:09:26 CDT