复制SELECT p.object_name,分享 p.operation, p.options, COUNT(1) FROM v$sql_plan p, v$sql s WHERE p.object_owner <> SYS AND p.OBJECT_NAME in (select index_name from dba_indexes where table_name = S_SHIP_UNIT_LINE) AND p.sql_id = s.sql_id GROUP BY p.object_name, p.operation, p.options ORDER BY 1, 2, 3; 1.2.3.4.5.6.7.8.9.10.