Skip to Content
avatar image
Former Member

How could I know how much memory is allocated by Oracle

Hello

How could I know how much memory is allocated by Oracle. We are using 10.2.0.2(spfile). All memory shown in st06 (Phys mem available) .

Preferably I would like to look through DBACOCKPIT.

I assume I can memory shown in st06 spread to Oracle, extended memory, buffers(rest for os). Am I right?

However if I give all memory shown in st06 to em/initial_size_em system starts normaly (even when checked via sappfpar...). I do not understand it clearly

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 08, 2010 at 12:33 PM

    The memory usage of Oracle is basically defined by the parameters sga_max_size and pga_aggregate_target.

    Check with strings spfile<SID>.ora the values, and you have more or less your answer.

    Kind regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2010 at 11:03 AM

    Hi Jan,

    You can get that info on ST04N, beside the overview you can click on "detailed analisys" and look under "resource consumption" for more details

    Regards

    Juan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 07, 2010 at 10:09 PM

    ST04N does not exists. You probably mennt st03n.But under "detailed analisys" there is no"resource consumption"

    Add comment
    10|10000 characters needed characters exceeded