Some new features of the management of Oracle9i: all super Published: 2001/02/07
Thesis:
Oracle9i's launch enhances the manageability of Oracle databases in many aspects, making Oracle database administrators to greatly reduce their daily work. This article will introduce some new features in Oracle9i management.
text:
Some new features in Oracle9i have been, and the main responsibility of Oracle Database Administrators has been managed for Oracle databases and database applications. Oracle9i's launch enhances the manageability of Oracle databases in many aspects, making Oracle database administrators to greatly reduce their daily work. This article will introduce some new features in Oracle9i management. Rehabilitation Manager RMAN Enhancement: In Oracle9i, RMAN adds some new features that help administrators need to cost the conventional backup and recovery related work. The new version of the recovery manager has a friendly interface that enhances the report function. In order to reduce the labor intensity of backup and recovery, the RMAN provides backup settings, which can be archived according to the user needs to be automatically backed up. Rman also provides a backup policy called Recoverer Window that automatically works when backup expires. These characteristics greatly reduce the daily maintenance work of Oracle database administrators. Management of rollback segments: In Oracle8i and previous versions, the management of rollback segments is a very headache. The database administrator needs to carefully calculate the number of rollback segments according to the size of each transaction, and the size of each rollback segment. Starting from Oracle9i, all this has become a history: the administrator only needs to specify a table space specifically for use in the rollback segment. As for how many returning segments, the size of each returning segment, the spatial utilization rate of the rollback segment, the segment competition, etc., you can have Oracle yourself to specify. Dynamic Memory Management: In the past, the Oracle database administrator wants to adjust the size of each part in the SGA, only to close the instance, uninstall the database, modify the initialization parameters, and then restart. Oracle9i introduces this feature of dynamic memory management, allowing dynamically changing data block buffers and shared pool size. 9i also introduces this feature of automatic optimization, which enables Oracle to dynamically change the size of private memory according to the execution of the SQL statement. Continued statement execution: Oracle9i allows administrators to temporarily trouble or delay some of the very resource operations, such as some batch updates or data loading, and then continue running from the interruption when allowing. This feature allows the administrator to temporarily interrupt some operations without affecting the database normally, and resolve the problem before the problem is or enlarged, and then continue to execute at the interrupt. Continuent init.ora (persistent init.ora) Oracle9i introduces this feature of the continuity of init.ra in the start of multiple databases. This allows the database to be launched when there is no copy of the init.ora, there is no copy of the remote database. This feature has great help for the optimization process of the database. For example, due to internal automatic optimization or by Oracle Enterprise Manager, the init.ra system parameters change, after this feature, you can The system performance is compared to the parameters when system performance is compared to different parameters. In addition to the above introduction, there are many other new features that are unique to Oracle9i. For example, Execution Plan History allows DBA to know how the execution efficiency of a previously running statement doesn't have to re-execute a statement. Oracle Management File (Oracle Managed Files) allows DBA processing database space management issues without having to manage space in Oracle.