how to find pid which spam to alert log
if u dont know who is spamming to alert log there is the way to figure out this and it’s Flasback process =) ps:oracle 12.1
oracle12c
oracle12c how-to get detailed info about gather stat job
from oracle 12c it is possible to find out detailed information about gather stats job in em you may find it at or use dbms_stats.report_* to get info detailed at https://docs.oracle.com/database/121/TGSQL/tgsql_astat.htm#TGSQL95102 I use it this way: