In brief:
9i is easier to manage.
In detail:
Concurrent clustering, 8i OPS is upgraded to 9i RAC, information is exchanged between 8i nodes using hard disks, and information is exchanged between 9i nodes using Cache Fusion (Cache Fusion) technology over high-speed network cables, which improves switching speeds by more than 100 times.
9i can modify kernel parameters and memory allocation online, 8i cannot.
Data file and tablespace management is manual for 8i and automatic for 9i.
9i has enhanced ANSI SQL99 support over 8i.
9i than 8i enhanced post-failure fast recovery (Fast-start).
8i only supports physical backup (physical backup) database, 9i also added support for logical backup (logical backup) database, so that the backup database in addition to serving as a mirror of the main database, but also can provide other data services.
What are the new features of Oracle 10g over 9i?
In brief:
10g supports Grid and Automatic Management.
Detailed:
The g in 10g is the abbreviation for "Grid", which supports grid computing, i.e., multiple node servers utilize high-speed networks to form a virtual high-performance server, with the load balanced across the entire grid, adding and removing nodes on demand to avoid a single point of failure (Single Point of Failure).
Easy to install, with installation effort cut in half compared to 9i.
New browser-based Enterprise Manager.
Automatic Storage Management (ASM), adding or removing hard disks no longer requires mirroring, load balancing, physical volumes, logical volumes, partitions, and filesystems set up by the OS administrator, just type in an Oracle command, and ASM automatically manages the added or deleted hard disks.
Memory automation automatically allocates and frees system memory as needed.
SQL performance tuning automation.
Free browser-based small-application development tool Oracle Application Express (formerly known as HTML DB) with support for 10g and 9i R2.
Flashback querying and recovery that quickly corrects human error and can recover databases, tables, and even records.
Data Pump (Data Pump) high-speed import and export data, more than twice as fast as the traditional method of export speed, import speed 15 - 45 times faster.
Fine-Grained Auditing (Fine-Grained Auditing), record all operations on sensitive data.
Tablespace storage of data (Tablespace) cross-platform replication, greatly improving the speed of data warehouse loading .
Streams (Streams) replication, to achieve low system consumption, double-direction (double-direction), resume from break point (resume from break point), cross-platform (cross platform), complex replication across data sources.
The Data Guard for disaster recovery adds logical backup functionality, and the backup database can be run in a read-only state on a daily basis to fully utilize the backup database.
Support for many new EE options to strengthen the internal management of the database "Database Vault", the audit of database activities (Audit Vault), data warehouse building advanced features (Warehouse Builder Enterprise ETL, Warehouse Builder Data Quality). Warehouse Builder Enterprise ETL, Warehouse Builder Data Quality).
What are the new features of Oracle 11g over 10g?
11 g extends Oracle's exclusive ability to deliver the benefits of grid computing, which you can use to improve user service levels, reduce downtime, and utilize IT resources more efficiently, while also enhancing the performance, scalability, and security of 24x7 business applications.
Minimize the risk of change with Real Application Testing (RAT)
11 g reduces the cost of database upgrades and other hardware and operating system changes, and dramatically simplifies pre- and post-changes system testing so you can identify and resolve issues. For example:
With Database Replay, you can easily capture actual production loads at the database level and replay them on your test system so you can fully test the impact of system changes, including critical concurrency features.
SQL Performance Analyzer identifies structured query language ) SQL (execution plan changes and performance rollbacks. Identified issues can then be resolved using SQL Tuning Advisor by reverting to the original execution plan or further optimization.
Improving DBA Efficiency with Management Automation
Oracle Database 11 g continues the commitment (starting with Oracle9i Database all the way through Oracle Database 10 g) to significantly simplify and fully automate DBA tasks. New features in Oracle Database 11 g include:
Automated SQL optimization with self-learning capabilitiesAutomated, unified tuning of system global area (SGA) and program global area (PGA) memory cachesNew advisor for partitioning, data recovery, stream performance, and spatial managementEnhancements to the Automatic Database Diagnostic Monitor (ADDM) to provide a more efficient, more efficient, and more effective way to manage the Oracle database. Enhancements to the Automatic Database Diagnostic Monitor (ADDM) to provide a better global view of performance in Oracle Real Application Clusters (Oracle RAC) environments, as well as improved comparative performance analysis.
Rapid Problem Resolution with Troubleshooting
The new troubleshooting capabilities in Oracle Database 11 g make it extremely simple for customers to capture the data Oracle
Support needs after an error occurs. This accelerates problem resolution and reduces the need for customers to reproduce the problem.
Minimizing Downtime Costs
Rapid Data Recovery with Oracle Data Guard
Oracle Data Guard coordinates the maintenance and synchronization of databases between local and remote servers for rapid recovery from a disaster or site failure. Oracle Database 11 g provides a number of significant Oracle Data Guard enhancements, including
The ability to run real-time queries for reporting and other purposes on a physical standby system
The ability to perform online, rolling database upgrades by temporarily converting a physical standby system to a logical standby system
. Snapshot standby support for test environments
In addition, performance improvements have been made to both physical and logical standbys. Logical standbys now support Extensible Markup Language (XML) type character large object (CLOB) data types and transparent data encryption. Automatic, fast-starting failover is now supported for asynchronous transfers.
Oracle Database 11 g provides several important high-availability enhancements for automated storage management,
including:
. Support for rolling upgrades
. Automatic bad block detection and repair
. Fast Mirror Resynchronization, which effectively resynchronizes storage arrays that are mirrored by Automatic Storage Management when storage network connectivity is temporarily lost
Performance enhancements to Automatic Storage Management allow large databases to open faster and reduce SGA memory consumption. These enhancements also allow DBAs to increase storage allocation unit sizes to speed up large sequential input/output (I/O)
Significantly Increase Uptime
Oracle Database 11 g enables you to apply many one-time database patches (including diagnostic patches) without downtime. The new data recovery advisor dramatically reduces downtime by quickly identifying the root cause of failures, providing DBAs with available recovery options, and in some cases, automatically correcting the problem through a "self-recovery" mechanism.
Oracle Database 11 g has other high-performance enhancements, including
. Automatic compilation of PL/SQL and Java in the database
. Faster triggers, including more efficient calls to per-row triggers
. Faster simple SQL operations
... Faster Oracle Data Guard and Oracle Streams replication
.... Faster and more reliable direct connections to Network File System (NFS) storage devices
. Faster upgrades
... Faster backup/restore of large files
. Faster backup compression
Oracle Database 11 g includes a number of new ILM features, such as
. New partitioning features, including
. Partitioning by parent/child reference
. Partitioning by Virtual Columns
Oracle Database 11 g also features Total Recall with Oracle Flashback Data Archiving, which allows you to query previous data in selected tables, providing a simple and practical way to add a time dimension to data for change tracking, ILM, auditing, and compliance.
Other High Availability Enhancements
Oracle Database 11g has other high availability enhancements, including:
Oracle Flashback Transaction Query, which provides push-button changes to rogue transactions with changes to other related transactions
Enhanced platform portability and data mobility with more transportable options, including transportable partitions,
schema and cross-platform migration.
Schema and cross-platform databases
Oracle Recovery Manager (RMAN) support for Windows Volume Shadow Copy
Service ( VSS ) snapshots, enabling tighter integration with Windows backups
Optimized performance and reliability
Compliance, Legal forensics, and the trend to consolidate data warehouses have resulted in databases tripling in size every two years, dramatically impacting the cost of storage and the performance, reliability, and manageability of large databases
Oracle Database 11 g enables organizations to easily scale large transactional and data warehousing systems using low-cost servers and modular storage and provide fast, reliable performance. data warehousing systems using low-cost servers and modular storage and provide fast, 24x7 access to data. Oracle Database 11 g delivers new and innovative features to further improve performance and scalability
in demanding environments.
Store all your data securely with SecureFiles
SecureFiles is Oracle's next-generation product for storing large objects, LOBs (
such as images, large text objects, or advanced data types including XML, medical imaging, and geospatial raster objects), in the database. SecureFiles. SecureFiles offers superior performance that is fully comparable to file systems. In addition, it offers advanced features such as intelligent compression, transparent encryption, and transparent duplicate
removal.
Improving Performance and Minimizing Storage Costs with Online Transaction Processing Compression
Oracle Database 11 g supports data compression for update,
insert, and delete operations commonly used in online transaction processing (OLAP) applications. Previous versions of Oracle Database supported compression for batch data load operations commonly used in data warehouse applications
programs. Oracle Database 11 g OLTP Table Compression improves database performance
by using memory more efficiently to cache data and by reducing I/O for table scans
. With OLTP table compression, you can achieve a 2x to 3x compression
ratio with minimal processing overhead.