Re: V$LOCK definition
From: Joe Frohne <joe_at_rawsonoaks.com>
Date: Mon, 16 Jun 2003 12:28:19 -0700
Message-ID:
Date: Mon, 16 Jun 2003 12:28:19 -0700
Message-ID:
The column CTIME in V$LOCK indicate that the time since the current lock mode has been acquired/converted. The time is shown in units of seconds.
-- Joe Frohne Rawson Oaks Consulting http://www.rawsonoaks.com [EMAIL PROTECTED] or [EMAIL PROTECTED] > Folks, > > Question here, the CTIME column in V$LOCK is expressed in what? Seconds, > milli-seconds, What?? Anyone know? > > Dick Goulet > Senior Oracle DBA > Oracle Certified 8i DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Goulet, Dick > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.net -- Author: Joe Frohne INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).