运行如下语句可以查询某个租户中执行全表扫描的 SQL:

    1. obclient>SELECT query_sql
    2. FROM oceanbase.gv$sql_audit
    3. WHERE table_scan = 1 AND tenant_id = 1001
    4. GROUP BY sql_id;
    5. +-------------------------------+
    6. | query_sql |
    7. +-------------------------------+
    8. | SHOW VARIABLES LIKE 'version' |
    9. +-------------------------------+