Friday, November 1, 2013

Is Exadata really needed ? for today market ?

Since 2 Year's i am working on  Exadata  Env. thought write something on is exadata  really needed  for today market ?-  

Consider first below point before saying anything on exadata.

The primary purpose of Exadata is to speed up full table scans. 
The speed comes from the massively parallel block elimination by applying Bloom filters. The fact remains: index blocks are searched in the SGA, Exadata speeds up the full table scan. Full table scans of large table is something that OLTP avoids like a plague. In other words, Exadata does nothing for OLTP. A good SAN like VMAX can do the same thing, using the very same elements that make Exadata fast: fast data transfer using 16GB HBA's, large IO cache on SAN itself for caching and very fast drives for faster IO. Nothing else is needed for OLTP.There is no secret sauce in the Exadata machine which would speed up OLTP.

Smart scan reduces the data sent back (filtering rows as well as columns) to DB servers, how important is that for you 
There are always more storage nodes than DB nodes,so more parallelism 
HCC is important reducing actual size of data on disk 
12c im-memory - everything cannot be kept in memory, what about persistence 
Exadata flashcache persists data when in write-back mode 
Building a reliable interconnect network - Exadata pre-built and tested

We are already processing at speeds that were unheard of 10-20 years ago. I haven't done the research lately, but I bet current servers are 1,000 times faster than they were 15 years ago. 
Business problems have grown too, but not 1,000x. 
So, why are applications slower than they were 10-12 years ago? 
as above i say A good SAN like VMAX can do the same thing as its doing for full table scan.
Here's what I'd like to say. remember the old days where database systems lived and died by the Transaction Processing Council (TPC) benchmarks? I haven't seen that very much anymore. 

Exadata would not give  you much  benefit.  You can achieve If you are  actually DBA  and well knowing  system and storage.



Let me know your experience  at joshi11.vinod@gmail.com -  


No comments:

Post a Comment