Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmasmnth

You want to monitor how a large production table is accessed.

You want to monitor how a large production table is accessed. Especially, you are interested to see how the access on that particular table leverages the benefits of the Exadata Platform.

Which two actions are NOT appropriate for that purpose?

A.

YOU query VSSYSTEM_EVENTS and filter for the event 'cell physical IO interconnect bytes returned by smart scan', associated to your table.

B.

You query v$segment_statistics and filter for the Object ID of your table from dba_objects and the the column STATISTIC_NAME='optimized physical reads'.

C.

You query v$SYSTAT and filter for the statistic 'cell smart table scan', associated to your table.

D.

You run the CellCli-command list activerequest , filtering for the attributes ioReason and objectNumber, that you specify as 'Smart Scan' and the Object ID of your table from DBA_OBJECTS.

Oracle 1z0-902 Summary

  • Vendor: Oracle
  • Product: 1z0-902
  • Update on: Jul 30, 2025
  • Questions: 85
Price: $52.5  $149.99
Buy Now 1z0-902 PDF + Testing Engine Pack

Payments We Accept

Your purchase with ExamsVCE is safe and fast. Your products will be available for immediate download after your payment has been received.
The ExamsVCE website is protected by 256-bit SSL from McAfee, the leader in online security.

examsvce payment method