Oracle Exadata Database Administration

Explore Exadata database machine architecture, including the storage server and smart storage offload, enabling high performance, scalability, and workload balance for OLTP and data warehouse.

Explore the Exadata database machine architecture, including InfiniBand storage networking, Exadata storage servers and library cell, RAC integration, and high availability through mirroring and smart scan.

Exadata process overview, verify mirrors, monitor my SQL server processes and ports, and use the cell CLI to manage cell tasks and database to storage communication.

Conduct an Exadata high availability lab in an RAC environment, restarting services and observing automatic recovery while monitoring processes across multiple sessions to ensure the database remains up during failures.

Log in to the storage grid, review cell disks and device patterns, then run SQL queries to monitor disk utilization and verify grid associations before closing sessions.

Understand Exadata smart flash cache familiarization by inspecting flash disks, configuring the flash cache, reviewing analysis details, and exploring content metadata and lru behavior for low-latency storage.

Exadata uses smart scan on storage to return only matching rows and columns, reducing network and CPU load, with smart cache, hybrid column compression, and storage index.

Explore how smart scan on Exadata optimizes query processing by offloading work, toggling optimizer hints, and leveraging hybrid column compression and storage index to reduce physical reads.

Explore how Exadata hybrid column compression reduces 654 MB data to compressed copies via parallel DDL and archive compression, achieving 4–5x savings in OLTP workloads.

Explore how storage index in Exadata speeds queries by leveraging memory-resident data and smart scans, reducing reads and dramatically speeding analytics.

Learn how to perform the Exadata initial configuration, from pre-installation site planning and network setup to using the Exadata Deployment Assistant and configuration tool for IP, DNS, and rack options.

Learn to use the Exadata configuration tool to create and import a deployment configuration, define customer networks, DNS, and cluster components, and review generated config files.

Learn how to configure Exadata cells, connect to MySQL servers, use the cell CLI to list and detail cells, set up SMTP email alerts, and run cell validation tests.

Explore storage reconfiguration on Exadata grid using disk groups and grid disks; learn to resize, rebalance, drop and recreate disks, monitor usage, and verify group status.

Learn how to consume grid disks using asm by adding a candidate disk to an existing disk group, with smart scan and allocation unit considerations.

Learn to configure Exadata storage security by creating and distributing a cluster-wide key across all nodes and validating storage access and cluster status.

Configure Exadata smart flash cache across cells, switch between write-back and write-through modes, monitor dirty data, and restart the cluster to validate cache behavior.

Explore Exadata hybrid columnar compression, comparing low, high, and archive compression, and measure impact on direct path inserts, parallel queries, and disk IO.

Explore testing index elimination by making a primary key index invisible, running range scans, and comparing timing with and without Exadata smart scan to show performance effects.

Demonstrates migrating a database to an Exadata machine using transportable tablespaces, including conversion, import steps, and verification of tables, indexes, and partitions.

Execute bulk data loading with the database file system: mount the file system, configure a big file tablespace, create a user with privileges, and import a CSV into a table.

Configure Oracle Enterprise Manager Cloud Control and monitor an Exadata database machine, deploying agents, discovering targets, and validating credentials to monitor compute nodes and storage servers.