Database Administration (MOSC)

MOSC Banner

DBMS_XPLAN.Display_Cursor() not working all the time

edited Nov 30, 2022 10:37AM in Database Administration (MOSC) 15 commentsAnswered ✓

Oracle EE RAC on 12.1.0.2 (ODA X5-2).

Have a PL/SQL package creating a CTAS DDL and executing it dynamically (using execute immediate).

The very next statements executed are for instrumentation. Get the row count from the cursor for the table created by reading SQL%RowCount into a variable. Always works.

Then get the cursor's execution plan via DBMS_XPLAN.Display_Cursor().

It works fine most times. However, no execution plan is returned for specific CTAS DDLs that use a significant number of PQ slaves (32+) on significant data volumes (reading billions of rows via FTS). I tried alternative methods like searching thru the shared pool (e.g. using

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