SQL Tuning - Expert Oracle RAC Performance Diagnostics and Tuning - page 198

1

OPEN

2

PARSE

yes

3

yes QUERY? yes DESCRIBE? yes DESCRIBE MORE?

no

no

4

DEFINE

yes

no MORE?

REPARSE? no BIND? yes BIND

5

yes

no no MORE?

EXECUTE

PARALLELIZE

6

yes

7

yes FETCH

QUERY?

8

no yes

EXECUTE
OTHERS?

no MORE?

no

9

CLOSE

Figure 7-1. Parse operation flow diagram