Re: how to determine free memory in Oracle

Ari Kaplan (akaplan_at_interaccess.com) wrote:
: Gregory Bronevetsky (bronevet_at_beast.Trenton.EDU) wrote:
: : I'm writing a Web front for an Oracle database. To do this, I need to
: : create and keep a lot of views and since a lot of people may be using the
: : system at the same time, I need to know how much memory the database
: : server has left for my views so that I can know if creating another view
: : will go over the memory limit. Is there any way to get this information?
: : --
: : Greg Bronevetsky
: To see what memory you have, type:
 

: select * from v$sga;
 

: For a more detailed analysis, type:
 

: select * from v$sgastat;
 

: The item for "free memory" shows the free memory. One thing though -
: adding a view will not really affect the memory. Objects are phased out of
: memory to a LRU algorithm. To adjust memory in Oracle, adjust the three
: parameters: sort_area_size, shared_pool_size, and db_block_buffers.
 

: -Ari Kaplan
: Independent Oracle DBA Consultant
 

: <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
: <-> For 90+ Oracle tips, visit my Web Page: <->
: <-> <->
: <-> http://homepage.interaccess.com/~akaplan <->
: <-> <->
: <-> email: akaplan_at_interaccess.com <->
: <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

--
			Greg