In this post, we are going to cover some important features of Exadata. This post is for beginners who are just starting to learn Exadata and covers some of the very basic questions like Exadata Administration, Cellcli commands, Networking Topology, Flash cache etc.
If you are new to Exadata, then I would highly recommend you to go through our previous post on Exadata Overview & Architecture
What are you supposed to do in Exadata Administration?
Here is the day to day tasks performed by an Exadata Administrator:
- Maintain Database, RAC and ASM Instances:
- Backup and Restore
- Hardware Maintenance
- Exadata Storage Server Administration
- Exadata Health Check
- Exadata Features
- Exadata Patching
Some important Storage Level Commands:
- Cellcli: To manage Exadata Cell Storage.
- List Cell: List the cell status.
- List Lun: To list all the physical drive and flash drives
- List Cell Detail: List the cell status with all attributes.
- List Celldisk: List all the cell disk.
- List Celldisk Detail: List all the cell disk with detailed information.
- List Flash Cache: To list the configured flash cache.
- List Flashlog: To list the configured flash log.
- List Grid disk: To list the grid disks.
- List Iorm : To list the iorm plan .
- List threshold: To list the threshold limit.
What is Cell Offloading?
The storage in the Exadata Database Machine is not just dumb storage. The storage cells are intelligent enough to process some workload inside them, saving the database nodes from that work. This process is referred to as cell offloading.
What is Smart Scan?
Smart Scan is a subset of Cell Offload Processing and is perhaps the feature that is most highly associated with Exadata. Smart Scan allows Oracle databases to push query information down to the storage level, specifically: Filtration (predicate information)
Networking Topology in Exadata
Oracle Exadata Database Machine includes database servers, Exadata Storage Servers, as well as equipment to connect the servers to your network. The network connections allow the servers to be administered remotely, and clients to connect to the database servers.
Leaf and Spine switches are used for networking
If you want to know more about Exadata network (click here)
Flash cache in Exadata
The flash cache is a hardware component configured in the Exadata storage cell server which delivers high performance in read and write operations.
Who is DMA?
DMA stands for Database machine Administrator. The single role that performs the management of Exadata is known as Database Machine Administrator. A person is responsible for managing Compute Nodes, Storage, and Networking of Exadata Machine.
This post is from our Exadata Training, in which we cover Exadata Overview & Architecture, Exadata Storage Server Configuration, Resource Management, Optimizing Database Performance & much more.
Next Task For You
Click on the image below to download your FREE Guide, 5 Key Exadata Docs, Every Oracle DBA Must Read, & Learn More.