What setting may be a smart appropriate Exadata?
Exadata was originally designed for the warehouse setting. Later it had been increased to be used within the OLTP databases moreover.
What area unit the benefits of Exadata?
The Exadata cluster permits for consistent performance whereas permitting raised turnout. As load will increase on the cluster the performance remains consistent by utilizing inter-instance and intra-instance similarity.
It shouldn’t be expected that simply moving to Exadata can improve performance. In most cases it’ll particularly if the present info host is overladen.
What is the key behind Exadata’s higher throughput?
Exadata ships less information through the pipes between the storage and therefore the info nodes and alternative nodes within the RAC cluster.
Also its ability to try and do large similarity by running parallel processes across all the nodes within the cluster provides it abundant higher level of turnout.
It conjointly has abundant larger pipes within the cluster mistreatment Infiniband interconnect for inter-instance information block transfers as high as 5X of fiberchannel networks.
What area unit the various Exadata configurations?
The Exadata Appliances will configure comes as a Full Rack, Half Rack, Quarter Rack or 1/8th rack.
The Full Rack X2-2 has half dozen CPU’s per node with Intel Xeon 5670 processors and a complete of eight info Server nodes. These servers have 96GB of memory on every node. a complete of fourteen Storage server cells communicate with the storage and push the requested information from the storage to the reason nodes.
The [*fr1] Rack has specifically [*fr1] the capability. Its half dozen CPU’s per node with core Intel Xeon 5670 processors and a complete of four info Server nodes. It’s 96GB of memory per info server node with a complete of seven Storage server cells.
The Exadata is additionally on the market within the 1/8th Rack configuration.
What area unit the key Hardware components?
- DB Server
- Storage Server Cells
- High Speed Infiniband Switch
- Cisco Switch
What square measure the Key software system Features?
- Smart Scan,
- Smart Flash Cache
- Storage Index
- Exa data Hybrid Columnar Compression (EHCC)
- IORM (I/O Resource Manager)
What is a Cell and Grid Disk?
Cell and Grid Disk square measure a logical a district of the physical Exadata storage. A cell or Exadata Storage server cell may perhaps be a mixture of Disk Drives place on to store user info. Cell Disk will corresponds to a Logical Unit) that has been formatted by the Exa data Storage Server code. Typically, every cell has twelve disk drives mapped thereto.
Grid Disks are created on prime of Cell Disks and are bestowed to Oracle ASM as ASM disks. House is assigned in chunks from the outer tracks of the Cell disk and moving inwards. One will have multiple Grid Disks per Cell disk.
What’s IORM?
IORM stands for I/O Resource Manager.
It manages the I/O demand supported the configuration, with the quantity of resources out there. It ensures that none of the I/O cells become sold with the I/O requests. This can be achieved by managing the incoming requests at a client cluster level.
Using IORM, you’ll be able to divide the I/O information measure between multiple databases.
To implement IORM resource teams, shoppers and plans ought to be created initial.
What’s hybrid columnar compression?
Hybrid Columnar compression, conjointly referred to as HCC, may be a feature of Exadata that is employed for pressing information at column level for a table.
It creates compression information units that encompass logical grouping of columns values usually having many information blocks in it. Every information block has information from columns for multiple rows.
This power has the potential cut back|to scale back|to cut back} the storage utilized by the info and reduces disk I/O enhancing performance for the queries.
The different styles of HCC compression include:
- Question Low
- Question High
- Archive High
- Archive Low
What’s Flash cache?
A Four 96G PC non-volatile storage cards are gift on every Exa data Storage Server cell which offer in no time access to the info keep on that.
This is any achieved by conjointly provides mechanism to reduces information access latency by retrieving information from memory instead of having to access information from disk. a complete of flash memory of 384 GB per cell is accessible on the Exadata appliance.
What’s sensible Scan?
It is a feature of the Exadata software package which reinforces the info performance repeatedly over. It processes queries in associate degree intelligent method, retrieving specific rows instead of the entire blocks.
It applies filtering criteria at the storage level supported the choice criteria laid out in the question.
It conjointly performs column projection that may be a method of causation solely needed columns for the question back to the info host/instance.
What is the similarity instance parameter employed in Exudates?
The parameter PARALLEL_FORCE_LOCAL is nominative at the session level for a specific job.
However does one take a look at performance of Exadata?
You can use the “calibrate” commands at the cellcli program line.
What are the ways in which to migrate onto Exadata?
Depending on the period allowed there are many options:
- Oracle DataGuard
- Traditional Export/Import
- Table space transportation
- Golden gate Replication once information restore onto Exadata.
What kinds of operations will Exadata “offload”?
Most of the operations that area unit off loaded from the info host to the cell servers are:
- Predicate filtering
- Column project filtering
- Join process
- Backups
What’s cellcli?
This is the program that can line with utility accustomed managed the cell storage.
However does one produce acquire data on the Celldisks?
At the cellcli program line you’ll be able to issue the “list cell disk” command.
However would you produce a grid disk?
At the cellcli command you’d got to issue the “create grididsk all ..” command.
What area unit the cellinit.ora and also the cellip.ora files used for?
These files have the hostnames and also the information science address of all the nodes within the cluster. They’re accustomed run commands on remote info and cell server nodes from a neighbourhood host.
Example:
cat /etc/oracle/cell/network-config/cellinit.ora
ipaddress1=192.168.47.21/24
$ cat /etc/oracle/cell/network-config/cellip.ora
cell=”192.168.47.21:5042″
cell=”192.168.47.22:5042″
cell=”192.168.47.23:5042″
What in operation systems will Exadata support?
Exa data has historically run Oracle Linux OS. Recently, Solaris has additionally been created obtainable on this designed system.