Explore topic-wise InterviewSolutions in .

Spine switch is USED to CONNECT or add more EXADATA machine in the cluster

Spine switch is used to connect or add more Exadata machine in the cluster

All the HDD are hot swapable so if we are using proper redundacny than we can DIRECT remove and replace new HDD.

Storage SOFTWARE will take care all the stuffs in background after REPLACING the HDD.

All the HDD are hot swapable so if we are using proper redundacny than we can direct remove and replace new HDD.

Storage software will take care all the stuffs in background after replacing the HDD.

There are 14 cell STORAGE COMES in full RACK exdata MACHINE.

There are 14 cell storage comes in full rack exdata machine.

The PROTOCOL used for communication between DATABASE server and STORAGE server is : iDB protocol

The protocol used for communication between database server and storage server is : iDB protocol

• Database servers has TWO option for OS EITHER Linux or SOLARIS which can be finalized at the TIME of configuration.
• Cell storage comes with Linux only.

• ASR is the TOOL to manage the Oracle hardware. Full form of ASR is Auto Service Request.
• Whenever any hardware FAULT OCCURS ASR AUTOMATICALLY RAISE SR in Oracle Support and send notification to respective customer.

• Install OEM agent on DB server
• Launch auto discovery with the USE of One Command XML FILE
• Specify required CREDENTIALS for all the components
• REVIEW Configuration
• Complete the setup

It can be DONE through ILOM of DB or CELL SERVER.

It can be done through ILOM of DB or Cell server.

CELLIP.ORA FILE contains the LIST of STORAGE server which is ACCESSED by DB server.

CELLIP.ORA file contains the list of storage server which is accessed by DB server.

• Exacheck
• sundiagtest
• oswatcher
• OEM 12C

EHCC is Exadata HYBRID Columnar Compression which is used to COMPRESS DATA in the Database.

EHCC is Exadata Hybrid Columnar Compression which is used to compress data in the Database.

It refers to the fact that part of the traditional SQL processing done by the database can be “OFFLOADED” from the database layer to the STORAGE layer.

The PRIMARY benefit of Offloading is the REDUCTION in the VOLUME of data that must be returned to the database server. This is one of the major bottlenecks of most large databases.

It refers to the fact that part of the traditional SQL processing done by the database can be “offloaded” from the database layer to the storage layer.

The primary benefit of Offloading is the reduction in the volume of data that must be returned to the database server. This is one of the major bottlenecks of most large databases.

• Cellcli can be USED on RESPECTIVE cell storage only.
• DCLi (Distributed command Line UTILITY) - DCLI can be used to replicate command on MULTIPLA storage as WELL as DB servers.

IORM stand for I/O Resource Manager which MANAGES the I/Os of multiple DATABASE on STORAGE cell.

IORM stand for I/O Resource Manager which manages the I/Os of multiple database on storage cell.

We can EXECUTE Exacheck and verify the best practice SETUP on EXADATA MACHINE.

We can execute Exacheck and verify the best practice setup on Exadata machine.

• Public/Client Network - For APPLICATION CONNECTIVITY.
• MANAGEMENT Network - For Exadata H/W management.
• PRIVATE Network - For cluster inter connectivity and Storage connectivity.

SQL>alter table table_name MOVE compress for QUERY HIGH;

SQL>alter table table_name move compress for query high;

• It is not required to take a BACKUP as it happens automatically.
• Exadata use INTERNAL USB drive CALLED the Cellboot FLASH Drive to take backup of software.

• writethrough --> Falshcache will be USED only for READING purpose.
• writeback --> Flashcache will be used for both reading and writing.

FLASH CACHE

Flash Cache

40 GBPS

40 Gbps

• High capacity disk COMES with more storage space and less RPM (7.5k).
• High Performance disk comes with less storage and high rpm (15K).

Before and after any CONFIGURATION CHANGE in DATABASE MACHINE

Before and after any configuration change in Database Machine

GRID Disks are CREATED on top of Cell Disks and are presented to Oracle ASM as ASM disks. Space is allocated in chunks from the OUTER tracks of the Cell disk and moving INWARDS. ONE can have multiple Grid Disks per Cell disk.

Grid Disks are created on top of Cell Disks and are presented to Oracle ASM as ASM disks. Space is allocated in chunks from the outer tracks of the Cell disk and moving inwards. One can have multiple Grid Disks per Cell disk.

STEPS :

• Create Directory
• Create Tablespace on database which you are GOING to use for DBFS
• Create USER for DBFS
• Grant required privileges to created user
• Now connect to database with created user
• Create dbfs FILESYSTEM by INVOKING dbfs_create_filesystem_advanced
• MOUNT file system by starting dbfs_client

STEPS :

INFINIBAND NETWORK

Infiniband Network

Approximate 3 hours PER Cell and DB server including Infiniband & PDU PATCHING required 1 hour each

Approximate 3 hours per Cell and DB server including Infiniband & PDU patching required 1 hour each

1. GOLDEN Gate
2. TRANSPORTABLE Tablespace
3. INCREMENTAL Transportable Tablespace
4. Data Pump

1. Golden Gate
2. Transportable Tablespace
3. Incremental Transportable Tablespace
4. Data Pump

CELLCLI> ALTER CELL flashCacheCompress=true

CellCLI> ALTER CELL flashCacheCompress=true

CELL FLASH CACHE READ HITS

Cell flash cache read hits

+DBFS_DG

+DBFS_DG

There are 53 WAIT EVENTS are EXADATA SPECIFIC events.

There are 53 wait events are exadata specific events.

The X3-8 is COMPRISED of 2 LARGE SMP compute servers while the X3-2 can SCALE to as many as 8 compute servers as processing requirements increase. 

The X3-8 is comprised of 2 large SMP compute servers while the X3-2 can scale to as many as 8 compute servers as processing requirements increase. 

• DATABASE INSTANCE
• ASM Instance
• Database RESOURCE MANAGER

DBRM is the FEATURE of DATABASE while IORM is the feature of storage server software.

DBRM is the feature of database while IORM is the feature of storage server software.

14 STORAGE NODES

14 storage nodes

The FLASH cache is a hardware component configured in the exadata storage cell server which delivers HIGH performance in read and write operations.

Primary task of smart flash cache is to HOLD frequently accessed data in flash cache so NEXT time if same data required than physical read can be avoided by READING the data from flash cache.

The flash cache is a hardware component configured in the exadata storage cell server which delivers high performance in read and write operations.

Primary task of smart flash cache is to hold frequently accessed data in flash cache so next time if same data required than physical read can be avoided by reading the data from flash cache.

512MB PER module.
Each STORAGE CELL having 4 modules so its 4X512 MB per CELL

512MB per module.
Each storage cell having 4 modules so its 4X512 MB per CELL

• KEEP
• DEFAULT
• NONE

SNMP : SIMPLE NETWORK MANAGEMENT PROTOCOL

SNMP : Simple Network Management Protocol

• Storage Indexes consist of a minimum and a maximum value for up to EIGHT columns. This STRUCTURE is MAINTAINED for 1MB chunks of storage (storage regions). 
• Storage Indexes are stored in memory only and are NEVER written to disk.
• Storage Index filter out data from the consideration.

Exadata is pre-configured combination of HARDWARE and software which provides a platform to RUN the ORACLE Database. 

Exadata is pre-configured combination of hardware and software which provides a platform to run the Oracle Database. 

Depending on the downtime allowed there are several options:
• Traditional Export/Import
• Oracle DataGuard
• TABLESPACE transportation.
• GOLDENGATE Replication after a DATA restore onto EXADATA.

Depending on the downtime allowed there are several options:
• Traditional Export/Import
• Oracle DataGuard
• Tablespace transportation.
• Goldengate Replication after a data restore onto Exadata.

The PARAMETER PARALLEL_FORCE_LOCAL can be SPECIFIED at the SESSION level for a PARTICULAR job.

The parameter PARALLEL_FORCE_LOCAL can be specified at the session level for a particular job.

Four 96G PCIe flash MEMORY cards are present on each EXADATA STORAGE Server cell which provide very fast access to the data STORED on it. This REDUCES data acess latency by retrieving data from memory rather than having to access data from disk. A total flash storage of 384GB per cell is available on the Exadata appliance.

Four 96G PCIe flash memory cards are present on each Exadata Storage Server cell which provide very fast access to the data stored on it. This reduces data acess latency by retrieving data from memory rather than having to access data from disk. A total flash storage of 384GB per cell is available on the Exadata appliance.

Hybrid Columnar compression, also CALLED HCC, is a feature of Exadata which is USED for compressing data at column level for a table. It creates compression data units which consist of LOGICAL grouping of columns VALUES typically having several data blocks in it. Each data block has data from columns for multiple rows. This logarithm has the potential to reduce the storage used by the data and reduce DISK I/O enhancing performance for the queries.

Hybrid Columnar compression, also called HCC, is a feature of Exadata which is used for compressing data at column level for a table. It creates compression data units which consist of logical grouping of columns values typically having several data blocks in it. Each data block has data from columns for multiple rows. This logarithm has the potential to reduce the storage used by the data and reduce disk I/O enhancing performance for the queries.

IORM stands for I/O Resource MANAGER. It manages the I/O demand based on the configuration, with the amount of resources AVAILABLE. It ensures that none of the I/O cells become oversubscribed with the I/O requests. This is achieved by managing the incoming requests at a consumer group level. Using IORM, you can DIVIDE the I/O bandwidth between multiple databases. To implement IORM resource groups, CONSUMERS and plans need to E created.

IORM stands for I/O Resource Manager. It manages the I/O demand based on the configuration, with the amount of resources available. It ensures that none of the I/O cells become oversubscribed with the I/O requests. This is achieved by managing the incoming requests at a consumer group level. Using IORM, you can divide the I/O bandwidth between multiple databases. To implement IORM resource groups, consumers and plans need to e created.

CELL and Grid Disk are a logical component of the physical Exadata STORAGE. A cell or Exadata Storage server cell is a combination of Disk Drives put together to store user data. Each Cell Disk corresponds to a LUN (Logical Unit) which has been FORMATTED by the Exadata Storage Server Software. Typically, each cell has 12 disk drives mapped to it.

Grid Disks are created on top of Cell Disks and are presented to Oracle ASM as ASM disks. SPACE is allocated in chunks from the outer tracks of the Cell disk and moving inwards. One can have multiple Grid Disks per Cell disk.

Cell and Grid Disk are a logical component of the physical Exadata storage. A cell or Exadata Storage server cell is a combination of Disk Drives put together to store user data. Each Cell Disk corresponds to a LUN (Logical Unit) which has been formatted by the Exadata Storage Server Software. Typically, each cell has 12 disk drives mapped to it.

Grid Disks are created on top of Cell Disks and are presented to Oracle ASM as ASM disks. Space is allocated in chunks from the outer tracks of the Cell disk and moving inwards. One can have multiple Grid Disks per Cell disk.

Some of the key HARDWARE and software features are:
Hardware level
• Storage SERVER Cells.
• High Speed Infiniband Switch.
Software level
• SMART Scan.
• FLASH Cache.
• Hybrid Columnar Compression.
• IORM (I/O Resource MANAGER).

Some of the key hardware and software features are:
Hardware level
• Storage Server Cells.
• High Speed Infiniband Switch.
Software level
• Smart Scan.
• Flash Cache.
• Hybrid Columnar Compression.
• IORM (I/O Resource Manager).

• The Exadata Appliance configuration comes as a FULL Rack, Half Rack or Quarter Rack.
• The Full Rack X2-2 has 6 CPUs per node with Intel Xeon 5670 processors and a total of 8 Database Server nodes, also known as compute nodes.
• These SERVERS have 96GB of MEMORY on each node. A total of 14 Storage server cells communicate with the storage and PUSH the requested data from the storage to the compute nodes.
• The Half Rack has exactly half the capacity. It has 6 CPUs per node with core Intel Xeon 5670 processors and a total of 4 Database Server nodes. It has 96GB of memory per database server node with a total of 7 Storage server cells