This new filter takes advantage of the automatic filtering technology licensed from Verity, Inc. Oracle Text's automatic filtering technology, licensed from Verity, Inc.
This technology also enables you to convert documents to HTML for document presentation. Oracle Text Reference for details.
These new procedures enable you to see the keywords in their surrounding text, allowing you to evaluate them in context. With online indexing for local partitioned indexes, you can now create an index on a partition while updating it; the same as with unpartitioned indexes. Also provided are:. Each returned document conforms to an XML schema that is registered with the database. Once this metadata has been extracted from the image, it can be stored in an Oracle Database, indexed, searched, and made available to applications using the standard mechanisms of Oracle Database.
This new inter Media capability allows Oracle Database 10 g Release 2 to serve as the repository for shared multiterabyte medical imaging archives used by HIMMS and PACS systems, life sciences and medical research centers, and government agencies.
Oracle Multimedia User's Guide for details. In addition to the current support for format metadata height, width, mimetype, etc. Information supplied by digital cameras, image editing software programs, news and wire services, such as photographer, location, date, time, and other application data can now be extracted and represented as a collection of XML documents returned in XMLType.
Once metadata is extracted, it can be stored in an Oracle Database, indexed, searched and made available to applications using the standard mechanisms of Oracle Database. By placing the metadata and the image data in the same containing binary image, both types of data can be shared and exchanged reliably as a unit. Java Advanced Imaging 1. The following sections describe new features for Oracle Database 10 g Release 2 for the database in general.
Manual database upgrades are now easier to do. For any database version being upgraded to Oracle Database 10 g Release 2, only one common SQL script has to be invoked when performing a database upgrade. Specifying a version-specific script is no longer required, because Oracle now automatically determines what version is being upgraded and runs the appropriate upgrade scripts for that database and all of its included components.
Oracle Database Upgrade Guide for details. The Pre-Upgrade Information Utility has been enhanced to provide improved resource estimations for tablespace space usage and elapsed upgrade runtime. This feature improves the manageability of Data Pump jobs and allows users to get accurate information about possible issues with their specific database upgrade prior to running DBUA or performing a manual upgrade. This allows users to quickly start using Data Pump because a default directory object is automatically created.
Data Pump Export dump files can contain database metadata objects in a compressed format, allowing dump files to consume less operating system disk space. This metadata is automatically uncompressed during Import. In previous releases, the size of the file was unlimited. In previous releases, Enterprise Manager only monitored Data Pump jobs that had been created using Enterprise Manager.
However, it is a common activity for a DBA to create Data Pump jobs without using Enterprise Manager and it is possible for these jobs to take a very long time hours or days to complete.
Enterprise Manager is a database monitoring tool and has been enhanced to monitor all Data Pump jobs, whether created by Enterprise Manager or not. This new features improves the manageability of Data Pump jobs. You can get more information about Data Pump job completion and specific dumpfiles. With this feature, you can reduce the amount of space required for tablespaces by shrinking tablespace storage allocation. Large datafiles in production systems can be reduced so that smaller datafiles are created during Import on test systems.
The benefit of this feature is the ability to reduce the amount of tablespace storage required for datafiles. This is useful for duplicating schemas across databases, using Export and Import, when you cannot guarantee that object types will have identical OID values in those databases. You can enter XQuery 1. The following sections describe new features for Oracle Database 10 g Release 2 in the Security and Directory areas.
Privacy, confidentiality, and the protection of personally identifiable information PII is a global concern in today's economy. Oracle provides a wealth of server-enforced protections for private and confidential information. Oracle Database 10 g Release 2 introduces Transparent Data Encryption that quickly and easily encrypts sensitive information.
Existing applications generally continue working without any modification because the data is transparently decrypted when accessed through SQL. Oracle uses industry standard encryption algorithms including AES and 3DES to encrypt columns that have been marked to be encrypted. Key management is handled by the Database. This feature provides transparent data encryption and key management. Businesses can protect sensitive data in Oracle databases without any changes to their application.
SQL interfaces to Key Management hide the complexity of encryption. This feature mitigates liability due to storage theft. The ability to focus more on security policies and less on low level implementation details is key to securing the enterprise. Oracle Database 10 g Release 2 Transparent Data Encryption manages the encryption keys for the application administrator, simplifying the implementation and management of encrypted data.
In addition, Oracle Database 10 g Release 2 auditing enhancements include writing audit data in XML format to the operating system and providing additional protections for audit data at the operating system level. Application security is improved as the application schema password is not exposed at connection time.
It also enhances the existing proxy capability by allowing proxy users to be directory users. Audit trail can be written to the operating system files in standard XML format. These logs can also be viewed using dynamic views providing better access to information in the operating system audit logs.
This feature enhances database operating system audit capability to support XML audit trail format. This allows the DBA to build custom tools to trace abnormal activities and view and mine audit logs.
It also enhances the ability of the DBA to view operating system audit information when authenticated to the database. Oracle Database Security Guide for details. A major objective for Oracle Database 10 g Release 2 is to ensure you can easily install and configure Oracle Database in a hardened configuration. This includes locking default accounts, providing database roles for privilege management, and protection of sensitive information. Oracle Database 10 g Release 2 provides additional security for passwords used in fixed database links.
The privileges have been removed from the connect role:. This feature helps you deploy secure configurations by helping enforce the least privileged principle. The ability to leverage security with Oracle features, such as Real Application Clusters, is key to deploying secure and scalable solutions. This provides customers additional capabilities for protecting sensitive information.
In addition, Oracle Wallets have been enhanced to provide the ability to store username and passwords for command line operations. In addition, Oracle Database 10 g Release 2 introduces a new command line proxy capability that allows authorized users to proxy to different accounts upon authentication to the database.
Oracle Wallet functionality has been extended beyond PKI credential store to include username and password storage. This enables a user to store his or her username and password in an Oracle Wallet and have the password picked up automatically at connection time. Administrators and application developers now have a secure alternative to hardcoding usernames and passwords into scripts and other programs. This feature enforces password age, disabled accounts, and account lockouts for directory-managed users who access Oracle databases.
This feature allows security administrators to enforce centralized password policies for enterprise users when accessing one or more Oracle databases. It provides for reduced administrative costs as there is a single point of administration. This enhancement allows organizations to better manage security across the enterprise. Oracle Label Security support for RAC means that security policies will be synchronized between nodes. Oracle Label Security session security settings can fail over to other nodes automatically.
Oracle customers using RAC can now leverage Oracle Label Security to meet organizational security requirements for protection of sensitive data. Oracle Label Security Administrator's Guide for details. The following sections describe new features for Oracle Database 10 g Release 2 in the Grid Computing area.
This release provides features to simplify data provisioning within a Grid environment, making it easier and faster to archive, move, and copy large sets of database data. These new features enable performing these bulk provisioning operations with no effect on any production database. This feature enables storage of point-in-time copies of file and tablespace data for reporting, auditing, and information sharing.
Groups of files for example, tablespaces can be copied to the repository, or from the repository to another database or file system, without effecting access to production data.
Oracle Streams Concepts and Administration for details. This feature provides the ability to create a transportable tablespace without making it read-only.
This enables a DBA to copy or move a tablespace of data using the transportable tablespaces feature without making the tablespace read-only in the source database.
The Oracle Scheduler has been enhanced to provide additional critical functionality to meet the scheduling needs of enterprise customers. In addition to functionality and usability improvements, jobs can now be chained and scheduled based on external events. This feature addresses the need to perform an action based on the occurrence of an event.
The Scheduler can perform actions based on external events or actions can be performed based on the Scheduler generated events. A job chain describes a set of jobs that are interrelated. Rules are used to define the dependencies between the jobs.
This feature enables you to define a custom calendar such as a business fiscal year. Jobs can be scheduled to run on the last work day of every fiscal quarter. This feature also enables the use of rules for example, Memorial Day is the last Monday of the month of May to identify dates and save them as a schedule. Existing schedules can be combined to create composite schedules. The Scheduler enhancements enable customers to define complex schedules such as the last working day of every fiscal quarter.
The following sections describe new features for Oracle Database 10 g Release 2 in the Grid Management area. This release includes enhancements to configuration assistants or plug-ins and post-installation configuration. Enterprise Manager offers functionality to manage and monitor ASM and disk groups as well as automating the various stages involved in converting an existing non-ASM database onto ASM-based storage.
This feature administers ASM disk groups as standalone entities, independent of the creation of a database. In Oracle Database 10 g Release 2 You can, therefore, prepare an ASM environment for an existing database using the DBCA without concurrently creating a new and unneeded database. However, you can continue to use the DBCA to create a new database and build an ASM instance, if one does not already exist, to manage the new database's storage requirements.
This feature provides a wizard interface to upgrade databases to the new release. This release provides new and improved features to Enterprise Manager that facilitate easier management of the database.
This feature provides a way to add or configure cluster targets either through auto discovery or manual configuration. Currently you cannot manually add cluster targets in Enterprise Manager. This feature provides a way to create and configure cluster targets in case cluster discovery fails during installation.
The Access Advisor user interface in Enterprise Manager has been enhanced to improve the user experience and expose more powerful features of the Access Advisor. External object cloning enhancement in the Enterprise Manager database cloning feature ensures that external objects, which are tables stored as external files, get copied over to the destination systems during the clone operation.
This ensures that no data is left behind. The ability to clone external objects extends the database cloning to ensure that all data is cloned, not just objects residing within the database. The database administration area has been enhanced through the addition of some minor features that increase the DBA's productivity. Enterprise Manager provides the following administration capabilities for database auditing:. This feature makes it convenient for the DBA to manage database auditing in the Enterprise Manager Web console, where all other aspects of Oracle Database are managed.
Oracle Database 10 g lets you guarantee undo retention. In Enterprise Manager 10 g Release 2, you can enable and disable undo retention through the Enterprise Manager user interface. When you enable this option, the database never overwrites unexpired undo data, that is, undo data whose age is less than the undo retention period.
This option is disabled by default, which means that the database can overwrite the unexpired undo data to avoid failure of DML operations if there is not enough free space left in the undo tablespace. By enabling the guarantee option, you instruct the database not to overwrite unexpired undo data even if it means risking failure of currently active DML operations.
Therefore, use caution when enabling this feature. A typical use of the guarantee option is when you want to ensure deterministic and predictable behavior of Flashback Query by guaranteeing the availability of the required undo data. Enterprise Manager has added new functionality to Backup Management that provides a single view of all backups run against the databases in a domain.
The details of the backup are available by clicking on the specific backup for the database. By providing a combined view of all database backups and their status, a DBA can quickly pinpoint when a backup job did not complete. A drill down to the log allows the DBA to fix the problem and restart the backup. This release provides better drill down and diagnostics around cache coherency statistics. Enhanced diagnostics for cache coherency helps users do more diagnostics around the cache coherency statistics.
This feature provides better integration between the Segment Advisor and segment findings which provides a more unified interface with consistent findings and recommendations.
This release supports the new server features provided by the This feature helps integrate the Segment A dvisor with the segment findings. These enhancements help support non-ASSM tablespaces and detection of chained rows in segments.
In previous releases, lock statistics would lock the state of statistics based on object usage in the application. When statistics on a table were locked, all the statistics depending on the table, including table statistics, column statistics, histograms, and statistics on all the dependent indexes were locked.
For Oracle Database 10 g Release 2, the database server provides the lock and unlock feature in the optimizer statistic area. Enterprise Manager provides support for these features with user-friendly wizards to help assist DBAs with the operations.
You can now lock the statistics to a state where you know the statistic is good and will not change. For example, you can collect statistics for a volatile table while it is fully populated and freeze the statistics as a set of representative statistics.
You can also lock the state of the statistic when there are no statistics. This is useful to keep the statistics on a table uncollected in order to use Dynamic Sampling. When you no longer want the statistics to be locked, use the Unlock wizard to unlock the statistics. This feature provides management of Directory Objects in Enterprise Manager including search, view details, and life-cycle operations such as create, delete, and update.
The required undo tablespace size is computed as the maximum of the auto tuned value of undo retention and the low threshold value. It is not displayed if auto tuning is enabled the default. For Oracle Database 10 g Release 2, the database Storage and Configuration policies have been enhanced as follows:. This feature enhances the existing storage and configuration policies by adding new database storage and configuration policies and consolidating any overlap in the existing policies. This feature also enhances some existing metrics.
The storage policies help the end user ensure that their tablespaces follow best practice rules. For example, they help the user identify dictionary-managed tablespace or tablespace that contains mixed data segments. This helps the end user in correctly setting up tablespace storage, thus avoiding space and performance problems. The configuration policies check basic database settings to ensure the end user is taking advantage of the latest database features. These policies also help ensure that the databases are configured in the manner recommended by Oracle.
Management of Oracle Spatial in Enterprise Manager includes creation and management of spatial tables, metadata, and spatial indexes. Oracle Spatial provides a SQL schema and functions that facilitate the storage, retrieval, update, and query of collections of spatial features in an Oracle Database.
This feature incorporates additional cache coherency monitoring and improves scalability for large clusters. This feature also provides general improvements in RAC database performance monitoring.
The performance monitoring capabilities have been expanded for RAC environments. There is additional monitoring of cache coherency for RAC instances.
The presented performance data is more meaningful, performance problems are easier to detect, and helps identify the root cause of cluster database performance issues. The Restore Statistics wizard enables restoration of statistics of the databases or their related objects to a specified timestamp in the past within the retention period. For Oracle Database 10 g Release 2, the database server provides the restore statistics feature in the optimizer statistic area. Enterprise Manager provides support with a user-friendly wizard to help assist DBAs with the operations.
If the statistics collected in the management window have caused a sub-optimal plan to be generated, you can revert to past statistics using the Restore Statistics wizard. This feature helps support a predefined Segment A dvisor task for the entire database.
For a selected tablespace, this feature displays the number of segments, segment names, segment types, number of extents, total size of extents for each segment in blocks , the maximum number of extents that can be allocated to each segment, and the percent of the tablespace used.
This feature supports Oracle Database 10 g new feature of statistics collection for fixed and dictionary objects. For Oracle Database 10 g Release 2, the database server provides the capability to gather statistics for fixed and dictionary objects in the optimizer statistic area.
Enterprise Manager provides a user-friendly wizard to help assist DBAs with the operations through the Gather Statistics wizard.
If your database suffers from performance issues due to out-of-date statistics for fixed and dictionary objects, use the This feature displays a table of segments with the ability to sort based on individual columns. The benefit of this feature is an improved display of tablespace segments and the ability to sort into a tabular format.
Now, you can collect and display additional cluster target properties including interconnect information statistics. RMAN has a compression capability built in, and Enterprise Manager has been enhanced to offer the use of this capability within the database cloning feature.
The ability to use RMAN compression during database clone operations reduces the network bandwidth requirements for database cloning operations. This benefits anyone who is cloning over low bandwidth network links, and saves disk space when the database clones are saved for later reuse. The Enterprise Manager Load Data wizard helps you specify a data file and then steps through some simple screens where you can provide information about the structure of the file both character delimited and fixed length files are supported.
These features include enhancements to the patching tool used to patch databases and application server software. It also serves as a backend of Enterprise Manager patching. This feature helps you apply interim patches to your environments. OPatch serves as the backend for Enterprise Manager patching and can therefore achieve large scale patching in Grid environments. This release includes enhancements to Oracle Universal Installer OUI framework and individual product installs that are used for deploying Oracle software.
The improved installation process makes it easier to manage multiple database environments on a single server. This feature provides the ability to clone RAC nodes to add a node to the cluster or to build a new cluster. The ability to clone and extend RAC horizontally is the key element of the Grid message. The RAC install framework includes framework application programming and command-line in terfaces that are needed for Oracle Clusterware and RAC installations on a new cluster or onto a newly added node to an existing cluster.
This feature helps you to provision RAC software and add nodes to an existing RAC environment with minimal manual effort. In this release, Real Application Clusters supports silent installation and operations, and the add note feature.
Silent operations enable you to use non-interactive installs. The add node feature is critical for increasing and decreasing capacity on demand. In summary, RAC provides a simple, scalable, and stable deployment framework. The following sections describe new features for Oracle Database 10 g Release 2 in the Information Integration area.
These features provide functionality and performance enhancements, as well as usability improvements, to make Oracle Streams the most powerful, highest performing, and easiest-to-use information sharing solution for Oracle data.
Downstream capture, the ability to off load the capture process from the production source database, can now be configured for near real-time processing hot mining of the primary source redo logs at the alternate database. A capture process can run on a database other than the source database. The redo log files from the source database are copied to the other database, called a downstream database, and the capture process captures changes in these redo log files at the downstream database.
To improve the performance of certain configurations, downstream capture can now be configured for near real-time processing hot-mining of the primary source redo logs at the alternate database.
This feature enables non-persistent message queuing for user applications. This will enable you to build high performance message queuing applications. This feature enables you to use commit-time to control the order in which user-enqueued events in a queue are browsed or dequeued. Commit-time queues are useful when your environment needs to support transactional dependency ordering during dequeue, or when you need to support consistent browsing of events in a queue.
Oracle Streams can apply changes made at the source site in parallel at the destination site while ensuring that dependent changes are applied in the same order as they were done at the source site. Occasionally, there are complex dependencies among tables that cannot be specified through database objects such as referential constraints.
This feature enhances Oracle Streams to allow for the specification of these complex dependencies and the enforcement of these dependencies when applying the changes in parallel. Oracle Streams Replication Administrator's Guide for details. This feature improves ease-of-use by simplifying access to LOBs within a customized Streams apply process.
Oracle Database 10 g Release 2 provides advanced notification features to support cache invalidation. This feature extends the notification capabilities available with Oracle Streams Advanced Queuing. Previously, nonpersisent messaging was implemented on persistent, AQ messaging. In this release, common tasks such as performing an application upgrade or database migration has been simplified.
This feature improves ease-of-use by providing simplified API's for common tasks such as performing an application upgrade or database migration. Also, it completes RAC transparency by providing queue-to-queue propagation. Enterprise Manager now supports the configuration, administration, and monitoring of Streams in Oracle Database. Notification of failures will speed application failover providing better availability.
Other improvements provide streamlined and more robust communications. This release provides local naming capability, using tnsnames. With this feature, you can use either tnsnames. The benefit of this feature is that JavaNet performs name lookups the same as the C Net stack.
This makes the system administrator's work easier and more consistent when configuring both JavaNet and C Net stack. Oracle Streams AQ provides database-integrated message queuing functionality. Failover will now be instantaneous, regardless of the state of the client when the failure occurs.
In the event of a failure of a database instance, the server will send a notification to clients to initiate failover. The following sections describe new features for Oracle Database 10 g Release 2 in the Location Services area. This release extends the Spatial routing engine and geocoder to work with European countries and improve the quality and robustness of these features including Spatial Analysis and Mining.
The Spatial routing engine introduced in Oracle Database 10 g Release 1 has now been extended to provide driving distances, times, and directions between addresses for over a dozen Western European countries, including but not limited to Germany, United Kingdom, and France.
The Spatial routing engine enhancements enable logistics, transportation, and location-based services applications to build driving direction services for over a dozen Western European countries. Oracle Spatial Developer's Guide for details. Oracle Spatial coordinate systems support the European Petroleum Survey Group EPSG data model and data set that is essential for oil and gas exploration and production systems.
EPSG support provides benefits of standardization, expanded support, and flexibility for oil and gas companies, georaster data vendors, and GIS users in general. All GeoRaster functions now work on both compressed and uncompressed images. Remote sensing imagery results in very large data sets, growing at the rate of a terabyte or more for each day. The capability to store and manage these images in compressed form is key for users and DBAs alike.
You save money on storage costs when image sizes are reduced by up to 80 percent. This release provides performance and scalability improvements to support analysis on very large networks.
The size of a network analyzed using Oracle Spatial network data model is no longer limited by the amount of physical memory available. This release includes graph partitioning, which divides a large network into logical partitions based on partition ID. Logical partitions can be incrementally loaded into memory for analysis. Oracle Spatial network data model graph partitioning creates scalability that is independent of physical memory.
Applications with large networks such as utility networks, street networks, and biological pathway data in life sciences will benefit from this important enhancement. The Spatial topology data model has been extended to support feature-level spatial transactions against persistent topology in the database.
In the previous release, multiple operations were required to insert or update all of the node, edge, and face elements of a feature. Now, a feature insert or update occurs as a single operation.
Whole feature-level inserts and updates dramatically reduce the code required for updating and maintaining topology data sets. This meets the need of major mapping agencies and land management applications.
The following sections describe new features for Oracle Database 10 g Release 2 in the Performance and Scalability areas.
Performance gains are obtained by redesign and code streamlining and do not require changes in customer applications using these features, unless explicitly stated otherwise. Dynamic performance views are essential tools for database administrators to monitor and tune database performance.
With the additional LOB access statistics in dynamic performance views, database administrators are offered a clear picture of LOB access activities. The benefit is reduced maintenance time required to convert to the LOB data type. Depending on the sizes of out-of-line LOBs, LOB loading performance has improved up to five times faster than in previous releases.
Oracle Database 10 g Release 2 includes a number of additional performance optimizations for long running queries, background activities, and other commonly used features. Asynchronous commit allows database clients to do more work while the database writes the redo log to disk. In Oracle Database 10 g Release 2, improvements have been made to checkpointing.
You can now receive notification whenever a change occurs in the database on the result set of registered queries. This feature enables any cache or object holding query results to ensure that it contains the very latest data. The SPLIT command is used to split a single partition of an index organized table into two partitions.
In earlier releases, the SPLIT command moved each of the rows from the existing partition into one of the two new partitions. Index o rganized table performance is improved when a partition of an index organized table is split into two partitions. Rows are not moved if all of the rows in the existing partition fall into one of the new partitions. Oracle Database Performance Tuning Guide for details. This feature reduces amount of data sent by the right side of a join based on the bitmap created by left side of a join.
This improves parallel join performance, especially on RAC, by reducing the amount of data traffic. The following sections describe new features for Oracle Database 10 g Release 2 in the Server Manageability area.
Before making changes, such as hardware or software upgrades, companies typically conduct extensive testing to validate the changes. However, when the change is made on the production system, unexpected problems are often encountered because the testing was not performed with a workload that was a good representation of the production environment.
Tools are available in the market to construct "synthetic workloads" involving multiple users. However, they are not able to adequately simulate the complexities of a real-world workload, such as interactions between concurrent activities and unpredictability of the workload profile.
The Database Replay feature addresses this need by enabling users to perform real-world testing by capturing the actual database workload on the production system and replaying it on the test system.
In addition to the SQL, AWR collects detailed run-time statistics on the top SQL disk reads, executions, consistent gets and uses this information to adjust the rolling collection threshold. The Automatic Maintenance Tasks AMT automate the routine tasks of refreshing statistics when they become stale, and rebuilding indexes when they become sub-optimal. Automated features aside, there are other new 10g features that I find especially intriguing. Oracle10g is one of the most important new releases of Oracle in many years.
The advent of Oracle10g will definitely broaden the footprint of Oracle in the small to mid-sized market, plus provide the Oracle DBA with a wealth of highly-intelligent new features to simplify database administration. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise.
If you enter the table name without the user ID and then connect to the database, you can reselect the table in the source data browser to view it. You can then copy the query statement and paste it in the Query Statement box. If set to true default , distributed transaction processing is allowed.
Applies only to insert operations. The default value is false. If this property is set to true, the hint is used in the Insert statement. Number of records fetched or inserted with each cursor operation. Default is zero. Maximum allowed is The code page translation table tells the integration platform which encoding to use for reading and writing data. For the supported list, see CodePage.
Controls how often data is committed to the database. Default is zero, meaning that data is committed at the end of the transformation, allowing rollback on error. This is the slowest setting. When doing large transformations, this is not practical as it may produce too many transaction log entries. Setting the CommitFrequency to some nonzero value tells the connector to do a database commit after inserting or updating the specified number of records.
This keeps the transaction log from getting too large but limits the restartability of the transformation. Pass-through mechanism that allows you to specify any additional data definition language DDL statements that need to be executed when a new table is created.
There is no default. Allows you to specify the name of the Directory Alias. No default exists for this property. Determines how to store characters in Oracle 11g and 12c source and target files. Default is OEM. For choices, see Encoding Reference. Use this property to include Parallel Hints in statements. Supported ParallelHint values are listed below. This sets the degree of parallelism to the settings of the initialization parameters.
Allows connection to enable query rewriting and to set integrity levels. Property behavior and integrity levels are listed below:.
None - No altered session is issued and query rewriting is disabled. Enforced - The session is altered to allow query rewriting. A materialized view is used, provided that it guarantees the same result as using the detail tables.
QueryRewrite can use no stale materialized views or trust relationships. This is the default value. Trusted - The session is altered to allow query rewriting. A materialized is used, provided that it is not stale. However, QueryRewrite may use trusted relationships, such as those declared by dimension objects or constraints that have not been validated. Stale Tolerated - The session is altered to allow query rewriting.
The materialized view is used even when data in detail tables has changed.
0コメント