nerdexam
Oracle

1Z0-064 · Question #49

Examine the Load Profile section of an AWR report: Which two inferences can you derive from the details in this section? (Choose two.)

The correct answer is B. The values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite D. The values for SQL Work Area and User calls imply that only sort-based operations were. See the full explanation below for the reasoning.

Question

Examine the Load Profile section of an AWR report:

Which two inferences can you derive from the details in this section? (Choose two.)

Exhibit

1Z0-064 question #49 exhibit

Options

  • AThe values for Redo size and Block changes imply that only updates were performed by
  • BThe values for Parses (SQL) and Hard parses (SQL) imply that cursor sharing occurred quite
  • CThe values for DB Time and DB CPU imply that the database had a high proportion of idle time
  • DThe values for SQL Work Area and User calls imply that only sort-based operations were
  • EThe values for Logical reads and Physical reads imply that the number of disk reads per second

How the community answered

(60 responses)
  • A
    10% (6)
  • B
    83% (50)
  • C
    3% (2)
  • E
    3% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-064 Practice