At 01:42 PM 7/05/2009, you wrote:

>> If you have "free memory", it has nothing to do with whether the database is working or not. Assuming you have Classic processes running (= users connected) then each process will be doing some kind of work and using resources. Each process will use memory (sometimes a lot, sometimes a little) for many other things besides the page cache.
>>
>> ./heLen
>>
>
>if i true understand my problem can happen when my memory (via number of process,type of process,and buffers) in not enogh
>for do all process is true ?

In short, yes. Resources are finite. So a process that asks the system for more memory, and is refused it because the resources are all in use, will crash. If that process dies in the middle of a write operation, there is potential for it to leave corruption. Another process doesn't come along and fix the broken stuff.

On sighting your stored procedures, which are (unnecessarily) using a huge amount of resource, I would not be surprised if that is the source of your problems.

./hb