[code class=\"lang-sql\" lang=\"sql\"]select hash_value,sql_text
from v$sqltext
where hash_value in (select distinct hash_value
from v$sql_plan v
where v.operation = \'TABLE ACCESS\'
and v.OPTIONS = \'FULL\')
order by hash_value, piece;
[/code]
电信运营商 · 2016-12-05