Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

How to determine memory used

SOLVED
Go to solution
Glenn Couture
Occasional Advisor

How to determine memory used

I dont have root. How can I tell how much physical memory is being used. My sysadmin is clueless.
11 REPLIES
Paula J Frazer-Campbell
Honored Contributor

Re: How to determine memory used

Hi

Top

Paula
If you can spell SysAdmin then you is one - anon
Paula J Frazer-Campbell
Honored Contributor

Re: How to determine memory used

Hi

Also

swapinfo -M

HTH

Paula
If you can spell SysAdmin then you is one - anon
Glenn Couture
Occasional Advisor

Re: How to determine memory used

The numbers are not adding up. I know there is 4 gigs on the box..yet free and used dont add up to 4 gig.

Thanks for your reply
James R. Ferguson
Acclaimed Contributor

Re: How to determine memory used

Hi:

# grep -i physical /var/adm/syslog/syslog.log

...will work if the log hasn't been trimmed.

...JRF...
Ajitkumar Rane
Trusted Contributor

Re: How to determine memory used

Hello,
I dont think swapinfo will run without root acess. Top should do. Also you can run glance/gpm if installed on your system. Also you have vmstat.

Goodluck
Amidsts difficulties lie opportunities
Glenn Couture
Occasional Advisor

Re: How to determine memory used

Thanks for the help. I cant run swapinfo, the sysadmin let glance lisc. expire. The grep from the syslog did show memory at startup, but before oracle was running. Top info does not add up to 4 gig, but does show 2.5 gig free. Is it then safe to assume 1.5 gig used? Also vmstat does not add up to 4 gig.
James R. Ferguson
Acclaimed Contributor

Re: How to determine memory used

Hi (again):

Oh, sorry, of course, 'syslog' shows physical memory not dynamic. No points for misreading the question please!

...JRF...
MANOJ SRIVASTAVA
Honored Contributor

Re: How to determine memory used

Hi Glenn

I am attaching a c program which i got from the forums yesterday. It is attached to the answer , just downlad it to the Pc , ftp it to the server. and then compile it using
( first rename the source from memuse.txt to memuse.c)

cc memuse.c -o memuse

change the permissions to 777 and run it as an excutable.

Nice program comes out witht the memory usage .

Manoj Srivastava
Scott Robertson
Occasional Advisor
Solution

Re: How to determine memory used

If you liked my memuse.c program, give this one a try.

cc memdetail.c -o memdetail
*formally known as srobertson@bcbsga.com
MANOJ SRIVASTAVA
Honored Contributor

Re: How to determine memory used

Thanx Scot


Manoj
Brian Crabtree
Honored Contributor

Re: How to determine memory used

If you are looking for the amount of memory Oracle is currently using, you can query the database in the v$sga view from system or internal.

To calculate the space taken up by the database yourself, do this:

shared_pool_size+log_buffer+
(db_block_buffers*db_block_size)

This will give you a good approximation of the size of the database itself.