Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 818
  • Last Modified:

Oracle Exadata

Hey what is Oracle Exadata. When and why do we use Oraexadata
0
hussainkhan22
Asked:
hussainkhan22
  • 3
  • 2
  • 2
2 Solutions
 
sdstuberCommented:
It is a server, storage and software combination built to be a data-engine.

That's the high-level marketing description.

If you want more detail info as to it's techincal specs, you can read a lot about it from oracle's site

http://www.oracle.com/technetwork/oem/extensions/index-160766.html

lots of tech info at the bottom of that page
0
 
sdstuberCommented:
The most interesting feature, in my opinion, of Exadata is the query engine built into the storage layer.

That is,  my where clause might not be processed by the database itself, it might be pushed all the way down to the disk and filtered there.  Making the io much faster because the storage layer isn't sending data back to the database that is going to be eliminated anyway.
0
 
Fadi SODAH (aka madunix)Chief Information Security Officer, CISA, CISSP, CFR, ICATE, MCSE, CCNA, CCNP, CCIP, SCSC and SCECommented:
it's a boxed version of the oracle database with a product called exadata, using exadata, a database can push down some filtering operations to storage, it's not new, it exists for quite some time.
A full database machine can do more than 1.000.000 I/O's per second, turkcell (one of the largest European telecoms companies) is moving a 176 CPU system to the database machine, its a linux based machine(it's all oracle: sun hardware, partly flash storage, OEL)

The trick is oracle engineered a machine which is made to be able to deliver I/O results which have no bottleneck except for physical disk speed central storage has the problem it becomes overloaded and need huge amounts of entry-path's for large systems.

The db-machine works with infiniband (40Gb up + 40Gb down) and the storage cells have limited disk space, which is also how they overcome overloading: more space means another cell  link @ http://www.oracle.com/us/products/database/exadata/index.htm
 
0
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

 
Fadi SODAH (aka madunix)Chief Information Security Officer, CISA, CISSP, CFR, ICATE, MCSE, CCNA, CCNP, CCIP, SCSC and SCECommented:
a picture of it
1.jpg
0
 
hussainkhan22Author Commented:
Thanks for your information but as an Oracle DBA what all I must know about exadata.
0
 
sdstuberCommented:
"all you must know"  is WAY beyond the scope of this forum, let along a single question.

A good place to start is the DBA reference

http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/toc.htm
0
 
hussainkhan22Author Commented:
got it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now