Recent content by rjacoby

  1. R

    Explain plan window not showing cost

    Oh yeah, it's against Oracle 9.0.2.
  2. R

    Explain plan window not showing cost

    Hi all, I've tried with both per-user PLAN_TABLE and a SYS synonym, to no luck. I can run the explain plan window, and get the plan, but the "COST", "CARDINALITY" and "BYTES" columns are empty. The user has privileges on the PLAN_TABLE and is granted the PLUSTRACE role. What's missing?
Back
Top