Oracle Applications R12: More Schema Analysis

More analysis of the Oracle Applications R12 sample database, VIS.
LOTS of: Objects, Packages, Triggers by Table, and Source Code

The schema, APPS owns: 51284 PACKAGE BODies, 32991 VIEWS, 4183 TRIGGERs

There are over 57 million lines of source code in the APPS schema alone!

Continue Reading →

Stamping Out Cartesian Products

A cartesian product in a single query can make the whole server go slow. The other problem is the result sets, which come back many multiples too big.

No gizmo tool will help you with a cartesian product. No query analyzer will tell you that you have a problem, or how to fix it. Cartesian products are one problem area that only observation, knowledge, and good SQL skills will overcome.

Continue Reading →