sql语句求解

psb_天涯浪子

想要取得以下结果，但总是想不明白是否可写出这样的sql语句，请大家帮个忙。

表空间名
该表空间下数据表的最大下一扩展空间大小
下一扩展空间为上一列数据的表的总数
表空间中大于最大下一扩展空间的块的数量有多少
表空间中最大的可用块空间大小
表空间当前可用空间大小

psb_天涯浪子

顶

doni

dba_segments

OWNER
VARCHAR2(30)
  Username of the segment owner

SEGMENT_NAME
VARCHAR2(81)
  Name, if any, of the segment

PARTITION_NAME
VARCHAR2(30)
  Object Partition Name (Set to NULL for non-partitioned objects)

SEGMENT_TYPE
VARCHAR2(17)
  Type of segment: INDEX PARTITION, TABLE PARTITION, TABLE, CLUSTER, INDEX, ROLLBACK, DEFERRED ROLLBACK, TEMPORARY, CACHE, LOBSEGMENT and LOBINDEX

TABLESPACE_NAME
VARCHAR2(30)
  Name of the tablespace containing the segment

HEADER_FILE
NUMBER
  ID of the file containing the segment header

HEADER_BLOCK
NUMBER
  ID of the block containing the segment header

BYTES
NUMBER
  Size in bytes, of the segment

BLOCKS
NUMBER
  Size, in Oracle blocks, of the segment

EXTENTS
NUMBER
  Number of extents allocated to the segment

INITIAL_EXTENT
NUMBER
  Size in bytes requested for the initial extent of the segment at create time. (Oracle rounds the extent size to multiples of 5 blocks if the requested size is greater than 5 blocks.)

NEXT_EXTENT
NUMBER
  Size in bytes of the next extent to be allocated to the segment

MIN_EXTENTS
NUMBER
  Minimum number of extents allowed in the segment

MAX_EXTENTS
NUMBER
  Maximum number of extents allowed in the segment

PCT_INCREASE
NUMBER
  Percent by which to increase the size of the next extent to be allocated

FREELISTS
NUMBER
  Number of process freelists allocated to this segment

FREELIST_GROUPS
NUMBER
  Number of freelist groups allocated to this segment

RELATIVE_FNO
NUMBER
  Relative file number of the segment header

BUFFER_POOL
VARCHAR2(7)
  Default buffer pool for the object