How could I know how much memory is allocated by Oracle

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[JPReyes]

What version of SAP are you using?.. it certainly exist!... try ST04 (without the N)

Regards

Juan

[Former Member]

Hi,

In Netweaver 7.0 systems, ST04 calls DBACOCKPIT and goes directly to the DB Performance view.

Regards,

Olivier

[JPReyes]

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