数据收集 DBMS_STATS.GATHER_TABLE_STATS
select b.SQL_CHILD_NUMBER,a.SQL_TEXT,a.SQL_FULLTEXT,a.SQL_ID,b.EVENT,b.USERNAME,b.* from gv$sql a,gv$session b
where a.sql_id=b.sql_id
and a.CHILD_NUMBER=b.SQL_CHILD_NUMBER and b.USERNAME not in(‘SYSTEM‘,‘SYS‘)
and b.EVENT not in(‘SQL*Net message from client‘,‘SQL*Net message to client‘)
order by 1
exec DBMS_STATS.GATHER_TABLE_STATS(‘stg‘,‘T_PRINT_LABEL‘);
grant select on T_PRINT_LABEL to public;
温馨提示: 本文由Jm博客推荐，转载请保留链接: https://www.jmwww.net/SQL/13862.html
