If I am posting a question about Oracle SQL query performance, what should I include in my question?

Question

If I submit a query about an Oracle database query, what should I include in my question so that people can answer me? How do I get this information?

Simply executing a poorly executed query may not be enough.

Answer 1

Ideally, get a complete query plan using DBMS_XPLAN.DISPLAY_CURSOR using sql_id and child_cursor_id from v $ sql. Otherwise (for example, in older versions) try v $ sql_plan and enable the filter and access predicates. EXPLAIN PLAN is excellent if the plan that was used is actually displayed.

DB (//). , . SELECT * FROM V $VERSION

, ( - ). * v $, rownum < 5 isdefault!= 'TRUE'; *    10053 , 1 ' , , , *

(, , 30% "" ..). USER_TABLES, USER_TAB_COLUMNS.

, SQL, ( , ) v $sql.

, , . , , .

Answer 2

• .
• , .
• , .

Answer 3

Request Plan Always Helpful