how to find memory allocation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to find memory allocation

  1. #1
    Join Date
    Jan 2003
    Posts
    141

    how to find memory allocation

    Hi,
    How to find how much memory is allocated for each database in a unix system.For eg. if i have 5 databases in a unix box.

    Many Thanks,

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    show sga

  3. #3
    Join Date
    Sep 2005
    Posts
    4
    Another way is

    $ ipcs -b
    IPC status from as of Sun Sep 25 09:57:32 GMT 2005
    T ID KEY MODE OWNER GROUP QBYTES
    Message Queues:
    T ID KEY MODE OWNER GROUP SEGSZ
    Shared Memory:
    m 15000 0xdad5be54 --rw-r----- oracle dba 2394947584
    m 3001 0xb4bae850 --rw-r----- oracle dba 2394947584

    T ID KEY MODE OWNER GROUP NSEMS
    Semaphores:
    s 3342336 0x629cbed0 --ra-r----- oracle dba 204
    s 720897 0x2d7076b8 --ra-r----- oracle dba 204
    s 65538 0xa98c92 --ra-ra-ra- root root 1
    s 65539 0x1a98c92 --ra-ra-ra- root root 1
    s 65540 0x2a98c92 --ra-ra-ra- root root 1
    s 65541 0xa9884c --ra-ra-ra- root root 1
    s 65542 0x1a9884c --ra-ra-ra- root root 1
    s 65543 0x2a9884c --ra-ra-ra- root root 1
    s 21 0x3ba9884c --ra-ra-ra- root root 1
    s 22 0x3ba98c92 --ra-ra-ra- root root 1

    This would show the amount of memory used for all the databases (if you have multiple databases on a single server).

    -Ritesh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width