[oracle@zpdb-0048 ogg]$ sqlplus / as sysdba
set linesize 1000;
select module,sid,sql_id,serial#,username,program,machine,status from v$session where module like '%REP%';
3.根据上方获取的sql_id查看对应的sql语句
alter session set cursor_sharing=force;
set pagesize 1000
SELECT /* SHSNC */ SQL_TEXT FROM V$SQLTEXT
WHERE SQL_ID = to_char('gfs692y7nfvpk') #修改sql_id
ORDER BY PIECE;
4.查看表的数据量
select sum(BYTES/1024/1024/1024) size_G from dba_segments where owner='CCICDZ' and SEGMENT_NAME='T_COMPRE_COLL'; #修改属主和sql_id
5.查看执行频次
SELECT SQL_ID, SQL_TEXT,FIRST_LOAD_TIME, EXECUTIONS
FROM V$SQLAREA
WHERE SQL_ID='sql_id'; #修改sql_id
6.根据上方查看的sql_id,查看执行计划
set lines 150
alter session set statistics_level = all;
select * from table(dbms_xplan.display_cursor('9ttcb4vr5asaf',null,null )); #修改sql_id