Forum Stats

  • 3,873,311 Users
  • 2,266,534 Discussions
  • 7,911,502 Comments

Discussions

SQL Baseline blacklist

chpo
chpo Member Posts: 1 Red Ribbon
edited Jan 11, 2016 5:44PM in Database Ideas - Ideas

Hi everyone,

Although we all database engineers do trust the Oracle optimizer to do its job (and it usually does) there some rare occasions, where the optimizer fails do predict the actual cost of a statement and chooses a sub-optimal plan that has a lower cost than others which do perform faster. This problem is mitigated by using SQL baselines as we all know, but what is missing is the possibility to mark a specific plan as "bad" so that the optimizer can avoid it.

Thank you for your time,

Harris Porgiatzidis

DBA

ctrieb
2 votes

Active · Last Updated

Comments

  • ctrieb
    ctrieb Member Posts: 314 Gold Trophy

    This good idea is a product specific idea. Plaese move to the correct idea space.

  • GiancarloB-Oracle
    GiancarloB-Oracle Member Posts: 22
    edited Oct 17, 2015 6:00AM

    This good idea is a product specific idea. Plaese move to the correct idea space.

    I thought the same when I first saw the idea, but when I ckeched I have found "Ideas"

    are not activated in SQL MOSC community: 

    PS:

    A suggestion for  @user12045678. You may want to create a discussion,  in the

    community to advertise your idea. When you create this discussion I would uncheck the "Mark this discussion as a question" option.

  • ctrieb
    ctrieb Member Posts: 314 Gold Trophy

    I thought the same when I first saw the idea, but when I ckeched I have found "Ideas"

    are not activated in SQL MOSC community: 

    PS:

    A suggestion for  @user12045678. You may want to create a discussion,  in the

    community to advertise your idea. When you create this discussion I would uncheck the "Mark this discussion as a question" option.

    And OTN Database Ideas, for me this will be better as here.