March 16th, 2011

Terrifying Execution Plan with cost of 18E (exa)

The newest piece of my bloomer collection is a query with an execution plan that has 18E of cost. I am no believer in absolute cost numbers, but this one is just nice.

This exa-executionplan is the new definition of Exadata….

Keep your fingers off ;)
Usn


By usn in Oracle 



You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “Terrifying Execution Plan with cost of 18E (exa)”

  1. usn Says:
    March 16th, 2011 at 11:18 am

    Solution:
    The view used was flooded with USE_NL hints. We removed them, and this masterpiece works.

    Learn: Trust your CBO…

    Martin

  2. alex Says:
    March 16th, 2011 at 12:57 pm

    what’s time of exec?

  3. usn Says:
    March 16th, 2011 at 5:31 pm

    It failed due to overflooding of the temp tablespace. :)
    But I guess: “ages”

    Greets
    Martin

Leave a Reply