how to find memory allocation

[castlerock]

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,

[davey23uk]

show sga

[ritesh_das]

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