HPE Community
Operating System - HP-UX
1751720 Members
6147 Online
108781 Solutions
New Discussion

Re: How to determine memory used

 
SOLVED
Go to solution
MANOJ SRIVASTAVA
Honored Contributor

‎07-13-2001 10:04 AM

‎07-13-2001 10:04 AM

Re: How to determine memory used

Thanx Scot


Manoj
0 Kudos
Reply
Brian Crabtree
Honored Contributor

‎07-16-2001 07:04 PM

‎07-16-2001 07:04 PM

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.
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.