Re: Are there features on other RDBMS's that it would be good for Oracle to have?
Date: Sun, 27 May 2012 15:24:11 +1000
Message-ID: <4FC1BA7B.4050906_at_iinet.net.au>
Paul Linehan wrote,on my timestamp of 26/05/2012 2:33 PM:
> Anything similar on other systems that you use that you think would be
> of benefit for Oracle?
Oh boy!...
First and foremost: the ability to have multiple redo log streams so I don't have to buy RAC when single redo log writing flattens out.
Yes: I am aware that it's got to do with transaction control.
es: I am aware of SSDs and their uses.
I've been using Oracle since release 3, does anyone seriously think there is
ANYTHING about it I'm not "aware" of?
MSSQL has it and it works peachy. So it does with RAC. As is, I am seriously limited on the number of different schemas and apps I can consolidate into a single instance without starting to have serious bottlenecks.
Second, I've posted about in my blog:
http://dbasrus.blogspot.com.au/2011/11/wish-list-for-12c.html
In a nutshell: proxy logins don't cut it because they are not affected by roles
assigned to the initial login user. My using a login trigger is just a kludge
to what should really be handled by the database context functionality.
Badly needed for multiple schema/application consolidation.
Yes, there are those of us to whom "consolidation" has a little bit more than 4 letters. And I'm venturing it'll become more and more important as time goes by and IT budgets contract a lot more - they will.
-- Cheers Nuno Souto in sunny Sydney, Australia dbvision_at_iinet.net.au -- http://www.freelists.org/webpage/oracle-lReceived on Sun May 27 2012 - 00:24:11 CDT