Learn how to a build a cloud-first strategyRegister Now


Unwritten Logs in Oracle

Posted on 2012-08-23
Medium Priority
Last Modified: 2012-09-20
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?
Question by:gram77
  • 3
  • 2
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38325759
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?

Author Comment

ID: 38326032
I was told it was due to faulty index in the table. But what has index to do with write operation?
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 38326201
>>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.

Author Comment

ID: 38334045
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?
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38336242
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.

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses

804 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question