select rownum,
       sys.dba_rollback_segs.segment_name Name,
       v$rollstat.extents Extents,
       v$rollstat.rssize Size_in_Bytes,
       v$rollstat.xacts XActs,
       v$rollstat.gets Gets,
       v$rollstat.waits Waits,
       v$rollstat.writes Writes,
       sys.dba_rollback_segs.status status
  from v$rollstat, sys.dba_rollback_segs, v$rollname
 where v$rollname.name(+) = sys.dba_rollback_segs.segment_name
   and v$rollstat.usn(+) = v$rollname.usn
 order by rownum

Logo

北京人形旗下天工造物具身智能开源社区,聚焦具身天工与慧思开物两大平台

更多推荐