Oracle9i is a platform and not only a database as was the case with Oracle8i. Oracle9i consists of the 9iDB (Database), 9iAS (Application Server), and 9iDS (Developer Suite).
Some of the more important ones are:
• Traditional rollback segments (RBS) are still available, but can be replaced with automated System Managed Undo (SMU). Using SMU, Oracle will create it's own "Rollback Segments" and size them automatically without any DBA involvement.
• Flashback query (dbms_flashback.enable) - one can query data as it looked at some point in the past. This feature will allow users to correct wrongly committed transactions without contacting the DBA to do a database restore.
• Use Oracle Ultra Search for searching databases, file systems, etc. The Ultra Search crawler fetches data and hand it to Oracle Text to be indexed.
• Oracle Name server is still available, but deprecate in favor of LDAP Naming (using the Oracle Internet Directory Server). A name server proxy is provided for backwards compatibility, as pre-8i client cannot resolve names from an LDAP server.
• Oracle Parallel Server's (OPS) scalability was improved - now called Real Application Clusters (RAC). Full Cache Fusion implemented. Any application can scale in a database cluster. Applications don't need to be cluster aware anymore.
• The Oracle Standby DB feature renamed to Oracle Data Guard. New Logical Standby databases replay SQL on standby site allowing the database to be used for normal read writes operations. The Data Guard Broker allows single step fail-over when disaster strikes.
• Scrolling cursor support. Oracle9i allows fetching backwards in a result set.
• Dynamic Memory Management - Buffer Pools and shared pool can be resized on-the-fly. This eliminates the need to restart the database each time parameter changes were made.
• On-line table and index reorganization.
• VI (Virtual Interface) protocol support, an alternative to TCP/IP, available for use with Oracle Net (SQL*Net). VI provides fast communications between components in a cluster.
• Build in XML Developers Kit (XDK). New data types for XML (XMLType), URI's, etc. XML integrated with AQ.
• Cost Based Optimizer now also considers memory and CPU, not only disk access cost as before.
• PL/SQL programs can be natively compiled to binaries. <P<
• Deep data protection - fine-grained security and auditing. Put security on DB level. SQL access does not mean unrestricted access.
• Resumable backups and statements - suspend statement instead of rolling back immediately.
• List Partitioning - partitioning on a list of values.
• ETL (eXtract, transformation, load) Operations - with external tables and pipelining.
• OLAP - Express functionality included in the DB.
• Data Mining - Oracle Darwin's features included in the DB.
No comments:
Post a Comment