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 -> v$rollstat

v$rollstat

From: Oradba Linux <techiey2k3_at_comcast.net>
Date: Tue, 01 Jun 2004 22:20:27 GMT
Message-ID: <Li7vc.28850$IB.5808@attbi_s04> 





We are using oracle 8174 on hp-ux . I am looking at a rollback segment with
no optimal set extended up to 2 Gigs .


I wanted to shrink to 300MB . The xacts column in v$rollstat was 1 . So i
wanted to see which session was running that
active transaction . I looked at v$transaction ( usn = xidusn) but could not
find ses_addr .


I want to know what i am missing here



Thanks
Received on Tue Jun 01 2004 - 17:20:27 CDT












Original text of this message













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