查看行数
SELECT count(1) from XXXXXX.DOCS with ur

以KB为单位查看表的数据，索引，大对象的大小
SELECT data_object_p_size , index_object_p_size , long_object_p_size , lob_object_p_size , xml_object_p_size FROM TABLE( SYSPROC.ADMIN_GET_TAB_INFO( 'ER', 'DOCS' )) WITH UR

查看一个schema中每个表占用空间的大小
SELECT tabname,sum(data_object_l_size + index_object_l_size + long_object_l_size + lob_object_l_size + xml_object_l_size) as total_l_size,sum(data_object_p_size + index_object_p_size + long_object_p_size + lob_object_p_size + xml_object_p_size) as total_p_size FROM TABLE( SYSPROC.ADMIN_GET_TAB_INFO_V97( 'DBTPPX7', '' )) AS T group by tabname order by tabname
 
查看一个schema中所有表的大小
SELECT sum(data_object_p_size + index_object_p_size + long_object_p_size + lob_object_p_size + xml_object_p_size) as total_p_size FROM TABLE( SYSPROC.ADMIN_GET_TAB_INFO_V97( 'DBTPPX7', '' )) AS T