在altibase的linux下使用./abc.sh yonghuming来统计表空间的方法

clear
is -silent <<EOF
SELECT B.TABLE_NAME, ( A.MEM_PAGE_CNT * 32 / 1024) + ( A.MEM_VAR_PAGE_CNT * 32 / 1024 )  AS ALLOC_SIZE 
FROM V\$MEMTBL_INFO A,
SYSTEM_.SYS_TABLES_ B,
SYSTEM_.SYS_USERS_ C 
WHERE A.TABLE_OID = B.TABLE_OID 
AND B.USER_ID = C.USER_ID 
AND C.USER_NAME = upper('$1');
EOF