Page History

...

SQL statements in Precise for Oracle are assigned a numeric identifier (a 20-digit number that is divided into 4 sections, with dot separators) or a user-defined name. The numeric identifier is similar to, but not the same as, the hash value that Oracle assigns to a SQL statement. When Precise for Oracle calculates the numeric identifier, it ignores white space and case, unlike Oracle. It also takes into account whether Collapse Statements is switched on, in which case string literals are replaced with place holders or pseudo-bind variables.

Anchor
Executionsvsopensandfetches Executionsvsopensandfetches

Executions vs. opens and fetches

Precise for Oracle employs the following methods to determine how many times a statement has been executed.

...