Oracle
1Z0-064 · Question #40
Examine the partial TKPROF output for an SQL statement: Which two inferences can definitely be made from this output? (Choose two.)
The correct answer is B. No hard parse was performed for this query. D. Another transaction held a shared lock on the table, thereby causing a significant delay. See the full explanation below for the reasoning.
Question
Examine the partial TKPROF output for an SQL statement:
Which two inferences can definitely be made from this output? (Choose two.)
Exhibit
Options
- AArray fetch operations were not performed for this query.
- BNo hard parse was performed for this query.
- CThe number of logical I/Os is almost equal to the number of physical I/Os.
- DAnother transaction held a shared lock on the table, thereby causing a significant delay.
How the community answered
(47 responses)- A17% (8)
- B72% (34)
- C11% (5)
Community Discussion
No community discussion yet for this question.