Reading UNDO and displaying it in v$session

Hello Listers,
I have a following dilemma :
I am quering v$session to get information what each session is waiting for. For a specific session I am getting "direct path write temp" (from v$sesion.EVENT) waits event (generary means sorting in temp tablespace). For the same session I am getting

11:56:26 SQL> select ROW_WAIT_OBJ# , ROW_WAIT_FILE#, ROW_WAIT_BLOCK#, ROW_WAIT_ROW# from v$session where sid = 168 ;

ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
------------- -------------- --------------- -------------

            0 14 201328 0

So, I can NOR resolve the objects accessed at thius moment (ROW_WAIT_OBJ# =0) The file corriesponding to ROW_WAIT_FILE#=14 is a datafile belonging to UNDO tablespace !

 select OWNER, SEGMENT_NAME, TABLESPACE_NAME from dba_extents where FILE_ID=14 and 201328 between BLOCK_ID and block_id + blocks -1 ;

OWNER SEGMENT_NAME
------- -----------------

SYS                            _SYSSMU9$                                                                        ORAUNDO

The questions:
1) How to interptet "direct path write temp" wait event in UNDO tablespace? 2) Is there any information (papers, presentation, links) how to interpret the wait event when v$session.ROW_WAIT_OBJ# <=0 ?

I would appreciate any information about this topic.

Best Regards
Milen  

--

Psst! Geheimtipp: Online Games kostenlos spielen bei den GMX Free Games! http://games.entertainment.gmx.net/de/entertainment/games/free
--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 02 2008 - 05:48:24 CDT