刘大 您好，我现在用的生产库中经常会产生一些CMP4$ CMP3$ 开头的表，请问您这些表是由什么功能产生的？谢谢您。
create table "KGDB".CMP3$205792 tablespace "USERS" nologging as select /*+ DYNAMIC_SAMPLING(0) FULL("KGDB"."PRN_BIZ_INFO") */ * from "KGDB"."PRN_BIZ_INFO" sample block( 10.85) mytab
SuperHan 16:29:32
create table "KGDB".CMP4$205792 organization heap tablespace "USERS" compress for all operations nologging as select /*+ DYNAMIC_SAMPLING(0) */ * from "KGDB".CMP3$205792 mytab

create table "KGDB".CMP3$205792 tablespace "USERS" nologging as select /*+ DYNAMIC_SAMPLING(0) FULL("KGDB"."PRN_BIZ_INFO") */ * from "KGDB"."PRN_BIZ_INFO" sample block( 10.85) mytab
采样表应当使使用了某些管理工具产生的
你可以查询
select distinct module from gv$session
select distinct module from DBA_HIST_ACTIVE_SESS_HISTORY
收集下系统里都有哪些工具

执行之后怎么办呢