• Is redo size affected by nologging indexes?

    Yury recently raised a topic about nologging segments in e-Business Suite database. The discussion later evolved to on how indexes are affected by the nologging setting (is it worth putting indexes in nologging mode to reduce the redo generation). I wasn’t quite sure about the answer, so I decided to test it myself. Read on for results of 22 short testcases (I think the results turned out to be quite interesting and worth knowing).

    Read on →

  • OOW2010! OCW2010?

    Good news, I’m going to attend OOW2010 this year!

    Read on →

  • How stored outlines saved the day

    Just before the last month closing in a 11i system running on 10.2.0.4 database some patches were applied to solve couple of critical functional issues. All went fine until the month closing processes were started. It turned out the patches introduced a new issue - this time it was a performance issue, that had managed to escape the testing efforts. This post is about how a workaround using stored outlines had been applied until a proper fix was implemented.

    Read on →

  • Verification of 11i Extended Support readiness

    It’s not a secret that 11i extended support starts November 2010 and the cost has been waived for the 1st year of the extended support. A month ago Oracle released the mandatory requirements for 11i systems to qualify for the extended support in Note 883202.1. The note contains a huge list of required patches for each module. As I still work with quite many 11i systems I transformed the note into several SQL queries that help identify the requirements that are not present, otherwise it’s a huge pain to walk through the note each time.

    Read on →

  • Can we trust AUTOTRACE?

    In short the answer is NO. I mean it is likely to be accurate in most of the cases, but there are situations when it dissplays different execution plan, not the one that’s really used to execute the SQL.

    Read on →