Hi. I have a query that seems to be waiting for a PS enqueu for about 2 days. When querying the v$session_wait, I'm getting the following:
SID EVENT S-I-W T P1 P2 P3 ----- ------------------------- ------ ---- ---------- ------- ---------- 48 enqueue ###### 0 1347616774 1 15 15 direct path write 0 -1 304 185925 16 67 direct path write 3 -1 304 326053 16 23 direct path write 3 -1 304 171333 16 64 direct path write 3 -1 304 159829 16 (sids 15,67,23 and 64 are parallel slaves of the SID 48). I also see that this is a PS type enqueue via the following: 1 select sid, 2 chr(bitand(p1,-16777216)/16777215)|| chr(bitand(p1,16711680)/65535) enq, 3 decode( chr(bitand(p1,-16777216)/16777215)||chr(bitand(p1,16711680)/65535), 'TX','Transaction accessing a rbd', 'ST','Space mgt activity', 'SS','Sort segment activity', 'TM','DML ACtivity', 'UL','user defined', chr(bitand(p1,-16777216)/16777215)||chr(bitand(p1,16711680)/65535)) edes, 4 decode(bitand(p1,65535),1,'NULL',2,'SUB_SHARE',3,'SUB-exclusive',4,'share',5,'share or subexclusive',6,'exclusive','other') md, 5 p2, 6 p3 7 from gv$session_wait 8* where event='enqueue' sid enq enqueue name lock mode P2 P3 ----- ---- ------------------------------ ---------- ------- ---------- 48 PS PS exclusive 1 15 I'm not sure what P2 and P3 are referring to in this case. I have tried to kill the session, but it didn't go away and the parallel slaves are still holding a lot of space in the TEMP tablespace. What should I do now? any sugestions? thanks __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Olga Gurevich 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).