1 of 1 people found this helpful
Here is the query I see running in my environment. However, I think it depends on how the alert is configured as to how the ObjList is built out.
A quick trace may reveal more details.
dbms_stats.gather_database_stats(objlist=>ObjList, options=>'LIST AUTO');
FOR i in ObjList.FIRST..ObjList.LAST
Thanks for the help. That is exactly what I was looking for.