确实user_segment要快一点
SQL> col s for 999999999999999999999
SQL> select sum(bytes) s,segment_name from user_segments where segment_name like 'REN%' group by segment_name;
S SEGMENT_NAME
---------------------- ---------------------------------------------------------------------------------
188284928 REN1
34292826112 RENC
144909860864 REN
已用时间: 00: 00: 00.42
SQL> select sum(bytes) s,segment_name from dba_segments where segment_name like 'REN%' group by segment_name;
S SEGMENT_NAME
---------------------- ---------------------------------------------------------------------------------
34292826112 RENC
188284928 REN1
46068924416 REN_S
7171211264 REN_L
144909860864 REN
已用时间: 00: 00: 00.50
SQL> select sum(bytes) s,segment_name from user_extents where segment_name like 'REN%' group by segment_name;
S SEGMENT_NAME
---------------------- ---------------------------------------------------------------------------------
188284928 REN1
34292826112 RENC
144909860864 REN
已用时间: 00: 00: 01.59
SQL> select sum(bytes) s,segment_name from dba_extents where segment_name like 'REN%' group by segment_name;
S SEGMENT_NAME
---------------------- ---------------------------------------------------------------------------------
34292826112 RENC
188284928 REN1
46068924416 REN_S
7171211264 REN_L
144909860864 REN
已用时间: 00: 00: 01.79