-
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,
-
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|