Which two inferences can definitely be made from this o…

Examine the partialTKPROFoutput for an SQL statement:

Which two inferences can definitely be made from this output?(Choose two.)

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.



Leave a Reply 7

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


vasya

vasya

imo
A – right, because fetch count (1) equals to fetched rows (1).
C – right, because disk is almost identical to query+current

vasya

vasya

agree, B and C
B because Missed in library cache = 0 meaning no hard parse occured

vasya

vasya

yes, tricky question, A, B and C are all okay…

RobSala

RobSala

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!

Fonx

Fonx

BC

right with RobSala