SQL Performance (MOSC)

MOSC Banner

How do I run the SQL Advisor without Enterprise Manager and for a specific SQL_ID ?

edited May 23, 2013 4:33AM in SQL Performance (MOSC) 5 commentsAnswered ✓
Hello,

How do I run the SQL Advisor using sqlplus?

Let me explain. I cannot use Enterprise Manager console because the system administrator doesn’t allow to keep the port open.

I ran the ADDM Report using TOAD and I found “      Ejecute el Asesor de Ajustes SQL en la sentencia SELECT con SQL_ID "by3trvsknawq8"  I translate this in “Use SQL Advisor using SQL_ID "by3trvsknawq8" ……. How can I use the SQL Advisor specifically for this SQL_ID?

How do I run the SQL Advisor without Enterprise Manager and for a specific SQL_ID ?

The vesion of the database is 11.2.0.1.0

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