Which two inferences can definitely be made from this o…

Examine the partial TKPROF output for an SQL statement:Which two inferences can definitely be made from this output? (Choose two.)

Examine the partial TKPROF output for an SQL statement:Which two inferences can definitely be made from this output? (Choose two.)

A.
Array fetch operations were not performed for this query.

B.
No hard parse was performed for this query.

C.
The number of logical I/Os is almost equal to the number of physical I/Os.

D.
Another transaction held a shared lock on the table, thereby causing a significant delay.



Leave a Reply 0

Your email address will not be published. Required fields are marked *