Database Tuning (MOSC)

MOSC Banner

Unable to run Segment space advisor Manually in the 19c Database

edited Feb 10, 2021 11:45PM in Database Tuning (MOSC) 9 commentsAnswered

Hi Team,

I am facing below error when I am running segment space advisory manually in the 19c database.

Please check below error and let me know if it has any workaround


ERROR at line 1:

ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_ADVISOR", line 226

ORA-06512: at "SYS.PRVT_ADVISOR", line 3546

ORA-06512: at "SYS.PRVT_ADVISOR", line 932

ORA-06512: at "SYS.WRI$_ADV_OBJSPACE_TREND_T", line 1204

ORA-06512: at "SYS.WRI$_ADV_OBJSPACE_TREND_T", line 1870

ORA-06512: at "SYS.PRVT_ADVISOR", line 915

ORA-06512: at "SYS.PRVT_ADVISOR", line 3451

ORA-06512: at "SYS.DBMS_ADVISOR", line 276

ORA-06512: at "SYS.DBMS_ADVISOR", line 221

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