Using the explain plan question?

Toad for Oracle
1

Hi all
I'm having problems getting on to the TOAD.
I using version 11.5, call the explain plan then I can't find the cost in the result.
What should I do ?

Thanks!
Nick

1.png
1.png1306×160 5.23 KB

2

Right click on the Explain Plan and select Adjust Content. Check whether the Cost has been ticked and whether it is selected to be shown as a column.

3

Thanks for your reply, but I am follow you said the setting but it’s not working.
Nick
1.png

4

How about some of the other settings, like DBMS_XPLAN (under Display Mode). Do you still see no Cost value.

5

Dear Sir
I am set to Display mode->DBMS_XPlan not found the cost in there.

Thanks!
Nick

2.png
2.png504×733 10.6 KB

6

Hi All
Anybody can help me with the problem ?
Thanks
Nick

7

Hi all,

I have been fix the problem.
using the below:
select /*+ ALL_ROWS */ * FROM APP_USERS

Thanks!