Exadata Quick Reference 4: Top 33 Oracle Exadata Parameters

Here listed down Top 33 Oracle Exadata Parameters, Exadata performance more over dependent on these parameters. It includes traditional database parameters also but those parameters also applied for Exadata environment and playing important role in terms of configuration and performance.

cell_offload_decryption
cell_offload_plan_display
cell_offload_processing 
_cell_index_scan_enabled
_small_table_threshold 
_serial_direct_read 
_serial_direct_read 
_kcfis_storageidx_disabled 
_kcfis_storageidx_diag_mode 
_cell_storidx_mode 
_cell_storidx_minmax_enabled 


Exadata Quick Reference 3: Oracle Exadata Patching Commands

Compute Node Patching: 

Patching on Database server can be performed serially or in parallel using DCLI utility.

dbnodeupdate.sh utility is used to perform the database server patching

What dbnodeupdate.sh utility does?
  • Stop/unlock/disable CRS for host restart
  • Perform LVM snapshot backup of / filesystem
  • Mount yum ISO image and configure yum
  • Apply OS updates via yum
  • Relink all Oracle homes for RDS protocol
  • Lock GI home and enable CRS upon host restart



Exadata Quick Reference 2: Oracle Exadata Diag Utilities

exawatcher
Location: /opt/oracle.ExaWatcher/GetExaWatcherResults.sh 

What it does?
Useful to monitor Diskinfo, IBCardInfo, IBprocs, Iostat, LGWR, Lsof, MegaRaidFW, Meminfo, Mpstat, Netstat, Ps, RDSinfo, Slabinfo, Top, Vmstat. It saves historical data in /opt/oracle.ExaWatcher/archive in each server.




Exadata Quick Reference 1: Oracle Exadata Utilities

We have started the sequence of posts for Oracle Exadata Quick Reference which will include Exadata Commands, Utilities, Patching commands, quick overview of exadata features, Exadata parameters, wait events etc...

Agenda for this sequence is to review the exadata quickly in shorter time which also can help for interview preparation. Also it can help for exadata administrator to get the data quickly.

Following are the Oracle Exadata Utilities which are available as of now.


dbmcli 
Command-line administration tool for configuring database servers, and managing objects in the server environment.  

cellcli
Command-line administration tool for Oracle Exadata Storage Server Software 

dcli
Runs commands on multiple compute nodes and cells in parallel threads 

exacli
Command-line administration tool for Oracle Exadata Storage Server Software. It runs on compute nodes and enables you to manage cells remotely. 

exadcli
The exadcli utility runs commands on multiple cells in parallel threads. You can issue an ExaCLI command to be run on multiple cells. 

OEDA
The Exadata Deployment Assistant tool used to gather the information needed to deploy the Exadata Database Machine. The information entered in the tool is used to create the configuration files used to deploy the machine. 

checkip.sh
Run the Network Check script on the network where the machine will be deployed to validate the specified names and IP addresses have been added correctly to the name server, and they do not conflict with the existing network configuration.   

exachk
Exachk utility used to conduct a comprehensive Exadata Health Check on Exadata Database Machine to validate hardware, firmware and configuration.