• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 388
  • Last Modified:

Unwritten Logs in Oracle

I have a proc which writes to a log file.

Sometimes i see that log is not written even through the procedure ran successfully. I know
since tables are populated.

What can be the reason behind this?
0
gram77
Asked:
gram77
  • 3
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
We would probably need to see the code but could it be some exception after the update but before the log write?

Is it possible that log is getting over-written?  Possibly with the procedure being run twice at the same time?
0
 
gram77Author Commented:
I was told it was due to faulty index in the table. But what has index to do with write operation?
0
 
slightwv (䄆 Netminder) Commented:
>>But what has index to do with write operation?

It depends.  If the bad index caused some error, it might raise an error after the update and before the write.

If you were told why it didn't write to the log, whoever told you this should be able to explain why the update worked and the write didn't.
0
 
gram77Author Commented:
During an insert what will be updated. As i know during an insert both table and index will be inserted with the row. What will be updated here?
0
 
slightwv (䄆 Netminder) Commented:
I was using 'update' as a general term for a change to the database.  I don't know what your procedure does before it inserts into the log.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now