Consolidating disparate databases for easier management and moving to Linux to save money are among the top issues for Oracle database users, according to a recent survey of members of the Independent Oracle Users Group (IOUG).
Migrating to the latest Oracle 10g, consolidating servers and moving to a service-oriented architecture (SOA) are also top priorities for the 812 IOUG members who responded to the survey.
The results were released in advance of this month’s annual IOUG meeting, Collaborate 2006.
About half of the respondents are database administrators, with a fifth coming from the development and architecture community and 13 per cent working as IT managers or executives.
While commercial Unix still dominates as the platform for Oracle databases and applications, Linux is expected to become the leading platform by next year, with 44 percent of respondents expecting to run Linux.
That would surpass Sun Microsystems Inc.’s Solaris OS, whose share is expected to drop by next year, despite Sun’s open-sourcing of Solaris 10 in 2005.
“There is still a good cost savings associated with moving to Linux, and companies are clearly putting their money where their mouths are,” said Ari Kaplan, president of IOUG.
Oracle has supported Linux since 1999 and its ability to run on farms of PC-based servers via built-in clustering and grid technologies make it a “compelling choice, since lashing groups of these processors together can provide the same scalability as more expensive Unix hardware,” according to the survey.
At Linuxworld in Boston earlier this month, Oracle offered up several announcements: Its cluster file system has been accepted into the mainline Linux kernel and it introduced a data center package of applications for users running Novell’s SUSE Linux Enterprise Server.
Oracle still has more users on Windows than Linux, though that is dropping. Some 60 per cent of respondents run a database on Windows, a figure expected to fall to 48 per cent by next year.
Windows 2000 is the most popular platform, followed by Windows Server 2003.
Heterogeneous environments dominate, with only 7 per cent of respondents running pure Oracle shops; 70 per cent also run Microsoft’s SQL Server, up from 41 per cent who said that in a 2001 survey.
More than half also run Microsoft Access, and more than a quarter run IBM’s DB2, up from 18 percent who said they did so in 2001.
MySQL, the fast-growing open-source database, is used by a quarter of Oracle users, mostly as a front-end caching database to support external queries, the survey found.
Not only are environments heterogeneous, they’re also scattered. Almost of half of users reported that they run more than 20 Oracle databases at their sites. The median database is 50GB in size, and one in four is larger than 1TB.
The expected migration of Oracle 9i, the five-year-old database still widely used by respondents, to Oracle 10g over the next year will give many users the chance to consolidate.
Implementing grids and clusters is much easier in Oracle 10g, according to Kaplan.