:[EMAIL PROTECTED]
Sent: 24 June 2003 20:59
To: Multiple recipients of list ORACLE-L
Subject: RE: log for transaction
We use a similiar method which involves inserting periodic
rows into a log
table, which is dumped to a file at end-of-job.
Scott Shafer
San Antonio, TX
210.581.6217
20:59
To: Multiple recipients of list ORACLE-L
Subject: RE: log for transaction
We use a similiar method which involves inserting periodic
rows into a log
table, which is dumped to a file at end-of-job.
Scott Shafer
San Antonio, TX
210.581.6217
-Original
Hi there,
I got a question on log. If my program crashes, can I check some log to see what
recent transaction is? It will give me a big help on trouble shooting.
Thanks,
Jin
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network
Oracle does not have any ready-made logging process to assist you.
Some of our developers have utilized 'utl_file' to track the progress of their long
running jobs.
Entries are made to the job log file at proper intervals to tell them what happened in
case the
job aborted.
- Kirti
---
To: Multiple recipients of list ORACLE-L
Subject: Re: log for transaction
Oracle does not have any ready-made logging process to assist you.
Some of our developers have utilized 'utl_file' to track the progress of
their long running jobs.
Entries are made to the job log file at proper intervals