How memory allocated to ORACLE in ECC 6.0

[Former Member]

Hi experts,

i have installed ecc 6.0 system on oracle 10g on RHEL5.

server RAM is 16 GB. ecc 6.0 only CI is installed. i want to know how much RAM is allocated to database. so that according we can change the oracle  buffer related parameter.

Regards,

[Former Member]

Hi Vivek,

To see the SGA parameters, execute the command, below;

SQL> show sga

To configure the SGA buffer, you can set the "db_cache_size" parameter. SGA consist the different memory blocks, changed dynamically.

On the other side, you can set PGA by "pga_aggregate_target" parameter, but the system can allocate more memory than your value. This memory parameter is only the target value and managed by the Oracle automatically.

There's one another memory block named as UGA (user global area). So, you can find the further information over the internet, easily.

Best regards,

Orkun Gedik

[Former Member]

vivek BASIS wrote:
i want to know how much RAM is allocated to database.

Oracle memory consists of SGA, PGA and processes memory (code,data,stack sections). Check relevant parameters to SGA and PGA in spfile. You can control only these parameters

Regards

Roman