Oracle 9i release 2 ~ Availability enhancements - Pro-DBA.com

020 8465 9100

Sales Enquiries

Other Enquiries

oracle support at low prices

oracle dba outsourcing

oracle database tuning

oracle price list

home contact us faqs

our services oracle license sales oracle support app server support sql server support oracle disaster recovery oracle installation oracle tuning backup strategy dba outsourcing emergency help oracle consultancy upgrades, migrations data warehousing business intelligence bids, tenders help service summary

informationoracle 10g news oracle 10g overview oracle 10g release 2 oracle 9i overview oracle 9i release 2 oracle product set events diary affiliate scheme privacy policy about us case studies press room oracle dba jobs

free resources oracle dba scripts oracle links

oracle 9i Release 2 features

Related links: 25% disc. on Oracle9i license prices | Oracle 9i database installation & set up package £800 | Oracle 9i support package for £770 pcm

availability enhancements
Data Guard:

	Oracle Data Guard, the enhanced Standby Database technology introduced in 9i Release 1, has been extended to include automated switchover, automatic network failure handling and enforceable restrictions on nologging operations on the primary database which could affect the standby database.

SQL Apply Mode:

A major new mode has been added to Data Guard - SQL Apply Mode maintains a logical copy of the primary database as the standby and applies the actual SQL statements from the Primary database to the standby. On top of this the standby database in "SQL Apply Mode" is continually available for reporting even as new SQL statements are being applied by the Data Guard broker.

Downtime Reductions:
In an effort to reduce downtime during application upgrades, column and constraint names can now be renamed and the recompilation procedure for PL/SQL procedures and packages has been enhanced to improve efficiency. Only packages and procedures that have been detected as having been altered will be recompiled.


Additional features:

Other availability enhancements:
	The Log Miner utility, now supports LONG and LOB datatypes and mining of redo logs that were archived after the Log Miner was started. Also, supplemental logging is now turned off by default (a change from 9i Release 1). The Flashback Query feature (introduced in 9i Release 1) is now available within individual SQL statements as well as in the session as was previously the case. For example you can now select differences in the same piece of data over time within the same SQL statement.

	<< previous page		next page >>

Copyright Pro-DBA.com 1999-2008, all rights reserved. 11 Greenwich Quay, Clarence Road, London, SE8 3EY.