Database Tuning (MOSC)

MOSC Banner

Oracle execution plan in order

edited Aug 30, 2023 12:10PM in Database Tuning (MOSC) 2 commentsAnswered

As I know everyone is aware, there are quite a few ways to gather an execution plan from a SQL that has executed. I prefer the display_cursor procedure of DBMS_XPLAN or the SQL active monitoring reports as they show the actual execution plan generated for a SQL as opposed to an EXPLAIN PLAN which can be wrong, well not the plan ultimately used by a SQL statement. In any event, I can't seem to find any tool which generates the plans in order in which the row sources/operations are executed. All of these methods just seem to return the execution

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