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

Loreen

2 months ago

I heard the Exadata Platform has a built-in joke generator. Maybe you could try that to lighten the mood during the exam.

upvoted 0 times

...

Pedro

2 months ago

I don't know, these Exadata terms are making my head spin. Can we just use a spreadsheet to track the table's performance instead?

upvoted 0 times

Edda

14 days ago

I) Using a spreadsheet may not give us the detailed information we need to monitor the table's performance on the Exadata Platform.

upvoted 0 times

...

Gabriele

17 days ago

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

upvoted 0 times

...

Domonique

20 days ago

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

upvoted 0 times

...

Leonie

1 months ago

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

...

Loreen

2 months ago

A looks like it's trying to monitor the table's access, but it's not specifically Exadata-related. Maybe it's not the best option here.

upvoted 0 times

Shaquana

20 days ago

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

upvoted 0 times

...

Cruz

24 days ago

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

upvoted 0 times

...

Antione

1 months ago

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

...

King

2 months ago

C seems like a good option too, as it directly queries the 'cell smart table scan' statistic, which is related to Exadata's smart scan functionality.

upvoted 0 times

Eliz

17 days ago

C) C seems like a good option too, as it directly queries the 'cell smart table scan' statistic, which is related to Exadata's smart scan functionality.

upvoted 0 times

...

Chau

1 months ago

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

upvoted 0 times

...

Soledad

1 months ago

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

...

Simona

3 months 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

3 months 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

Daisy

2 months ago

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

upvoted 0 times

...

Zona

2 months ago

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

...

Glenn

2 months ago

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

upvoted 0 times

...