Skip to Content
avatar image
Former Member

command to find the allocated memory size in oracle

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 18, 2013 at 01:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 18, 2013 at 02:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 06, 2013 at 08:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded