I am working on oracle 22.214.171.124 version and AIX.
We have a scheduled job to gather table stats.The job is runing very slow , it is taking time to gather stats of all tables.
Same database in other oracle vesion job is runing fine.
Is this oracle vesion is having any bug ,so gather table stats are slow ?
or how to check why it is running very slow...
Refer to Bug 6655241 - DBMS_STATS slow gathering statistics on table with a LOB column [ID 6655241.8] Bug 12833442 - slow gathering of statistics on subpartitioned tables with incremental and concurrent mode on. [ID 12833442.8]