Database Tuning (MOSC)

MOSC Banner

Auto Space Advisor for tablespace fails with "FATAL ERROR" - but blank error msg

About once a week the sys autotask: Segment Advisor Auto Space Advisor for tablespace fails with "FATAL ERROR". It shows in OEM 13c and also in the awrinfo.txt for the target. We recently upgrade to 19c and patched to 19.11 but I cannot tell how old this issue is.

snippet from awrinfo.txt:

Description: Auto Space Advisor for tablespace                                                                              

Error Msg :                                                                                                                

SYS/Segment Ad 194077/SYS_AUTO_SPCADV5410702220 02:07:41 (07/22)                      CMD  FATAL ERROR                    

       72021                                                                                                        

Description: Auto Space Advisor for tablespace                                                                              

Error Msg :                                                                                                                

                                                  

Where can I find information on this error? The job runs successfully most of the time and only fails when running the advisor for tablespace and not the other segment advisors.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center