Contents → Related Documentation Conventions Documentation Accessibility 1 Oracle Database 10 g, Release 1 New … New Segment Resource Estimation Online Segment Shrink Proactive Tablespace Management Undo Advisor … Flushing Database Resource Manager - Adaptive Consumer Group Mapping New Performance Overview Charts in … - New
Creating a New Role → application. To create a new role: From the Administration Page, click Roles under the Security heading … . Click Create. On the Create Role page, enter the name of the new role. For instance, enter APDEV to … create a new role for application developers in your organization. Click OK. A page appears with a list … of all roles,
Creating a New Index → performance after the new indexes are added. After index creation, Oracle automatically synchronizes the … drop-down menu. Click Go. The Create Index page appears. Name the new index PRODUCTS_SUPPLIER_IDX. For … Order. Click OK to create the index. After the index is created, the Indexes page appears with a confirmation message. The new
Reduced Downtime for Application and Database Upgrades → achieved by using standby databases, with new support allowing an organization to switch between different … longer invalidate the PL/SQL packages built on these objects, allowing new redefinition operations
SQL Support for Analytic Applications → This release introduces interrow calculations by way of new SQL clauses, which add support for … symbolic cell addressing and automatic and custom formulas. These new capabilities make it easy to build … are also supported by the new capabilities, allowing users to build persistent models and forecasts … . In addition to these
OLAP Support for Analytic Applications → This release contains support for new OLAP capabilities using the built-in analytical workspaces of … the Oracle Database. New PL/SQL and XML-based interfaces are provided for the creation of … calculations can also be similarly defined and created. These new interfaces are used directly or by way … user to learn OLAP DML commands.
Database Overall → of the new capabilities, as well as address some common requirements requested by customers.
Improved Very Large Database (VLDB) Support → Several new capabilities and improvements have been provided to support customers who are planning … of new local index partitions during partition maintenance operations, enabling automatic
Java Documentation → Table 2-6 Java Documentation Documentation Part Number Description Oracle Database JDBC Developer's Guide and Reference B10979-01 A discussion of how to use Oracle JDBC drivers, including Oracle extensions and APIs. Oracle Database JDBC Release Notes B12143-01 Provides important last minute information not included in the Oracle Database Documentation Library. Oracle Database JPublisher User's Guide
Oracle Streams → … New functionality includes downstream capture, which offloads the capture and mining operations from … been tuned to improve most operations. Oracle Streams also offers two new options for instantiation … explicitly enqueues the LCR into the persistent queue. A new name-value pair for the action context of an … as it
Application Tuning → New tools have been introduced in this release to minimize the manual SQL tuning efforts. These … tools provide advice to administrators on new indexes or materialized views that can be created to … them more effective. SQL Tuning Advisor SQ L Tuning Advisor is a new server tool that eliminates … tuning the SQL along with their
PL/SQL Improvements → the application developer. It introduces a brand-new optimizing compiler that generates faster code … . A number of powerful new language features are added (for example, support for ANSI syntax for … ). New utility packages are added for data compression and to provide a simple API for sending email … new, compact
Data Access Support → SECOND, INTERVAL YEAR TO MONTH) datatypes. It has also added support for the new optimized float and … parameter binding; the new optimized float and double datatypes introduced in Oracle Database; and … improved overall data access performance. Moreover, ODP.NET has introduced a new LOB property … DB, making XML easy to use and
Backup and Recovery Manageability → text editor. Oracle Enterprise Manager has added new backup management functionality to provide easy … backup sets. Bounded Backup Window You can use the new DURATION option to give an RMAN BACKUP command … out-of-space condition is imminent in the Recovery Area, potentially preventing new backup and archiving operations.
Bioinformatics → support of new DOUBLE and FLOAT datatypes in the database, resulting in improved performance for … applications that require large amounts of numeric computations. New built-in statistical functions … algorithms. In addition, new BLAST similarity searches provide specific support for analysis of genetic
List of Tables → 2-1 Oracle Database 10g Server and SQL*Plus Documentation 2-2 Oracle Database 10g Data Mining Documentation 2-3 Oracle Spatial Documentation 2-4 OLAP Documentation 2-5 Oracle Windows Documentation 2-6 Java Documentation 2-7 Oracle Enterprise Manager Documentation
Utilities → SQL*Plus a nd i SQL*Plus have been improved in this release to take advantage of new capabilities … to. Substitution variables are now dereferenced in the user prompt. New predefined variables exist
Performance and Scalability → As with previous releases, this release also focuses on continuing to deliver the high levels of performance and scalability the Oracle Database is renowned for.
Database Centric Application Development Environment → Ora cle HTML DB is a declarative development tool and a framework for the development and deployment of database-centric web applications. Oracle HTML DB accelerates application development through built in features such as design themes, navigational controls, form handlers and flexible reports. Using only a web browser, users can quickly assemble a sophisticated database driven web application.