Database Reference
In-Depth Information
SQL Trace
As described in Chapter 2, to process a SQL statement, the database engine (specifically, the SQL engine) carries out
database calls (for example: parse, execute, and fetch). For each database call, as summarized in Figure
3-2
, the SQL
engine either
•
does some processing itself, by using CPU;
•
makes use of other resources (for example, a disk); or
•
has to go through a synchronization point needed to guarantee the multiuser capabilities of
the database engine (for example, a latch).
