Showing posts with label oracle database machine. Show all posts
Showing posts with label oracle database machine. Show all posts

Why Exadata for Oracle Databases?

Many time it comes in our mind that why we should go for Exadata, what benefits we can get if we go for Exadata so here we have given some views based on the Exadata architecture, experience and features. This is the most common question in interview.



No doubt there can be many more advantages than what we have given below as we have only given high level views.

  • Exadata is high performance and high available pre-configured device.
  • It consists of servers,storage networking and software in single pre-configured box which is massively scalable, secure and redundant.
  • Multiple compression tiers are available on Exadata which can help customer to compress data as per business requirement to save storage space.
  • Implementation time is very less compare to non-Exadata systems as it's comes as pre-configured and pre-tested.
  • In case on any issue with the Exadata than we need to communicate with only single vendor which doesn't required to contact multiple vendor like non-Exadata setup so solution of issue could be done quicker.
  • Only DMA (Database Machine Administrator) would be required to manage the Exadata so it can manage with lower TCO which reduce the huge cost of manageability.
  • Exadata provides extreme performance for both DW and OLTP databases which is making it and ideal platform for database consolidation.

What is HARD in Oracle Exadata?

Hardware Assisted Resilient Data (HARD)
  • HARD will prevent data corruptions from being written to storage disks.
  • Oracle database validates and add protection while sending data to the storage server.
  • Whenever data will go to storage server , first it will check if there is any data corruption. If it found the corrupted data , it would stops corrupted data from being written to disk.
  • Previously or in non-Exadata hardware it's not possible to prevent corrupted data to be written on to the storage and that was major reason for database corruption in many cases which Oracle has eliminated with the use of storage software which has been introduced in Exadata storage cell.
  • There is nothing to set on Database level or storage level as  HARD handle corruption transparently which also included for ASM rebalance.