Exadata Smart Scan

What is Smart Scan?

Smart Scan is one of the great feature in Oracle Exadata. With this technology storage send only required rows to database node from storage instead of entire Oracle Block. Multiple rows are stored in one Oracle Block but non-exadata system return entire block even only one rows is required. On the other hand, Exadata Storage returns only interested rows but not entire block.

Continue reading

Exadata Key Features

In this topic will be discussed with Exadata Key Features

  • Smart Scan or Cell Offloading
  • Storage Indexes
  • Hybrid Columnar Compression
  • IO Resource Manager
  • Smart Flash Cache
  • Flash Logging
Continue reading

Exadata Simulation on VM (Cell 12.1.1.1.0)

Create a Virtual Machine for Exadata CELL or Storage Server

In this topic will demonstrate how to configure Cell or Storage Server for Exadata. Very few companies are using Exadata Engineering system so this is very difficult for a DBA to get an environment to explore. So Exadata simulation will be a good option to learn.

  • Download Required Software
  • Hardware Requirements
  • Create a Virtual Machine
  • Install Oracle Linux
  • Prerequisite for Exadata Storage Server
  • Install the Exadata Storage Server Software
  • Clone Storage Server for 2nd VM of Exadata Storage Server (exadatacell02)
  • Create Cell disks and Flash Cache storage for Exadata Storage Server on Node 1
  • Create Cell disks and Flash Cache storage for Exadata Storage Server on Node 2
  • Install Oracle Grid and Database
Continue reading

Exadata Simulation (X3) on VM Part – II

In this topic I will demonstrate how to configure compute node for Exadata and how to configure connection between Cell and Compute Nodes on VM.

Very few companies are using Exadata Engineering system so this is very difficult for a DBA to get an environment to explore. So Exadata simulation will be a good option to learn.

Configure Storage Server: Exadata Simulation Part I

Configure Compute Node or Database Node

Continue reading

Exadata Simulation (X3) on VM Part – I

Create a Virtual Machine for Exadata CELL or Storage Server

In this topic, I will demonstrate how to configure Cell or Storage Server for Exadata on VM. Very few companies are using Exadata Engineering system so this is very difficult for a DBA to get hands on Exadata. So Exadata simulation will be a good option to learn for starting carrier as a DMA (Database Machine Administrator).

Task List:

  • Required Software Download
  • Hardware Requirements
  • Create a Virtual Machine
  • Install Oracle Linux
  • Prerequisite for Exadata Storage Server
  • Install the Exadata Storage Server Software
  • Clone Storage Server for 2nd VM of Exadata Storage Server
  • Create Cell disks and Flash Cache storage for Exadata Storage Server on Node 1
  • Create Cell disks and Flash Cache storage for Exadata Storage Server on Node 2
  • Configure Compute Node or Database Node
  • Install Oracle Grid and Database
Continue reading

Install Oracle Linux 6.8 on VM

In this topic, I will discuss how to install Oracle Linux 6.8 on Virtual Machine.

Continue reading

Install Oracle Linux 7 on VM

This article describes the installation process of Oracle Linux 7.1 on VM. Installation process will be same for any version of Linux 7.

Continue reading

Create Virtual Machine (VM) for Exadata Storage Server

Continue reading

Oracle Cloud Infrastructure (OCI)

Oracle Cloud Infrastructure OCI

Details are coming soon…

Create Oracle RAC Database Using DBCA

Run DBCA utility from oracle user. You have to set ORACLE_HOME AND ORACLE_SID

[oracle@exadb01 dbhome]$ . oraenv
ORACLE_SID = [oracle] ? ORCL
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/11.2.0/dbhome/
The Oracle base has been set to /u01/app/oracle
[oracle@exadb01 dbhome]$ dbca
Continue reading