Performance - EBS (MOSC)

MOSC Banner

Errors while running SQLT (XTRACT method)

edited Apr 27, 2017 5:01AM in Performance - EBS (MOSC) 1 commentAnswered

Hi,

     I am getting the errors while running sqlt (XTRACT method):

sqlt$a: *** i:"EXPLAIN PLAN FOR" this SQL errored out when executed connected as "ARWACPT". Always execute SQLT connected as the application user.

sqlt$a: *** i:ORA-00905: missing keyword

The tool was executed under the correct ID:

  4  SQL>SELECT USER FROM DUAL;

  5  USER

  6  ------------------------------

  7  ARWACPT

It looks like the error originates in install/sqcpkgi.pkb file:

BEGIN

        l_error := NULL;

        l_string := 'EXPLAIN PLAN SET statement_id = '''||sqlt$a.get_statement_id_c(p_statement_id)||''' INTO &&tool_repository_schema..sqlt$_sql_plan_table FOR';

        l_sqltext := SYS.DBMS_LOB.SUBSTR(sql_rec.sql_text_clob_stripped); -- first up to 32666 characters

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

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center