在Oracle中查看各个表、表空间占用空间的大小 查看当前用户每个表占用空间的大小:
Select Segment_Name,Sum(bytes)/1024 From User_Extents Group By Segment_Name
在Oracle中查看单个表占用空间的大小:
Select Segment_Name,Sum(bytes)/1024 From User_Extents where Segment_Name='FP_FPKJ_SYFPXX' Group By Segment_Name
Select Segment_Name,Sum(bytes)/1024 From User_Extents Group By Segment_Name
在Oracle中查看单个表占用空间的大小:
Select Segment_Name,Sum(bytes)/1024 From User_Extents where Segment_Name='FP_FPKJ_SYFPXX' Group By Segment_Name