Re: how to determine free memory in Oracle

From: Ari Kaplan <akaplan_at_interaccess.com>
Date: 1997/07/31
Message-ID: <5rq8mh$42l@nntp.interaccess.com>#1/1

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                    <->

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Received on Thu Jul 31 1997 - 00:00:00 CDT