Start a new topic

700.1475 - "User" view modified using dbms_xplan.display_cursor

[This topic is migrated from our old forums. The original author name has been removed]

Hi Roger, I modified the Active SQL view a little so it uses dbms_xplan.display_cursor to show the sql and the plan. added modified a little This is the active SQL being executed for this session.

[This reply is migrated from our old forums.]

Re: 700.1475 - "User" view modified using dbms_xplan.display_cursor
Ronald, This is now fixed with a new "Plan Data" tab in 7.0.5. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: 700.1475 - "User" view modified using dbms_xplan.display_cursor
Roger, it shows where the plan came from. It could be a fresh parsed plan, a stored outline, a sql profile or a sql baseline. It is getting more and more important to know where it came from. In 11g, simply adding an index does not automatically mean that it is going to be used, even when it would have been a brilliant choice. Being able to see what caused the session to pick a plan can help preventing poor old dba's from going mad.... best regards, Ronald - wearing his new t-shirt :-D
[This reply is migrated from our old forums.]

Re: 700.1475 - "User" view modified using dbms_xplan.display_cursor
Hi Ronald, Just checked the updates you added for presenting DBA Views->Sessions->Active SQL. I cannot see any major difference compared to the previous display. What is the main advantage using dbms_xplan in this case? Regards Roger