2019 年 1 月 29 日, zabbix 显示一个索引表空间告警,所以登录服务器查看:
10:02:22 SQL> col file_name for a50 10:02:42 SQL> select file_id,tablespace_name,file_name,bytes/1024/1024/1024 G from dba_data_files where tablespace_name='&ts' order by 1; Enter value for ts: TBS_LOGIDX old 1: select file_id,tablespace_name,file_name,bytes/1024/1024/1024 G from dba_data_files where tablespace_name='&ts' order by 1 new 1: select file_id,tab |