Re: PLEASE help me understand this 'mysterious' problem?????

From: Sanjay D. Shitole <sanjay_at_mvsn.com>
Date: 1998/03/20
Message-ID: <351339D2.FD1A0F3@mvsn.com>#1/1

Is there a profile set for this user ? It is possible that after max_idle_time (One of the resource limit parameters) the session gets logged off and all pending transactions are rolled back. There is no reason why rows should get deleted if a commit was issued after completion of the transaction.

hope this helps
regards
sanjay d. s.

Gregory Wood wrote:

> I'm working on an oracle PL/SQL system. When a user logs onto
> the system, some information is put in a table. If the close the
> application without 'logging off', the information is kept in the table, but
> every hour it is DELETED! There are no procedures in DBMS_JOBS that are
> causing this. It also doesn't seem that there is a cron job doing it.
> There are no triggers attached to the table either.
>
> What is causing the hourly deletions?????
>
> Thanks
>
> Greg
> email: woodg_at_mantech-wva.com
Received on Fri Mar 20 1998 - 00:00:00 CST