SQL Performance (MOSC)

MOSC Banner

While running SQLTEXTRACT getting the below error . Please advice

SQL> @sqltxtract.sql




PL/SQL procedure successfully completed.




Parameter 1:

SQL_ID or HASH_VALUE of the SQL to be extracted (required)


Enter value for 1: 2dn78wg5jp40p


Describe the characteristic of this run


"F[AST]"       if you have a FAST run

"S[LOW]"       if you have a SLOW run (default)

"H[ASH]"       if this is a run with a HASH JOIN

"N[L]"        if this is a run with a NESTED LOOP

"C[OLUMN HISTOGRAM]" if this is a run with a Column Historgram in place


SQL Description [S]:


PL/SQL procedure successfully completed.




Paremeter 2:

SQLTXPLAIN password (required)


Enter value for 2: SQLTXPLAIN

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