大帅的博客

普通的实例连接Oracle方式:zybdb/type=javax.sql.DataSourcezybdb/driver=oracle.jdbc.driver.OracleDriverzybdb/url=jdbc:oracle:thin:@10.196.13.7:1521:orcldbzybdb/user=xxxzybdb/password=xxxxxservice_name服务名连...

1.查看所有表，每张表占用大小（单位是Byte）select segment_name, bytesfrom user_segmentswhere segment_type = ‘TABLE’;2.产看其中几张表大小需要再加判断条件segment_name为表名select round(sum(bytes)/1024/1024/1024,4) GBfrom user_segment...

参考：https://blog.csdn.net/flyfish778/article/details/53470683

查看版本号mysql> status;--------------mysql Ver 14.14 Distrib 5.7.12-5, for Linux (x86_64) using 6.2Connection id: 13Current database: Current user: root@localhostSSL: ...