did you look at www.oracle.com?
What the drawbacks are.. well.. it's oracle!
Need for it? depends on how oracle-happy you are, and wether oracle does something you need and nobody else can give.
Where can it be used? My guess would be: wherever you need a large clunky database.
