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

From: Julio <julio.negueruela_at_si.unirioja.es>
Date: 1998/03/26
Message-ID: <351AA57E.3E2A@si.unirioja.es>#1/1

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 ar
e
> 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?????

A reason might be that the transaction is not commites and if you close the aplication without logging off the session still remains in Oracle. After a time the Pmon determines that the session has been anormally finished and then rollbacks the non-comitted transactions.

> Thanks
>

> Greg
> email: woodg_at_mantech-wva.com

Regards.

-- 

Julio Negueruela
DBA    Servicio Inform tico
Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180
mailto:julio.negueruela_at_si.unirioja.es

Received on Thu Mar 26 1998 - 00:00:00 CST