Guide to Oracle 12c database features and upgrades
A comprehensive collection of articles, videos and more, hand-picked by our editors
We at SearchOracle.com asked several Oracle database administrators (DBAs) what is on their wish list in 2013 when it comes to Oracle Database. Here are some of their answers.
Michelle Malcher, Oracle ACE Director, vice president of Independent Oracle Users Group (IOUG)
Here is what Malcher said:
"In 2013, I am looking forward to a successful upgrade to the latest release of the Oracle database. Yes, planning an upgrade before release seems a bit crazy, but it is only a 2013 wish list. There are new features that we are excited about implementing as soon as possible. I am anticipating that 2013 will allow for better performance, more secure and highly available database environments. As a DBA, I always wish for more memory and more storage because I can see even more data growth in 2013, and that should continue to make our careers interesting.
"In 2013, IOUG will be celebrating 20 years, and I hope for our relationship with other database technology professionals and Oracle to continue to make us all successful in our environments."
Bobby Durrett, lead Oracle DBA at US Foods
"I would like to see Oracle 12c use information about the number of rows a query returned in each step of its plan to improve the plan the next time the same query is executed. I heard [popular Oracle expert] Tom Kyte say that something like this was a possible new feature that will be in 12c. Tom also said that errors in the optimizer's estimates of the number of rows really being acted on in a query's plan are [at] the heart of most bad query plans. This corresponds to my own experience, and I'm hopeful that some new feature, which include the past real row counts into future plans, will greatly improve the optimizer's ability to run SQL queries efficiently."
Carol Francum, vice president, Ashford Global IT
Francum had some questions around Oracle's overall database portfolio in 2013:
- What is Oracle's plan vis à vis MySQL? As an example, I can download Oracle Database easily and get it working, but for some reason I cannot with MySQL. I believe there is a difference in the level of documentation available, and I do prefer Oracle, but would like to know more about MySQL for my smaller clients.
- What offerings does Oracle have for the small business? I think that MySQL is there to bridge the gap, but I'm not sure how or why.
- Where do you see Oracle going in the next couple of years? What additional features can we expect, and why are they important to the small to medium-sized business?
James McHugh, DBA consultant
McHugh listed four main features he'd like to see from Oracle in 2013, three of which are from the past.
First, he said he would like to see a feature that IBM Information Management System (IMS) had in the 1980s: "change accumulation of the archive logs to expedite recovery." Then he moved onto Sybase and the 1990s, saying it had a CPU affinity feature that could use the top-level processors for the most critical roles, as well as what he called "true parallelism." He'd also like to see Oracle Database adopt transitive predicate closure, an IBM DB2 feature in the 1990s, which helps the optimizer make better access path choices. Finally, McHugh said he would like to see a coding feature that would detect memory leakage without relying on third-party tools.
Guenadi Jilevski, senior DBA at GJ Information Consulting Inc. in New York City
Jilevski, like McHugh, listed four things he'd like to see from Oracle in 2013, particularly with Oracle Database 12c. First off is extended heterogeneous support of Oracle Data Guard across platforms with different endian formats. Second he wants near-zero downtime database upgrades, further enhancing the physical transient logical standby upgrade in 11gR2 and the logical standby upgrade from 10gR2. Third, he wants Recovery Manager (RMAN)-based backup and recoverability enhancements addressing databases that are 100 terabytes and larger. And finally, he would like to see a working and fully tested high availability IP (HAIP) feature in Oracle Real Application Clusters (RAC) 12c.