Oracle Exam 1Z0-902 Topic 4 Question 29 Discussion

Actual exam question for Oracle's 1Z0-902 exam

Question #: 29
Topic #: 4

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?

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

BYou 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'.

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

DYou 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.

Show Suggested Answer

Suggested Answer: A, E

According to the web search results123, the storage servers in an Exadata Database Machine are mainly used for processing data at the storage level and offloading some SQL operations from the database servers. Therefore, the two activities that are supported on the storage servers are:

A) changing the root password

E) configuring secure shell user equivalency for the cellmonitor user

https://docs.oracle.com/en/engineered-systems/exadata-database-machine/dbmso/exadata-introduction.html

by Albina at Oct 16, 2023, 09:06 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-902 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Simona

18 days ago

I disagree with both of you. Option A also seems relevant as it filters for 'cell physical IO interconnect bytes returned by smart scan', which is related to the Exadata Platform.

upvoted 0 times

...

Elly

19 days ago

I think B and D are the correct actions, as they focus on monitoring the Exadata Platform's specific performance metrics for the table.

upvoted 0 times

Wilford

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

upvoted 0 times

...

Shenika

23 days ago

I agree with Luis. Option D seems more relevant as it directly filters for 'Smart Scan' and the Object ID of the table.

upvoted 0 times

...

Luis

26 days ago

I think option C is not appropriate because it does not provide specific information about the Exadata Platform.

upvoted 0 times

...