command to find the allocated memory size in oracle

[former_member190251]

Hi,

Please let me know the command to check the allocated memory in oracle and also let me know whether we need to add pga+SGA for the total memory size allocated to oracle.

Regards

Subbu

[Former Member]

Hello Subbu,

You can find the allocated memory by either of the following :

1. show sga at sqL prompt

2. displaying contents of view v$sga (same as show sga) or v$sgainfo (if you require component wise memory allocation)

The PGA allocation is dynamic. As per SAP Note 789011, you can find the current PGA loocation by using the view v$pgastat.

for total memory allocated to oracle you need to mainly consider process memory, PGA and the sizes of shared pool and buffer pool

Thanks and Regards,

Anjali

[Reagan]

Hello

Read this SAP note

789011  - FAQ: Oracle memory areas

whether we need to add pga+SGA for the total memory size allocated to oracle.

Yes.

show parameter SGA

show parameter PGA

Regards

RB

[former_member206552]

good day,

you can use "show sga" in sqlplus

14:36:18 SQL> show sga

Total System Global Area 6747725824 bytes
Fixed Size                             2239272 bytes
Variable Size                       2181039320 bytes
Database Buffers              4546625536 bytes
Redo Buffers                      17821696 bytes
14:36:20 SQL>

you can also use the followin glink with a query,

https://forums.oracle.com/thread/938686

for further analysis you need to check the EWA or trouble shoot oracle

http://docs.oracle.com/cd/B28359_01/rac.111/b28252/racmon2.htm

Best Regards

Marius