-----------------------------------------------------------------------------------前言：在mysql中有一个默认的数据表information_schema，information_schema这张数据表保存了MySQL服务...

 //查询数据库各表占用空间的情况droptable#tcreatetable#t(namevarchar(255),rowsbigint,reservedvarchar(20),datavarchar(20),index_sizevarchar(20),unusedvarchar(20))execsp_MS...

selectsum(bytes/1024/1024)fromuser_segmentswheresegment_name='TF_F_USER_PHONE';...

SELECTT.OWNER,T.SEGMENT_NAME,SUM(T.BYTES)/1024/1024M FROMDBA_SEGMENTST WHERET.OWNER='user_name'  ANDT.SEGMENT_NAME='table_name' GROUPBY...