topics that matter; ideas worth sharing

share a tip, submit a link, add something new

Oracle details self-tuning pieces of 9i database

May 3, 2001, 08:00 PM —  InfoWorld — 

Oracle on Thursday discussed what it called the final pieces of its forthcoming 9i database, which promises to make the software more self-tuning and reduce associated maintenance costs.

When 9i ships on June 14, it will include memory management, storage management, and resource management functionality. "The entire industry has been moving toward more self-tuning databases," said Bob Shimp, Oracle's senior director of marketing, in Redwood Shores, Calif.

Indeed, IBM, Microsoft, NCR, and Sybase, to name a few, also have been working to require less maintenance on the part of database administrators. Emeryville, Calif.-based Sybase CEO John Chen has said that in time, databases will become almost zero-maintenance systems that only need to be installed, then occasionally tweaked.

"It's good that Oracle is going in the direction of self-tuning. A lot of the complaints about them were that it was tricky to use, but they've come a long way in terms of usability," said Peter Urban, a senior analyst at AMR Research in Boston. "Anything they can do to improve usability is key."

In addition to making the database easier to use, Shimp said that the self-tuning features will reduce the overall cost of operating an Oracle database. Oracle has been criticized over the last several months for its universal power unit pricing model.

Last August, consultancy Meta Group, in Stamford, Conn., published a report stating that Oracle is three to five times more expensive than IBM's DB2. AMR's Urban, however, expects that the self-tuning features will help Oracle users keep costs down in the long run. "They still have to work on that up-front price, but the more significant costs are the ongoing ones," he said.

Internal Oracle testing suggests that 9i can reduce database management costs by as much as 40 percent, Shimp added. "With these features you can add more users to the same size database," Shimp said.

Real Application Clusters, a feature Oracle introduced at its October OpenWorld show in San Francisco, also contributes to the overall scalability of 9i by enabling customers to string together servers for processing power. "We use both the scale up and the scale-out approach," Shimp said.

AMR's Urban said that Real Application Clusters will help elevate Oracle to the scalability level of NCR and IBM.

"Previously, they could latch multiple servers together, but now clustering for scalability is much easier," he added.

In terms of scalability, Oracle clearly is aiming for the sky. In fact, CEO Larry Ellison at OpenWorld said that with the pending release Oracle is gunning to achieve 1 million simultaneous users, 1 million page views per second, and 1 million TPC-Cs. TPC-C is the benchmark for database performance that is run by the Transaction Processing Performance Council, in San Francisco.

The current record for most TPC-Cs belongs to IBM running a Windows 2000 Datacenter Server and SQL Server 2000 clustered configuration and is 688,220 transactions per minute.

"We're going to try and illustrate those capabilities," Shimp said. He added that Oracle is saving the specific numbers for the formal launch.

The company on Thursday said that it will announce 9i on June 14, at which point the database will become available. Oracle has said for several months that customer will be able to purchase 9i in the first half of this year.

Last week Ellison publicly slated May 15 as the announcement date, and Oracle planned to hold a formal event that day at its headquarters. But the database giant decided to hold off until June 14, saying it made more sense to host a formal event when the product is finished and available.

InfoWorld

I like it!
Post a comment
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
Resources
White Paper

Symantec Backup Exec 12 and Backup Exec System Recovery 8 deliver industry leading Windows data protection and system recovery. Download this whitepaper to find out the top reasons to upgrade and how to get continuous data protection and complete system recovery.

Webcast

Data and system loss — from a hard drive failure, malicious attack, natural disaster, or simple human error — can happen anytime. Don’t leave your business vulnerable. Make sure you have a secure recovery strategy in place. Symantec's latest backup and system recovery technology can efficiently restore critical applications, individual emails and documents and even restore your entire system in minutes in the event of a loss.

White Paper

Businesses face a growing challenge to ensure that the IT environment is properly protected. Backup Exec 12 integrates with other applications in the Symantec family of products, to complement your current data protection strategy, keep your data securely backed up and make it recoverable when you need it most.

Free stuff
Featured Sponsor

Get a broad understanding of important regulations and how you can make sure your site is in adherence.





Learn how VeriSign SGC-enabled SSL Certificates can help improve site security and customer confidence in the free white paper, "How to Offer the Strongest SSL Encryption." In this paper you will learn the differences between weak and strong encryption and what they mean for your site's performance.

Get VeriSign's free white paper: "The Latest Advancements in SSL Technology" and learn about the benefits of strong SSL encryption, Extended Validation (EV) SSL and security trust marks and what these SSL offerings can do for your site.

Now with Extended Validation (EV) SSL available from VeriSign, you can show your customers that they can trust your site. Learn about EV SSL benefits in this free VeriSign white paper.

More Resources