You observed in your database that the queries formerly executed in 5 seconds now take longer time.View the Exhibit and analyze the output of the query that you executed to find the problem.
Which is the primary concern?
A.
the number of disk sorts
B.
the number of full table scans
C.
the number of chained and migrated rows
D.
the number of rows fetched based on rowid
Table fetch by rowid = 220813
Table fetch continued row = 132046, over half the count.
Assuming the table involved doesn’t have large data columns (where this would be expected), then this is indicative of row data not fitting into a single block (chained/migrated rows) for some reason.