CTXSYS

Hello,

EBS 11.5.10.2

RDBMS 9.2.0.8.0

In these last days i'm facing a problem of twio session of the module FNDGSCST which are dealing with CTXSYS  schema data.

and these two session are taking a lot of time.

one session is blocking the other because of a delete :

DELETE CTXSYS.DR$PART_STATS  WHERE IDX_ID = :1 AND IXP_ID = :2

and the second is executing a PLSQL BLock:

BEGIN

   :retval :=

      "CTXSYS"."TEXTOPTSTATS".ODCIStatsCollect (:idx_info,

                                                :stat_opt,

                                                :stats,

                                                :env);

END;

• What is exactly that schema CTXSYS ? why it's gathering statistics is taking a lot of time ? I tested to gather stats on that schema in a test environnement and it took vfew minutes !