Default values shown in Table apply only if no password is specified. Used for performing database administration tasks. Oracle9i Database Administrator's Guide. Oracle Text Reference. Run catnsnmp. Oracle Intelligent Agent User's Guide. Oracle Label Security Administrator's Guide. Oracle Spatial User's Guide and Reference. Allows non-native plug-in formats for one session. Oracle interMedia User's Guide and Reference. Block change tracking for fast incremental backup.
Unused block compression in backups. Block-level media recovery. Lost Write Protection. Automatic Block Repair. Requires Oracle Active Data Guard option.
Parallel backup and recovery. Tablespace point-in-time recovery. Trial recovery. Fast-start fault recovery. Flashback Table. Flashback Database. Flashback Transaction. Flashback Transaction Query. Optimization for Flashback Data Archive history tables. Oracle Real Application Clusters. Extra cost with EE, included with SE. Automatic Workload Management. Requires Oracle Real Application Clusters.
Quality of Service Management. Client Side Query Cache. Query Results Cache. Database Smart Flash Cache. Oracle Advanced Security. Oracle Label Security. Fine-grained auditing. Virtual Private Database. Development Platform. Oracle Developer Tools for Visual Studio. Microsoft Distributed Transaction Coordinator support. Active Directory integration. Oracle Change Management Pack.
Oracle Configuration Management Pack. Oracle Data Masking and Subsetting Pack. Oracle Diagnostics Pack. Oracle Provisioning and Patch Automation Pack.
Oracle Tuning Pack. Extra cost option, also requires the Diagnostics Pack. Oracle Real Application Testing. Database Resource Manager. Instance Caging. SQL Plan Management. SQL Tuning Sets. Oracle Partitioning.
Oracle OLAP. Oracle Database 11g Express Edition is a free program that provides a browser-based interface to administer databases Oracle Database 11g : Administration Oracle 11g is an Oracle geodatabase Oracle 1z exam, is a Oracle certification. In the 1z exam resources, you will cover every field and category Using 1z practice questions and answers you'll pass the exam for sure.
It is also able to restore the database to a consistent state when log corruption is detected during recovery. If corruption needs to be repaired through media recovery, a new block media recovery feature enables only the corrupt blocks to be recovered while the remainder of the table is online.
These improvements include the following new features:. Oracle9 i can recover from crashes more quickly than in previous releases with a new two-pass recovery algorithm that ensures that only the blocks that need to be processed are read from and written to the datafiles.
A new time-based mean time to recover MTTR parameter also makes it much easier to set a limit on crash recovery time. Oracle9 i includes improved diagnosis of a failed instance and enables diagnostics to be read after recovery on the failed state. This helps diagnose the cause of the failure after its first occurrence, rather than requiring users to set events that capture data in future failures.
For multi-node systems, Oracle9 i provides faster failure detection--for instance, node and network failures--and reconfiguration for Oracle9 i Real Application Clusters, reducing downtime due to a system fault. Oracle Fail Safe Configuration for Windows provides the high availability and protection from system failures that e-businesses need to take advantage of multi-node clusters with the enhanced functionality of Windows This allows for configurations where multiple databases on multiple nodes share a common backup node, reducing the cost of providing redundancy to multiple applications.
Advanced Replication, formerly known simply as Replication, includes the following new features:. Oracle9i Replication. Oracle9 i systems management is simplified and improved with increased self-management and self-tuning capabilities. Also, Oracle9 i integrated system management tools create a complete view of all database and host critical processes, making it possible to quickly and completely assess the overall health of an e-business infrastructure.
Oracle9 i includes several new features that make the Database more autonomous and self-managing. For example, new features such as automatic undo management, automatic SQL execution memory management, and automatic segment-space management enable database administrators to delegate many daily administrative tasks to the server itself. Oracle9 i databases are capable of managing their own undo rollback segments.
Administrators no longer need to carefully plan and tune the number and sizes of rollback segments or to decide strategically how to assign transactions to a particular rollback segment.
Oracle9 i also enables administrators to allocate their undo space in a single undo tablespace with the database taking care of issues such as undo block contention, consistent read retention, and space utilization. Memory management is another area which has been given significant attention in Oracle9 i. Traditionally, administrators have needed to shut down the instance in order to grow or shrink System Global Area SGA components.
Oracle9 i introduces a dynamic memory management feature that enables dynamic resizing of the buffer cache and shared pool. A buffer cache size advice mechanism that predicts the performance of running with different sizes for the buffer cache is also available with Oracle Enterprise Manager.
Oracle9 i provides transparent management of working memory for SQL execution by self-tuning the initialization runtime parameters that control allocation of private memory. This feature enables low-end users to reduce the time and effort required to tune memory parameters for their data warehouse and their reporting applications, while high-end users are able to avoid memory tuning for individual work loads. Oracle9 i provides transparent management of segment space in the Oracle database.
With automatic segment-space management, you use bitmaps, which describe the status of each data block within a segment with respect to the amount of space in the block available for inserting rows, to enable Oracle to automatically manage the free space in the segments.
Several new features simplify administration of the Oracle9 i database. With the introduction of the server parameter file feature, server parameter file changes persist across database shutdowns and startups. This feature also enables the administrator to start the database from remote machines without a local copy of the server parameter file. This facilitates database performance tuning because parameter changes made by performance management tools such as Oracle Enterprise Manager and changes made by internal self-tuning now persist across shutdowns.
The Database Configuration Assistant has been redesigned to include saved definitions of existing databases in the form of templates provided by Oracle that can, in turn, be used to generate new databases. Users can create their own templates by modifying existing templates, defining new ones, or by capturing the definition of an existing database. When creating a database with the Database Configuration Assistant, users can include Oracle Sample Schemas at database creation or can add these schemas later as an option.
Oracle Sample Schemas are the basis for many of the examples used in Oracle documentation. Oracle9 i introduces Oracle-managed files. This simplifies database administration by removing the necessity that administrators directly manage the files that make up an Oracle database. Instead, Oracle9 i uses internal standard file system interfaces to create and delete files as needed.
While administrators must still be involved in space planning and administration, Oracle-managed files automates the routine tasks of creating and deleting database files. Operating system files associated with a temporary file also can be deleted. With the introduction of default temporary tablespace, the SYSTEM tablespace is no longer used as the default storage location for temporary data. Resumable Space Allocation, another feature introduced in Oracle9 i , enables an administrator temporarily to suspend a large operation, such as a batch update or data load, if they start to encounter out-of-space errors.
This enables the administrator to fix the problem and resume the operation from the point of interruption without disrupting normal database operation. Oracle9 i supports databases created with multiple block sizes and enables administrators to configure corresponding sub-caches within each alternative block size.
It also enables administrators to transport tablespaces more easily between different databases for example, from an OLTP environment to a data warehousing environment. Oracle9 i also provides for better control over database downtime by enabling administrators to specify in number of seconds the mean time to recover MTTR from system failures. This feature, coupled with more dynamic initialization parameters, helps administrators further improve database availability. Database administration is simplified because parameter changes made through performance management tools--such as Oracle Enterprise Manager--and changes made by internal self-tuning parameters now persist across shutdowns.
Oracle9 i introduces many new features and enhancements that increase manageability and greatly expand functionality. Persistent RMAN settings can be created for automatic channels, channel parallelism, retention policies, backup options, and auxiliary filenames, and can be applied to any session, thus removing the need for manual allocation of channel settings. Recovery Manager implements a recovery window that controls when backups expire. Recovery Manager also automatically marks as obsolete all backups and archived logs no longer required to restore the database to a point in time during the recovery window.
These features are designed to reduce administrator time and effort spent performing routine backup activities tasks by automating of the most commonly performed tasks. Block media recovery can perform media recovery on individual blocks in a datafile while the datafile remains online. The block media recovery feature is only available with RMAN. The new control file auto backup feature provides for restoring or recovering a database even when a Recovery Manager repository is not available.
Recovery Manager in Oracle9 i also features enhanced reporting and a more user-friendly interface. In Oracle9 i , Oracle Enterprise Manager continues to provide easy-to-use management tools that support the new capabilities of the database and the entire e-business platform. In Oracle9 i , Oracle Enterprise Manager has the ability to connect to multiple target databases without starting up the Oracle Management Server. To further simplify management tasks, Oracle Enterprise Manager has been enhanced to include guided, expert diagnostics and problem resolution, as well as greatly enhanced reporting capabilities.
Advice and recommendations about how properly to configure an Oracle environment, how effectively to monitor its performance, and how quickly to resolve problems has been incorporated directly into the Oracle Enterprise Manager management tools. For example, administrators can instantly display a set of overview charts to show the overall health of their system, with indicators that automatically alert administrators to potential problems.
Administrators can then analyze the problem by following the proper steps required to diagnose the problem's underlying cause. Because all essential management functions are also Web-based, administrators can manage their systems directly from a Web browser. Oracle Enterprise Manager can also publish detailed reports to a Web site, allowing administrators easy access to any systems management information they wish to publish. In Oracle9 i , Oracle Enterprise Manager enables administrators to monitor the performance of more than one system.
With this release, administrators are able to monitor the response of their entire Oracle-based system and to ensure that they are meeting the required business service level agreements. This capability is critical to users such as application service providers, e-business sites, or any business whose success depends on maintaining superior response time, performance, and availability of their information technology systems.
Oracle Enterprise Manager enables administrators to monitor service levels and automatically alerts them to any degradation in performance. Extensive service level reports are also available to provide a complete picture of the performance of the system. In addition to service level reports, reporting capabilities throughout all of Oracle Enterprise Manager have been significantly enhanced.
A comprehensive set of predefined reports are included with Oracle Enterprise Manager that document the configuration and health of the entire Oracle environment. Reports can be generated, for example, on the configuration of databases, the performance of applications over the last week, or the current load on the system. Customized reports can also be generated using a site's own data or by mixing and matching the predefined report topics that Oracle Enterprise Manager provides.
These reports can be automatically generated and posted to a Web site for convenient access across the organization. Oracle Enterprise Manager Administrator's Guide. Key enhancements in Oracle9 i include the following enhancements to Oracle Net Services:. The Oracle Net Configuration Assistant enables you to create multiple Oracle Contexts to facilitate management of a complex naming structure in a directory server.
In future releases, Oracle Names will not be supported as a centralized naming method. This provides a single point of definition for all data in a directory server and does not require that both Oracle Names servers and directory servers be maintained separately and simultaneously. Key enhancements in Oracle9 i include the following enhancements to data cartridge functionalities:. Discrete domain indexes, called local domain indexes, can be built on the partitions of a range-partitioned table.
Local domain indexes are equi-partitioned with the underlying table: all keys refer only to rows stored in the local domain index's corresponding table partition. The extensible optimizer supports collection of user-defined statistics partition level and aggregate for partitioned tables. Instances of an indextype or object inherit an association of a statistics type.
Now you can replace this with a NULL association for occasions when the benefit of using a better plan may not outweigh the added cost of compiling the cost or selectivity functions implemented by the statistics type. Oracle9i Data Cartridge Developer's Guide. For e-business and mobile applications, the location capabilities in Oracle9 i and Oracle Spatial have been greatly enhanced.
Support for mobile devices and formats--such as WBMP, interactive voice response, microbrowsers and delivery through Oracle i AS Wireless--make Oracle9 i a complete platform for the delivery of content for mobile applications. Oracle Spatial User's Guide and Reference. Heterogeneous Services, a component of the database that enables Oracle9 i to access and process data from non-Oracle data systems, includes the following new features:.
Oracle9i Heterogeneous Connectivity Administrator's Guide. Oracle9 i continues to challenge the competition by providing the best platform support for business intelligence in medium to large scale enterprises. Oracle9 i technology focuses especially on the challenges raised by the large volume of data and the need for near real time complex analysis in an Internet-enabled environment.
Additionally, Oracle9 i provides the first true business-intelligence platform, including extended database support for online analytical processing OLAP , data mining, and major data extraction, transformation, and loading enhancements. Oracle9 i key focus areas for business intelligence include the following:.
Oracle's materialized views, which provide a mechanism for improving the performance of almost any type of query, have been enhanced in Oracle9 i in important ways:. Oracle9 i provides an automated mechanism for dynamically allocating runtime memory to each query. By automating the allocation of runtime memory, Oracle9 i improves the overall throughput of the data warehouse and makes it possible to support larger numbers of users at the same levels of performance. The automatic memory tuning feature ensures that memory-intensive queries receive sufficient memory, while memory-light queries are not given too much memory.
By making more effective use of memory, Oracle9 i increases overall query performance. Oracle partitioning delivers significant improvements in the manageability, availability, and query performance of large tables and indexes. Partitioning is a key technology for data warehousing, where large tables are commonplace. Oracle partitioning capabilities have been enhanced in Oracle9 i with the addition of a new partitioning scheme, list partitioning. List partitioning gives data warehouse administrators precise control over which data belongs in each partition.
For each partition, the data warehouse administrator can specify a list of possible values for the partitioning key of the rows in that partition. Each partition in a list partitioning scheme corresponds to a list of discrete values. Oracle9 i includes the following data extraction, transformation, and loading new features:. To increase efficiency and reduce the time taken to load and refresh critical data warehouses, Oracle9 i provides support for external tables to allow data from external systems to be quickly loaded into the database.
External tables do not reside in the database and may be in a format, for which a driver is provided. Both of these SQL enhancements allow more complex data loading to be processed within a SQL single statement, unlike the old way, where several process steps were required. With multitable inserts, data can be inserted into more than one table using a single SQL statement; this is more efficient than using multiple, separate SQL statements for each table.
Multitable inserts make SQL more useful for data transformations and conditional handling. An incremental refresh, also known as a MERGE, of a table requires two tasks: new records will be inserted and existing records will be updated. Table functions can be used in the FROM clause of a query to return a collection either a nested table or a varray of rows as output. A table function can use parallel execution, and result rows from can be pipelined--that is, iteratively returned.
Oracle9 i introduces bitmap join indexes, which provide further improved performance for a specific class of join queries.
0コメント