Do stat on global temp will bring performance issue, so the following action is to delete them.
Deleted the statistics on the following below global temp tables:
DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname
=>'*_TEMP');
DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname
=>'*_TEMP');
DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname
=>'**_TEMP');
DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname
=>'**_TEMP');
DBMS_STATS.DELETE_TABLE_STATS ( ownname => 'BOM', tabname
=>'**_TEMP');
Profile
CST_GATHER_STATS=N
(**: Cost update- Gather Statistics) - This will
prevent stats
gathering on the GTT tables that might cause the performance
issue.