登录高斯ssh dbuseripzsql sys/password127.0.0.1:portzsql db/password${dbname} -c select * from table; test.txtzsql db/password${dbname} -c update table set col0;commit;zsql db/password${dbname} -c test.sqltest.txt登录所有dbfor dbname in echo ${dblist}dozsql db/password${dbname} -c select * from table; ${dbname}.infodone收集WSR (workload statistics report)wrs list (列出当天的wsr报告)select snap_id,startup_time,snap_time from adm_hist_snapshot order by snap_id; (列出所有)wsr snapid snapid查看系统参数show parameter查看建表语句show create table tbname日志show parameter log_home数据库启动失败看这个日志/opt/zenith/data/SUMDB*/log/run/zenith.rlog运行日志 log/run操作日志 log/oper审计日志 log/audit慢SQL日志 log/longsql告警日志 log/zenith_alarm.log注意高斯数据库总的表空间初始预分配了2.0T的空间(其中sumdb 1.9T)即使表空间没有使用后台磁盘空间也会占用这么多磁盘空间查看分配的表空间大小/opt/zenith/data/SUMDB*/data/tablespaces/du -sh *adm_tablespacesadm_data_filesadm_segments查看表空间使用率select tablespace_name,total_size,used_size from adm_tablespaces查询占用表空间大的前20个对象select table_name,sum(bytes)/1024/1024/1024 as size frommy_tablesorder by size desc limit 20;或者select segment_name,segment_type,bytes frommy_segmentsorder by bytes desc limit 20;注意上面查询的结果不是很准确没有考虑表分区(my_segments表里有一列segment_name, partition_name, table_name, ) 同一个表会有大量分区就会有多行数据下面是完整的select segment_name,sum(bytes)/1024/1024/1024 as size frommy_segmentsgroup bysegment_nameorder by size desc limit 20;查看session并发情况,select count(1) from dv_sessions where statusACTIVE常用的字段sid,serial#,client_ip,program,run_time,current_sql,,sql_id,sql_exec_start,io_wait_time,cpu_time,elapsed_time sql语句的总耗时