Depend on what industry you are in ARCSDE from ESRI is a big time player for GIS/oil and gas industry. Its support and documentation are suck.

to pick SPATIAL versus ARCSDE, it's all depend on what you are trying to accomplish, performance wise, SPATIAL is new to Oracle and they only have small development team but the product got better and better now. Overall, SPATIAL is better.