Free Practice Questions for Oracle 1z0-902 Exam

Option C shows the number of read hits from PMEM cache on storage servers which indicates how much data was served from PMEM instead of flash or disk1.

Option E shows detailed information about PMEM cache such as size, utilization, hit ratio, read latency and write latency2.

According to the Oracle documentation1, two monitoring tools that might be useful in examining I/O performance for the prod database are:

cellcli (or exacli/exadcli) to examine storage server metrics such as database, category, ceiidisk, and griddisk (D). This tool can help you monitor the I/O Resource Management (IORM) metrics and identify any bottlenecks or imbalances in the storage layer.

I/O-specific dynamic performance views such as v$iostat_fiie, v$iostat_function, and v$iostat_consumer_group from the prod database instances using SQL *p1us ©. These views can help you monitor the I/O activity and latency at the file, function, and consumer group level.

On Oracle Exadata Database Machine X9M, the default configuration of the IPTables firewall varies between storage servers and database servers:

Storage Servers: After initial deployment, IPTables is installed but remains in an unconfigured and inactive state. The Exadata storage servers focus on providing high availability and performance for database workloads and thus rely on internal security measures. The external firewall or network security policies typically handle firewall responsibilities, so IPTables is not actively configured on these servers by default​​.

Database Servers: Similar to storage servers, IPTables is also installed but neither configured nor running on the database servers. The Oracle Exadata Database Machine X9M emphasizes security through other means, such as its network isolation and dedicated interconnects. As part of Oracle’s engineered systems design philosophy, the database servers are primarily focused on database performance, offloading much of the security management to other parts of the infrastructure and relying on data center-level firewalls for perimeter security​​.

To summarize, both database and storage servers have IPTables installed and available, but they are not configured or running by default on either server type. This setup allows Exadata environments to focus on optimized database performance while integrating with external network security solutions.

B and E are true statements for the Oracle Exadata Configuration Assistant (OECA). OECA facilitates PDU power selection initially and after equipment addition, and it allows for the elastic configuration of the hardware. It does not reconfigure the size of disk groups or recreate grid disks, nor does it allow for a single XT storage server in the configuration. The "Add Equipment" input option does allow for the allocation of RU slots for customer equipment.

References for this information can be found in the Oracle Exadata Database Machine X9M Implementation Essentials Official Text Book and Resources.

Search results: [1] Oracle Exadata Database Machine X8-2 [1][2]: Configuration Assistant Guide … The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can … [2] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to … Add Equipment: This input option allows you to allocate RU slots for … [3] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide … The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can … [4] The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can be used to … Power Selection [1][2]: This input option allows you to select PDU power initially … [5] Oracle Exadata Database Machine X7-2 and X7-2L Installation Guide … The Oracle Exadata Configuration Assistant (OECA) is a web-based tool that can …

When preparing a site for an Exadata Database Machine, several precautions ensure both the safety of the installation and the optimal performance of the equipment. These precautions include:

Avoiding High-Interference Equipment: Installing near devices like photocopy machines, which can emit electromagnetic interference (EMI), is not a specified precaution for Exadata installations. However, attention should be given to site requirements for temperature, power, and proper grounding connections .

In contrast, other site requirements include exclusive grounding for Exadata racks, avoiding direct sunlight exposure, and ensuring grounding resistance is less than 10 ohms for shared grounding to minimize electrical risks.

The Exadata X9M-2 Extended (XT) Storage Server does not include any Persistent Memory (PMEM) DIMMs. The XT server configuration primarily serves as a cost-effective archival storage option and lacks the performance features available in the HC (High Capacity) and EF (Extreme Flash) storage servers. This configuration does not include Persistent Memory, which is leveraged in other models for accelerating OLTP workloads and providing extremely low-latency data access​​.

The handling and installation of an Exadata Database Machine rack require caution and adherence to recommended guidelines:

Shipping Brackets: Shipping brackets are specifically designed for transportation purposes and should not be reused for permanent installation. Permanent floor mounting should use approved rack-mounting equipment to ensure stability and safety​ .

Steering and Pushing the Rack: Exadata racks should be steered from the rear due to fixed front casters. It is critical to avoid pushing the rack from the side panels, which could cause it to tip over, presenting a serious safety risk. This careful movement ensures safe positioning and prevents damage to the equipment during installation.

For adding a new RAC (Real Application Clusters) VM cluster to an existing Oracle Exadata X9M-2 deployment, you can utilize the Oracle Exadata Deployment Assistant (OEDA). OEDA is available in two interfaces:

OEDA Web-based Configuration Tool: This web-based interface facilitates the configuration of Exadata environments, supporting both physical and virtual deployments. The graphical interface helps in defining VM clusters, including RAC clusters, and ensures the configuration aligns with Oracle best practices​.

OEDA Command Line Interface (CLI): For more advanced or automated tasks, the command-line interface (oedacli) allows for precise control over the deployment process. It supports various configuration actions such as adding or removing clusters, resizing ASM disk groups, and managing VM clusters​.

These tools are specifically designed for Exadata configurations and provide a streamlined approach for deploying and managing RAC clusters in both physical and virtualized environments.

The minimum Exadata System Software version required to support Oracle Exadata X9M is 21.2.0.0.0. This version introduced various enhancements and capabilities tailored for the X9M series, including optimizations for the RoCE network fabric and support for new hardware components .

Option 5 stops the clusterware on all database servers as the grid user3.

Option 8 shuts down all Exadata storage servers using their ILOM interfaces1.

Option 7 shuts down all database servers using their ILOM interfaces1.

Option 6 powers off the rack using the power switches on the PDUs2.