抓取缺少外键索引的对象表 COLUMN COLUMNS format a30 word_wrapped COLUMN tablename format a15 word_wrapped COLUMN constraint_name format a15 word_wrapped SELECT TABLE_NAME, CONSTRAINT_NAME, CNAME1 || NVL2(CNAME2, ‘ […]

抓取关注TopSQL select executions, hash_value, sql_text from v$sqlarea where hash_value in (select distinct hash_value from v$sqlarea where substr(sql_text, 1, 40) in (select substr(sql_text, 1, 40) from v […]

切换到手机版