SQL Performance (MOSC)

MOSC Banner

EM Task SQL Access Advisor ORA-6515 ORA-00604 ORA-01001 ORA-01405

edited Sep 6, 2019 5:01AM in SQL Performance (MOSC) 1 commentAnswered

Good day, when starting a SQL Access Advisor job, an error occurs, and only for indexes, if you run the task for 1-2 tables everything goes away, and with the prefix NAME% error. Moreover, the error first occurs in the EM interface, and only then, after some time, in the alert log

EM:

Advisor Central  >  Results for Task: SQLACCESS6138865

Results for Task: SQLACCESS6138865

Task Name

SQLACCESS6138865

Started

14-Aug-2019 12:25:03 o'clock GMT+03:00

Status

EXECUTING

Ended

Advisor Mode

LIMITED

Running Time (seconds)

Scheduler Job

ADV_SQLACCESS6138865

Total Time Limit (minutes)

1500

Publish Point

0Interrupt

ption

Value

Description

Advisor Mode

Limited

Specifies the mode in which SQL Access Advisor will operate during an analysis, either limited (quicker results) or comprehensive (higher quality recommendations)

Tagged:

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