Examine the partialTKPROFoutput 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.
imo
A – right, because fetch count (1) equals to fetched rows (1).
C – right, because disk is almost identical to query+current
B,C
agree, B and C
B because Missed in library cache = 0 meaning no hard parse occured
imo A,B
yes, tricky question, A, B and C are all okay…
Cannot tell whether A is correct or wrong as we are getting only one row in one single fetch!
D – we do not have sufficient information
B is right as no misses
C is also right as 31 disks close to 31+3 as this 31+3 could include reads from datafiles and/or rollback segments!
BC
right with RobSala