Every call to a procedure or function causes a slight, but measurable, performance overhead, which is especially noticeable when the subprogram is called within a loop. Automatic subprogram inlining can reduce the overhead associated with calling these subprograms, a new optimization feature added in Oracle Database 11g. In this workout, Tim Hall guides you through the feature, with lots of examples. We then add a link to the PL/SQL optimizer, and finish up with some quizzes, courtesy of Steven Feuerstein.