SQL Performance (MOSC)

MOSC Banner

Custom query take more than one action plan and take a long time to finished with some action plan

Diego Mangano
Diego Mangano Posts: 76 Blue Ribbon
edited Aug 14, 2014 9:11AM in SQL Performance (MOSC) 1 comment
Tagged:

Comments

  • Tedper-Oracle
    Tedper-Oracle Posts: 2,208 Gold Trophy - Community Leader

    Hi,

    I would recommend that you create an accepted and enabled SQL plan baseline for plan hash value 1759379301 from AWR, as explained in Note 789888.1 (license for diagnostics pack required).

    Sincerely,

    Ted

    Oracle Support Services

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center