OceanBase 查找某個租戶中執(zhí)行全表掃描的 SQL

運行如下語句可以查詢某個租戶中執(zhí)行全表掃描的 SQL：

obclient>SELECT query_sql 
      FROM oceanbase.gv$sql_audit 
      WHERE table_scan = 1 AND tenant_id = 1001 
      GROUP BY sql_id;

+-------------------------------+
| query_sql                     |
+-------------------------------+
| SHOW VARIABLES LIKE 'version' |
+-------------------------------+