Re: how to determine free memory in Oracle

On 29 Jul 1997 21:33:23 GMT, bronevet_at_beast.Trenton.EDU (Gregory Bronevetsky) wrote:

Creating views should not take much memory... However, executing a view could.

Database server uses lots of types of memory buffers... some fixed some variable. The fixed buffers, SGA, can be customized by the DBA. However, the pre-process memory varies with each SQL call. Some SQL calls require more memory than the other (depends on the size of the dataset). This size of the variable memory is limited only by the System. Also, there is no way to predict the size of this memory in a multiuser environment.

I am not sure whether I answered or qs or not... Reading your qs a second time makes me wonder when you refer to memory, do you mean RAM or the diskspace (tablespace).

-sm

>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 Bronetsky
Received on Fri Aug 01 1997 - 00:00:00 CDT