SQL Performance (MOSC)

MOSC Banner

Is the SYS_AUTO_SQL_TUNING_TASK (12.1) useless when SYS is unable to set the underlying VPD policy t

edited Jun 1, 2017 5:00AM in SQL Performance (MOSC) 3 commentsAnswered

Is the SYS_AUTO_SQL_TUNING_TASK (12.1) useless when SYS is unable to set the underlying VPD policy that exists in nearly every application query? Note 1440205.1 suggests that there are issues. I see ORA-28113 in the trace files because SYS execution of the app queries results in "WHERE vpd_col IN " which results in a ORA-00936: missing expression. App users set a context that result in "WHERE vpd_col = some_number ". SYS_AUTO_SQL_TUNING_TASK runs for a solid hour and produces no meaningful application based results.

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