时间:2021-07-01 10:21:17 帮助过:22人阅读
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;
数据收集 DBMS_STATS.GATHER_TABLE_STATS
标签:rom session table lte print cli system 数据收集 child