Re: Memory leaking when creating views

When you are talking about the problem of "deletes the least used sequence numbers" when running out of memory I think you are referring to sequence number that seem to be losing or skipping numbers.

What actually happens here is that these sequence numbers are not being used very much and are put at the end of the LRU list and eventually get flush out of the SGA. At this point they litterally lose all the numbers that are cached for that squence.

The only way to avoid this problem is to alter the sequences with the problem with ALTER SEQUENCE <SEQUENCE_NAME> NOCACHE;

This will be a little bit slower that having the numbers cached but you will not lose numbers where it is important like invoices.

Shawn

Sam Habbab wrote:
>
> Hi,
>
> I'm just wondering if there is any danger in creating as many views as
> one sees needed.
> So far my system has about 20 views.
>
> If the database runs out of memory, I think it deletes the least used
> sequence numbers. This can be solved by forcing the numbers to remain
> persistent.
>
> Do I have to worry about the same problem when it comes to views?
>
> Thanks.
>
> S_at_M
Received on Wed Aug 23 2000 - 22:28:45 CDT