Changed 1z0-902 Exam Questions

Oracle Auto Service Request (ASR) on Exadata Database Machines is designed to proactively monitor and detect hardware and software issues. When a problem is detected, ASR Manager automatically opens a service request (SR) with Oracle Support. The primary focus of ASR is on hardware assets, such as storage servers, database servers, and network components, as well as software assets related to Exadata System Software and Oracle Database configurations​​.

According to Oracle’s documentation1, to set a threshold for a metric on a database server, you need to use the create threshold command with the appropriate parameters. The set threshold command is used to modify an existing threshold2.

Therefore, the command that you should use to generate alerts for such an event is:

dbmcli -e “create threshold ds_temp comparison=‘>’, critical=30” on each database server1

According to Oracle.com documents or resources, the four actions that you should take before proceeding with applying updates to your Exadata Database Machine are:

A. Consult My Oracle Support note 888828.1 to determine the current recommended Exadata software release123.

B. Check the Exadata Critical Issues My Oracle Support note 1270094.1 for any issues not added to the latest version of exachk453.

C. Run exachk and resolve only WARNINGS that you have not seen before3.

D. Run the appropriate patchmgr preqequisite check step for each component being updated3.

This SQL statement is adding the new griddisks to the existing diskgroup "DATA" and creating one new failgroup, consisting of all 96 griddisks. The "REBALANCE POWER 512" option tells the system to perform a rebalance operation with a power of 512. It means the system distributes the data evenly across all the disks in the diskgroup using a power of 512.