Database Administration (MOSC)

MOSC Banner

How to know SGA and PGA size is insufficient?

edited Apr 2, 2018 5:24AM in Database Administration (MOSC) 4 commentsAnswered ✓

Hi,

We are using Oracle 11.2.0.3 with automatic memory management. Only one instance is running in the box. The box has a RAM of 68 GB. SGA target is set at 58 GB and PGA target also at 10 GB.

1)  we want to know if the how much SGA and PGA memory is sufficient to Oracle. What is the definitive indicator that shows us there is / is not memory contention?

Following are some of details from awr output taken during a period of 15 minutes interval:

Top 5 Timed Foreground Events

    EventWaitsTime(s)Avg wait (ms)% DB timeWait Class
    log file sync9,695,881677,8917032.52Commit

    Howdy, Stranger!

    Log In

    To view full details, sign in to My Oracle Support Community.

    Register

    Don't have a My Oracle Support Community account? Click here to get started.

    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