PC Magazine
Ziff Davis Media
The Independent Guide To Technology
Home

reviews

downloads

solutions

news

columns

shop now

discussions
 
ADVERTISEMENT

  • ONLINE CLASSIFIEDS

Oracle9i Database
 
Oracle9<i>i</i>
  • Product: Oracle9i Database
  • Price: Per CPU, $40,000 list (additional modules priced separately)
  • Company Info: Oracle Corp., 800-672-2531, www.oracle.com
  •  

    By Richard V. Dragan

    If you have the budget and don't mind the "database is the platform" mentality, go for Oracle9i Database: It delivers a truly powerful solution. Though it still requires you to do a lot of tuning, the rich management tools in this release can reduce some of the stress of keeping your enterprise up and running. It also outperformed all of the other products on our JSP Nile Throughput test, delivering over 620 pages per second.

    Compared with IBM's DB2, you'll pay more for additional modules and you'll risk vendor lock-in, but Oracle has become something of a standard in itself, with a far larger pool of IT experts than its competitors. On the downside, it's not as open as DB2, and its lower-priced versions cut out features that IBM includes.

    The Oracle Universal Installer manages the more than 1.5GB of files required for the Enterprise edition. We used the separate data migration wizard to move our test database from Version 8i to 9i. The installer also creates a sample database, along with settings for common applications (OLTP, data warehouses, and general-purpose servers).

    With the bundled Oracle Management Server, a lone DBA can manage multiple nodes on the network with the most powerful interface we saw in this roundup—Oracle Enterprise Manager. This one-stop interface is highly graphical. Based on Java (as is Sybase ASE's Java Central utility), it's more responsive and excellently controls multiple database nodes.

    The Management Server let us define two dozen database user roles with different access levels, from DBAs to backup operators. Oracle integrates with LDAP directories via the Oracle Directory Service, which let us define and easily tweak database schemas by adding columns and indexes.

    Oracle developers had an overriding objective for this release: to keep enterprises up and running. A range of tools, including dozens of wizards and assistants, help make this happen. The Enterprise Management Console makes those separate features available via toolbars for easy access. Among the noteworthy tools, the Oracle Change Manager shows you how schema changes will affect your database without interfering with production systems. We used this feature to propagate several schema tweaks from a simulated development to a production database.

    To spot problems, managers can define both e-mail and pager alerts for common database events or threshold conditions, such as running low on table space. You can turn off problem alerts for defined blocks of time, avoiding needless alerts during scheduled downtime.

    Maintaining the health of your servers in Oracle9i gets a big boost, thanks to the Oracle Performance Manager. This tool gives managers detailed feedback on CPU, disk, and query performance, as well as plentiful statistics in prepackaged or custom charts. Other SQL databases offer similar information, but the real-time statistics and activity details make spotting bottlenecks far simpler. A standout here is the top sessions feature, which clearly indicates database bandwidth hogs. This feature showed us which of our simulated users were most active.

    Oracle9i's capacity-planning feature lets you track usage patterns and plan for upgrades. We also liked the Oracle Outline Manager, which lets you leverage SQL optimizations across upgrades. Oracle databases have a reputation for requiring custom tuning, and mastering this still demands training and experience. We had to do quite a bit of manual memory and disk-usage tuning for our tests. While the trend toward more accessible tools is in evidence, tuning is still not as intuitive as it is in SQL Server.

    Two general tools, SQL*Plus and SQL*Plus Worksheet (its Java-based equivalent) let you run SQL queries against databases. You still can't stop a long-running query, but both tools can import thousands of records in batch mode. With Oracle9i, administrators can still run their tried-and-true scripts and use these tools, but graphical tools now do the same work interactively.

    The DBMS also supports PL/SQL and Java, which developers can use to model business objects that run inside the database server. The Oracle9i Application Server (an additional $20,000 per CPU) supports Java Web applications including JSPs, servlets, and EJBs modeled using Oracle Business Components for Java. But you can also run EJBs directly in the database server. This is just part of what makes Oracle9i a platform rather than just a database.

    XML support is available in Oracle XDK. Besides offering access to XML through Java APIs, the XDK lets you query and insert XML data. We used this feature to import hunreds of order records to our test e-commerce database. Aside from this, Oracle9i doesn't play well with other vendors: You cannot export or import a database directly to or from non-Oracle databases.

    Despite its proprietary nature, Oracle9i is a welcome upgrade for existing Oracle shops. It's also the most approachable version yet for Oracle newbies. This powerful, comprehensive solution now has a friendlier face and graphical tools that simplify common administration tasks. If your budget allows, the latest release of Oracle's flagship product has a lot to recommend itself.


    < back   next >  
    Email Rate It Order Reprints of this Article.
     
    XML
    Add PC Magazine: New Product Reviews to your RSS newsreader or My Yahoo!


    dell_bsd_mod_left dell_bsd_mod_middle Toshiba eWeek Right
    Ziff Davis Partner Sites
  • Visual Studio & .Net Dev Center
  • IBM On Demand
  • HP Smart Business Center
  • Ziff Davis Featured Sites
  • IT Reseller News & Resources
  • eWEEK.com Storage Topic Center
  • eCommerceIQ

  • FREE ZIFF DAVIS MEDIA ESEMINARS AT ESEMINARSLIVE.COM
  • Jan. 24, 4 p.m. ET
    How Secure is Your Data?
    with Frank Derfler. Sponsored by Adobe Systems
  • Jan. 25, 12:30 p.m. ET
    Applying Security Management Practices
    with Michael Krieger. Sponsored by Computer Associates
  • Jan. 25, 2 p.m. ET
    Apps on the WAN: Delivering Performance Across the Enterprise
    with Frank Derfler. Sponsored by FineGround & Cargill
  • Jan. 26, 12:30 p.m. ET
    Ferris Research: Stop Virus Attacks Before They Begin
    with Frank Derfler Sponsored by MailFrontier & Ferris Research.
  • Tradeshow Image

    If you missed the Ziff Davis Media eSeminar's Security Virtual Tradeshow don't worry. Our archives are up and running with two day's worth of information and analysis from top security experts focused exclusively on the most pressing IT security issues. Register now and view the informative keynotes and panel discussions that took place with our FBI, DOJ, IT and analyst guests.
    FREE WHITE PAPERS
    Click on a link below to download one of the following Free White Papers:


  • Tips and Tricks for Optimizing Microsoft Windows Server 2003 on ProLiant Servers


  • The HP-Microsoft Small Business Solution at Work


  • Implementing Microsoft Windows Server 2003 on ProLiant Servers
  • >> brought to you by HP

    NEW & USEFUL UTILITIES @ PCMAG.COM
    Powerful New Files for the Web and Windows, only from the PCMag.com Utility Library:
    • Favorites Manager - super-fast way to organize, control bookmarks
    • AppLauncher - get total control over Windows file associations
    • Web Historian - save Web information so it's there whenever you need it!
    • Shortcut Manager - Organize and manage your desktop, IE, and startup menu shortcuts
     


    Browse the Library >>


    table of contents
    Clash of the Titans
    • Clash of the Titans: SQL Databases
    • Editors' Choice
    • DB2 Universal Database 7.2
    • Microsoft SQL Server 2000 SP2
    • MySQL 4.0
    • Oracle9i Database
    • Sybase Adaptive Server Enterprise 12.5
    • On the Road to Mobile Databases
    • Toward Disaster-Proof Databases
    • Performance Tests
    • Scorecard
    • Summary of Features
    • Online Extra: Nile Application Test Code
    • Inside PC Labs


    discussions

    Find a Topic:
    View All >

     Partner Services:
      Dell Business Systems
      Dell Home Systems
      MPC (MicronPC)
      Dell Biz E-Catalog