so, what's new?
what sort of multi tenant features are there?
Everyone was expecting Oracle's deals this week with Microsoft, Saleforce.com, and NetSuite to revolve around the impending 12c "cloud-ready" multi-tenant database: but that product was not referred to explicitly. That is because Oracle is trying to keep the powder dry for a future shindig announcing the availability of the 12c …
Talking with my DBA counterpart a while back he was saying that with 12c Oracle is able to use a shared SGA across DB instances. Where today if you have 5 different instances you have to have 5x different SGA, which made playing with memory parameters "interesting": tuning how much memory each database needed and it requires a bounce of the instance to change, to take from one to give to the other required outage of both. That sounded more like my understanding of how MS SQL works where you have a 1x instance on a box with multiple databases running off it (note I'm not a Oracle DBA, and definitely not a MS SQL guy).
Additionally grid is dead long live the cloud... my guess is it will take off in the cloud about as much as the grid did.
Probably the ability to have more then one `full` database with system views and such that are only relevant to your database, without seeing anything that as to do with the other ones on the system.
Still more un-supported* junk from Oracle anyway
* Unsupported in the sence they charge you an arm and a leg for support they then refuse to give or might as well not give.
Quite. As another poster pointed out that is what Microsoft SQL server has due it being a descendant of Sybase SQL Server (later to be renamed as Adaptive Server). It is very useful when you want to consolidate several small databases as often happens with current hardware being lot beefier than that of yesteryear.
So really nothing new here, move along. :)
Some other notable new features are possibility of 32K varchar columns to make things easier for programmers who fail to grasp (or can't be bothered) LOBs.
Quite a few improvements in partitioning (assuming they actually work as described, which is not always the case with Oracle).
Likewise optimizer has gotten whole lotta love. Same caveat as above.
I think I'll wait for the Release 2 to see how it all pans out.
"* Unsupported in the sence they charge you an arm and a leg for support they then refuse to give or might as well not give."
Oh they do give you support. First they want every possible log and dump. Then they want you to run some of their fantastic own scripts to collect even more information. In the end you will have resolved the issue on you own or new version that fixes the bug has come out by the time they get to the bottom of it (assuming they manage to do that). Oh and throughout the process if you take any time at all to come up with what they're asking they will be pestering and threatening to close the SR.