Oracle 9i. Database New Features by Baird C., Geurin C.

By Baird C., Geurin C.

This booklet introduces the recent positive aspects, new techniques, and improvements of Oracle 9i Database. It references documentation to be had for Oracle 9i, and identifies deprecated or desupported positive aspects. an inventory of positive factors and recommendations by means of variation (Standard variation, company version, and private variation) is given within the Oracle 9i Readme.

Show description

Read or Download Oracle 9i. Database New Features PDF

Best organization and data processing books

Languages and Compilers for Parallel Computing: 10th International Workshop, LCPC'97 Minneapolis, Minnesota, USA, August 7–9, 1997 Proceedings

This booklet constitutes the completely refereed post-workshop court cases of the tenth foreign Workshop on Languages and Compilers for Parallel Computing, LCPC'97, held in Minneapolis, Minnesota, united states in August 1997The e-book provides 28 revised complete papers including 4 posters; all papers have been conscientiously chosen for presentation on the workshop and went via an intensive reviewing and revision section afterwards.

Cloud Computing: Web-basierte dynamische IT-Services (Informatik im Fokus) (German Edition)

Als Internetdienst erlaubt Cloud Computing die Bereitstellung und Nutzung von IT-Infrastruktur, Plattformen und Anwendungen. Dabei wird stets die aktuell benötigte Menge an Ressourcen zur Verfügung gestellt und abgerechnet. In dem Buch vermitteln die Autoren einen Überblick über Cloud-Computing-Architektur, ihre Anwendungen und Entwicklung.

Data Management in a Connected World: Essays Dedicated to Hartmut Wedekind on the Occasion of His 70th Birthday

Info administration platforms play the main an important function in construction huge software s- tems. because glossy functions aren't any longer unmarried monolithic software program blocks yet hugely versatile and configurable collections of cooperative providers, the information mana- ment layer additionally has to conform to those new specifications.

Additional info for Oracle 9i. Database New Features

Sample text

Also, with Oracle9i, the buffer cache and the shared pool can be resized dynamically. Oracle9i can also validate the structure of an object (ANALYZE VALIDATE) while the object is online and accessed by users. Precision Database Repair Oracle9i includes better prevention and improved handling of log file corruption, reducing the risk of extended downtimes due to these failures. It is able to restore the database to a consistent state after log corruption is detected during recovery. If corruption needs to be repaired through media recovery, a new block media recovery feature allows only the corrupt blocks to be recovered while the remainder of the table is online.

One restriction is that the primary key of the table cannot be modified. Online creation and rebuilding of secondary indexes on index-organized tables (IOTs is supported. ) Invalid physical guesses can be repaired online. Indexes can now be created online and analyzed at the same time. Online Fix-up of Physical Guess component of logical ROWIDs (used in Secondary Indexes and Mapping Table on Index-Organized Tables) also can be used. A new capability can fix the physical guess component of logical ROWIDs stored in secondary indexes (on index-organized tables).

Advice-Incorporated Tools Advice and recommendations about properly configuring an Oracle environment, effectively monitoring its performance, and quickly resolving problems has been incorporated directly into the Oracle Enterprise Manager management tools. For example, administrators can instantly display a set of overview charts that show the overall health of their system, with indicators that automatically alert administrators to potential problem areas. Drilldowns from these problem areas then quickly guide administrators through the proper steps required to diagnose problems.

Download PDF sample

Rated 4.49 of 5 – based on 10 votes