1

I'm trying to understand the performance characteristics of SQL statement that does DELETE cascade on 4 linked tables.

When I do the auto tracing of the statement it only shows me the DELETE statement executed on the table. It does not show details of deletes done on other tables.

Why doesn't SQL Developer show cascades in tracing?

1

Autotrace in SQL Developer gets you the v$sql_plan of your query and the session stats accumulated during the execution of your query - it does not show any recursive SQL that may get executed.

To see that you'd actually want to trace your session.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.