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

Home -> Community -> Usenet -> c.d.o.server -> Re: what row_wait_obj#, row_wait_file#, row_wait_block#

Re: what row_wait_obj#, row_wait_file#, row_wait_block#

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 23 Jun 2006 23:11:22 +0200
Message-ID: <p3mo92to9egm5fe8aqodg91ejr8ce47fni@4ax.com>


On 23 Jun 2006 12:07:56 -0700, niy38_at_hotmail.com wrote:

>mean where lockwait is null in v$session?

They mean : the data_object_id of the object being locked the file_id of the file being locked, and the block number of the block being locked.
Pretty obvious and described in the v$session reference note in the Reference manual on http://tahiti.oracle.com

Why people never bother to read the manual, but instead ask here, has always escaped me.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Jun 23 2006 - 16:11:22 CDT

Original text of this message

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