| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 9i tidbits (was: sorry for 9i)
I just came back from an Oracle 8i New Features for Administrators =
course,
the instructor said a few things about 9i:
Oracle 8.1.7 will not be certified for Windows2000, but 9i will. =
8.1.6.
currently is the only version certified for Windows2000.
Oracle is no longer going to make enhancements to the PL/SQL side of =
the
database server, they are focusing entirely on the Java side. =
Apparently
Oracle claims that in 8.1.7. java code runs 10x - 15x faster than =
PL/SQL. In 8.1.6. compiled java code is supposedly 5x - 6x faster than compiled PL/SQL. We did compile a java procedure in 8.1.6. as part of an =exercise,
Oracle 9i will support multiple data block sizes in the same database. =
This
way DSS tablespaces can have 32K blocks and OLTP ones can have smaller
blocks. Also helps with transportable tablespaces.
In Oracle9, can do rollbacks without a rollback segment, it does =
rollbacks
in the locally managed tablespaces.
In Oracle9 we can change db_block_buffers without bouncing the = instance.
DBMS_REPAIR only marks bad blocks in 8i, but in 9i it will actually try =
to
repair bad blocks.
Oracle is trying to leave SQL*Net behind (including Net8), it wants to =
use
IIOP, etc. These only work with the MTS. Oracle is trying to put MTS
everywhere, so in Oracle9 it may be an integral part of the database =
server.
Oracle is trying to get rid of the tnsnames.ora file. They want people =
to
use the Oracle Names Server, which is like a DNS server but for Service
Names. (the term "SID" is now bad, the cool term is now "Service".
Hopefully this won't confuse those of us who are talking about Oracle =
on NT,
and we won't have to keep asking "Are you talking now about an NT =
service,
or an Oracle service?").
In 8i instances supposedly register themselves automatically with the server's listener, but our instructor was never able to make that work. Perhaps it will work in 9i.
Sqlplus as you know is supposed to replace svrmgrl, but in 8.1.6. it =
doesn't
work right, it disconnects people for no reason. Hopefully in 8.1. 7 =
and 9i
it will work properly.
I was surprised to hear that RESOURCE and CONNECT still exist in 8i. I think my O'Reilly book says these are throwbacks to Oracle6. RESOURCE bypasses tablespace quotas altogether, while I think I read in Oracle Security (O'Reilly) that CONNECT can also cause problems.
iFS that was released a few months ago is more like a beta version than =
a
real one, don't hold your breath. Wait for the real product to be =
released.
The concept is interesting, but the current version as problems. iFS =
relies
on XML.
Oracle doesn't want to do away with DBAs, but they said they want each =
DBA
to be able to manage more databases, to help reduce costs.
In 8i the import and export utilities still don't use SMP, no word on whether Oracle will ever make them use SMP properly.
If you have any more info regarding Oracle9, I would be curious to hear = it.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst=E8mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique=20 Maritimes Region, DFO | R=E9gion des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20
-----Original Message----- From: Nobody Win [SMTP:application_erp_at_yahoo.com] Sent: Saturday, November 04, 2000 1:40 AM To: Multiple recipients of list ORACLE-L Subject: Soory For 9i Hi All, I am really soory for this silly mistake which i done on this list i again list this documebt but in diffrent format and why yahoo dont scan this doc i use the antivirus and i dont understand why it is in binary. Soory to all. This is the real Story of Oracle 9i. ORACLE 9i SERVER=20 Oracle9i continues Oracle8i's focus on the Internet by providing a series of specific capabilities and product bundlestargeted at eBusiness environments. In addition, Oracle9i continues to add features and capabilities that extends existing investment in mission-critical infrastructure. Oracle9i has been designed with focus on certain key development areas. LogMiner has also been enhanced in Oracle9i to provide comprehensive Log Analysis for all data types. LogMiner now supports index organized and clustered tables, chained rows, LOBs and LONGs, direct loads, scalar object types, and DDLs. LogMiner also displays the primary key, and supports queries on the logs based on content of change (for example, show all changes to employee 'Smith'). A new graphical user interface as well as other database features also make the product easier to both learn and use. ONLINE DATA EVOLUTION Oracle9i contains a new online reorganization and redefinition architecture that allows much more powerful reorganization capabilities. Administrators can now perform a variety of online operations to table definitions, including online reorganization of conventional tables. Essentially, Oracle9i now allows an online "CREATE TABLE AS SELECT" operation. In this new architecture the contents of the table are copied into a new table. While the contents are copied, the updates to the original table are tracked by the database. After the copy completes, the updates are applied to the new table. Once the updates are applied, indexes can be created on the new table. After the indexes are created, any additional updates are applied and the result table replaces the original table. The table is only locked in exclusive mode at the beginning and of the operation while the dictionary data is updated. Using this new architecture, any physical attribute of the table can be changed online. The table can be moved to a new location, the table can be partitioned, the table can be converted from one organization (e.g. heap) to another (e.g. index organized). Additionally, many logical attributes can be changed. Column names, types, and sizes can be changed. Columns can be added, deleted, or merged. The primary restriction is that the primary key of the table can.not be modified. Oracle9i now also supports online create, rebuild, etc. of secondary indexes on index organized tables. Indexes can now be created online and analyzed at the same time. Secondary indexes support efficient fixing of block hints. Administrators are also able to rapidly quiesce the database in order to perform operations that demand no active transactions. Also, with Oracle9i the buffer cache and shared pool can be resized dynamically. Lastly, 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 disk corruption. Should a block corruption need to be repaired via media recovery, a new block media recovery feature allows only the corrupt blocks to be recovered while the remainder of the table is online. Oracle9i is able to restore the database to a consistent state after log corruption is detected during recovery. LogMiner allows changes in the log after the corruption to be retrieved and applied. Trial recovery allows recovery to proceed after a corrupted database block is detected so that the administrator can determine if the corruption is an isolated event. If more corruption's are found, the recovery can be backed out. Oracle9i can also recover from crashes more quickly using a new two-pass recovery algorithm that ensures that only the blocks that need 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. Recovery Manager backup and restore operations can now restart where they left off after a failure. SELF SERVICE ERROR CORRECTION Oracle9i contains very powerful techniques for handling human errors. The DejaView feature of Oracle9i allows data to be queried from a point in the past. Users set the date and time that they would like to view, and then any SQL query that they execute will operate on data as it existed at that point in time. This new capability uses Oracle's multiversion readconsistency capabilities to restore data by applying undo as needed. Administrators can now configure undo retention by simply specifying how long undo should be kept in the database. Using DejaView, a user can query the database as it existed this morning, yesterday, or last week. The speed of this operations depends only on the amount of data being queried and the number of changes to the data that need to be backed out. Using LogMiner, the change history of a database can be queried from the logs. LogMiner now allows content based data filtering. For example, users can query just the changes to the customer John Smith. This capability enables change history to be queried at the row level. Since Redo and Undo are maintained by the database for internal consistency, enabling these capabilities adds no overhead. INCREASED TRANSACTION THROUGHPUT ON ORACLE PARALLEL SERVER The completion of Cache Fusion in Oracle9i allows customers to easily take advantage of the scalability provided by Oracle Parallel Server, with little or no reduced performance cost. This allows customers to horizontally scale the database tier as usage and demand continues to grow. The Oracle9i Cache Fusion architecture utilizes the collective caches of all the nodes in the cluster to satisfy database requests. Query requests can now be satisfied by both the local cache or any of the other caches. This reduces diskI/O. Update operations do not require disk I/O for synchronization since the local node can obtain the needed blockdirectly from any of the cluster database node caches. Expensive disk I/Os are only performed when none of the col-lectivecaches contain the necessary data and when an update transaction performs a COMMIT operation that requires disk write guarantees. This implementation effectively expands the working set of the database cache and reduces disk I/O to dramatically speed up database operation. Oracle9i Cache Fusion directly ships data blocks from one node's cache to another node's cache in read/read, read/write, and write/write contention situations. This builds on the previous Oracle8i Cache Fusion implementation that handled read/write contention. Because the full Cache Fusion implementation in Oracle9i eliminates the latencies associated with disk based cache coordination, applications can now scale effectively without having to be cluster aware. This means that for the first time a cluster can be treated as a truly scalable single system. OPTIMIZE FEATURES CRITICAL FOR EBUSINESS Specific performance improvements in Oracle9i are focused on improving performance in areas critical for eBusiness solutions. Support for native compilation and improved optimization of PL/SQL improves the performance of many of today's business applications, often significantly. The addition of memory and CPU costs to the cost based optimizer results in better optimization plans, less resource usage, and faster overall performance. Latch contention in several areas has been eliminated or reduced and improves performance on large systems. General I/O improvements, including self tuning direct I/O, prefetching and skip/scan row source operations on indexes also improve performance in Data Warehouse and OLTP environments. By providing VI support, CPU utilization for network communication is reduced by more than 60% on servers and clients in Oracle9i . Virtual Interface (VI) is an emerging communication protocol for clustered server environments. Unlike TCP/IP, VI is a "thin" protocol specially designed for cluster environment, it places most of the messaging burden upon high-speed network hardware and frees the CPU for more important tasks. DEVELOPMENT PLATFORM - CREATE THE MOST COMPLETE PLATFORM FOR DEVELOPING EBUSINESS APPLICATIONS Oracle9i continues to offer the best development platform for eBusiness and traditional application development. Key focus areas include: o Enterprise Java Engine o XDB and XDK o SQL and PL/SQL improvements. Oracle for E-Business Managers ENTERPRISE JAVA ENGINE Oracle9i JVM (previously JServer) extends its support for Java 2 Enterprise Edition APIs and containers through=20 o A robust base architecture (session-based, optimized process and memory management,=20 Unicode support) o A comprehensive set of infrastructure services
(JNDI, JTA, Java 2 Security, JMS,
RMI/IIOP, Persistence, etc) o A Servlet 2.2 compliant Oracle Servlet Engine, a JavaServer Pages 1.1 compliant OracleJSP Engine), for assembling Web components o A comprehensive CORBA and EJB architecture including support for Entity EJB,=20 XML deployment descriptors and a persistence service interface for CMP-EJB, for=20 e-business process's and components development o A comprehensive set of JDBC 2.0 drivers ( including an OCI client driver, 100% Java thin driver, A server-side driver and a client-side "Ultra thin" proxy driver) , an ANSI ISO compliant=20 SQLJ translator and, optimized Java Stored procedures support, for data access and management o A native Java bytecode Accelerator and Memory profiler, for deployment=20 performance The Oracle8i JVM which is embedded within both Oracle9i and=20 Oracle iAS, allows reliable, flexible, scalable and secure e-Business applications deployment. XDB AND XDK Oracle9i features a number of enhanced database operations to store XML in the databases via SQL and render traditional database data as XML. These are key areas of functionality required to support the focus areas of B2B and B2C eBusiness, Packaged Applications, and Internet Content Management. The two main areas of XML support in=20 Oracle9i are: o Built in XML Developer Kits (XDKs) o Native XML Database Support (XDB) With the Java XML Developer Kit (XDK) pre-loaded, and the C XDK linked, into Oracle9i, developers are able to easily access World Wide Web Consortium (W3C)-based functionality that generate, manipulate, render and store XML-formatted data in Oracle9i. Also available in PL/SQL and C++, the XDKs offer XML/XSLT parsers, XML Schema processors, XML Class Generators, XML Transviewer Beans, and the XSQL Servlet, providing basic building block features that allow developers to quickly XML-enable their applications. In addition, for developers who have requirements to store and retrieve large amounts of complex XML through their content management applications, XML database support
(XDB) in Oracle9i provides native XML storage
capabilities to optimize performance. To achieve this, XDB stores XML natively by introducing XMLType, a new object datatype, and features extremely fast, "navigational" access and search for XML documents. Other XDB features include JNDI support as the standard navigational access API, standard APIs for manipulating content, and content management services such as WebDAV to support authoring and versioning on top of XDB. SQL AND PL/SQL IMPROVEMENTS SQL and PL/SQL have continued to be improved in Oracle9i to meet modern development requirements. In addition to native compilation, overall PL/SQL compilation has also been improved. Multi-language server side debugging has also been added, allowing IDE's to debug both Java and PL/SQL within the same framework. To increase the usefulness of Objects, inheritance, type evolution and dynamic method dispatch are all supported in Oracle9i - greatly reducing the maintenance cost of using objects in application development. New ANSI requirements are also supported, including support for the CASE statement, ANSI compliant joins, and reserved name versioning. To aid migration to Oracle9i from non-Oracle databases, scrolling cursor support has been added. Some other improvements to PL/SQL include: o Integrated front-end for SQL compilation - this means PL/SQL immediately supports all SQL syntax changes (in SQL embedded in PL/SQL)..Oracle for E-Business Managers o SQL parallel query mechanism has been extended to stored procedures written in 3GL languages (PL/SQL, Java, as well as external routines). Stored procedures can=20 now pipeline (incrementally return) data to the calling SQL statement. o Full support for ANSI style CASE statements and expressions o Better support for compute intensive applications through native compilation support o The SQL and PL/SQL runtime engines have been more tightly integrated to improve performance. o Also, the overhead of calling PL/SQL procedures from SQL has been reduced. MAKE THE DATABASE SELF MANAGING IN CERTAIN KEY AREAS Oracle9i databases are capable of managing their own undo (Rollback) segments - no longer will administrators need to carefully plan and tune the number and sizes of rollback segments or bother about how to strategically assign transactions to a particular rollback segment. Oracle9i also allows 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 Oracle9i. Traditionally administrators have needed to shutdown the instance in order to grow or shrink System Global Area (SGA) components. Oracle9i introduces a dynamic memory management feature which allows for re-sizing of the buffer cache and shared pool dynamically. It also provides administrators with advisories to help them size the SGA for optimal database performance. Furthermore, Oracle9i provides for transparent management of working memory for SQL execution by self tuning the initialization runtime parameters controlling allocation of private memory. This feature helps low end users to reduce the time and effort required to tune memory parameters for their Data Warehouse and Reporting applications, while high end users are able to avoid memory tuning for individual work loads. STREAMLINE AND IMPROVE THE OPERATIONAL MANAGEMENT OF AN ORACLE9I DATABASE Other traditional management areas of the database are also improved. With the introduction of a persistent INIT.ORA feature in Oracle9i, parameter changes persist across multiple shutdowns. This feature also allows the administrator to startup the database from remote machines without a local copy of INIT.ORA. This is of immense help in database performance tuning as parameter changes made by performance management tools
(Oracle Enterprise Manager) and internal self-tuning
now persist across shutdowns. Oracle9i also introduces the concept of "Oracle Managed Files" which simplifies database administration by eliminating the need for administrators to directly manage the files comprising an Oracle database. Oracle9i now internally uses standard file system interfaces to create and delete files as needed. While administrators still need to be involved in space planning and administration, this feature automates the routine task of creation and deletion of database files. With the introduction of default temporary tablespace, the SYSTEM tablespace is no longer used as the default storage location for temporary data. Oracle9i also allows for better control over database downtime by enabling administrators to specify the mean time to recover (MTTR) from system failures in number of seconds. This feature coupled with more dynamic initialization parameters help administrators further improve database availability. Oracle9i also introduces a new capability called resumable statements, which allows an administrator to temporarily suspend a large operation, such as a batch update or data load. For example, such operations can be suspended if they start to encounter out of space errors, allowing the administrator to fix the problem, and then resume the operation from the point of interruption - all without disrupting normal database operation. Oracle9i also supports databases created with multiple block sizes, and allows administrators to configure corresponding 'sub caches' within the buffer cache for each alternative block size. This capability allows administrators to locate objects in tablespaces of appropriate block size in order to minimize I/O performance, and also allows tablespaces to be transported between different databases, for example, from an OLTP environment to a Data Warehousing environment. Execution plan history is also maintained in Oracle9i, allow administrators to investigate reported performance problems without needing to re-execute the offending queries. To ease backup and recovery operations, Recovery Manager in Oracle9i provides for one time backup configuration,automatic management of backups and archived logs based on a user specified recovery window, restartable backups and restores, and test restore/recovery. Recovery Manager implements a recovery window, a new policy to control when backups expire. This allows administrators to establish a period of time during which it will be possible to discover logical errors and fix the affected objects by doing a database or tablespace point-in-time recovery. Recovery Manager will also automatically expire backups that are no longer required to restore the database to a point-in-time during the recovery window. These features are designed to reduce the time and effort spent by administrators in performing routine backup activities tasks by providing for automation for most commonly performed tasks. The new controlfile autobackup feature also allows for restoring/recovering a database even when a Recovery Manager repository is not available. Recovery Manger in Oracle9i also features enhanced reporting, a more user friendly interface and the ability to specify a highly flexible backup configuration to suit varied requirements depending on the nature of databases and business needs. CLOSE INTEGRATION WITH WINDOWS 2000 Oracle9i supports better integration with Microsoft Transaction Services, Microsoft Message Queuing and Internet Information Services. The PKI infrastructure and single signon capabilities in Oracle9i have also been well integrated with Windows 2000, Active Directory and Microsoft Certificate Store. In Oracle9i, IIS web services allows seamless high performance access to Oracle Java and PL/SQL web components in Microsoft IIS environment. Oracle9i also provides an enhanced solution to allow the Oracle database to participate as a Resource Manager in Microsoft Transaction Server/COM+ Transactions environment. Windows security (PKI, Microsoft Certificate Store) supports Oracle wallets in Registry/Active Directory and allows Oracle products to use Microsoft Certificate Store. For Windows developers, Oracle9i offers an enhanced native OLE DB provider. XML, COM+ Events and Oracle9I extensions have been supported through Oracle Data Objects for Windows (formerly Oracle Objects for OLE). Server side debugging of PL/SQL is supported in Microsoft Script Debugger environment, and further application wizards have been added. Server side Java callouts to COM Automation Servers are also supported. INTERNET CONTENT MANAGEMENT =20 CONSOLIDATE ALL INTERNET CONTENT IN ORACLE DATABASES Oracle9i allows customers to store, manage and aggregate all types of multimedia content into a single database. Oracle9i significantly enhances the capabilities of the Oracle8i database to serve as a platform to create, manage and deliver Internet content. Key focus areas are: o Storing and managing all types of Content - files, multimedia, e-mail ... o Content Syndication for Internet applications o Searching and indexing all types of content efficiently o Organization of content for collaborative projects o Location-enabled, mobile-ready content Oracle9i includes the version 1.2 release of the Internet File System (iFS), a revolutionary extension to the Oracle8I database. Oracle iFS provides the best of both the relational database and file system worlds. Organizations can install. Oracle for E-Business Managers Oracle iFS and get, out of the box, a file system that has built-in capabilities not available in other file systems. Oracle iFS can store all ontent, from e-mail to web content to word processing documents, in the same folders. End users can access all this content through Windows, the web, FTP, and an e-mail client without any special client installation. Oracle iFS also gives the end user content management features-versioning, content-based searching using interMedia Text, multiple foldering of files, extensible file attributes, ACL-based security, and check in/check out-to better manage the process of creating and publishing file-based content. And, of course, all of this functionality has the ease of the file systems end users already know how to use. With Oracle9i, iFS adds more content management features, such as WebDAV, an emerging standard for Internet collaboration. Oracle iFS will also be surfacing into the file system interMedia's capabilities to index, search, and manipulate graphics, audio, and video. LOCATION-ENABLED, MOBILE-READY CONTENT For eBusiness and mobile applications Oracle9i and Oracle Spatial offer the ability to search, index and deliver data based on the location attributes of the content or the proximity. Support for mobile devices, protocols (WAP) and. Oracle for E-Business Managers formats (such as WBMP) and delivery through Oracle iAS Wireless (formerly Portal-to-Go), make Oracle9i a complete platform for the delivery of content for mobile applications. Content stored in Oracle9i can now be associated with related location criteria and services. Interactive Voice Response (IVR) formats used in mobile applications are now supported in interMedia. New support for online mapping, yellow pages, driving directions, traffic, and geocoding services allow online content to be merged with database content. PROVIDING A STANDARD INFRASTRUCTURE TO CREATE STOREFRONTS, EXCHANGES AND PORTALS Oracle9i includes a set of pre-developed, pre-tested and pre-integrated business service objects, developed in Java and compliant with J2EE, that provide faster time to market for customers to build and integrate web based storefronts, exchanges and hosted applications. The eBusiness service objects seamlessly blends open Internet technologies and standards with reliable, scaleable Oracle technologies and products. The eBusiness service objects allow developers to rapidly build complex multi-tiered Internet applications based on open standards, such as HTML, XML, JavaScript, Java Servlets, Java Beans, and Java Server Pages. SCALABILITY, PERFORMANCE, AND MANAGABILITY Performance, scalability, and manageability are basic requirements for business-intelligence applications. As in previous database releases, Oracle9i offers considerable new enhancements in each of these areas. Oracle9i's partitioning capabilities have been expanded to support list partitioning, and base partitioning capabilities have been extended to cover all data types available in Oracle8i, including index organized tables, objects and nested tables. This allows organizations to effectively store, manage and search very large amounts of any type of information. Oracle9i's self-tuning memory not only simplifies the tuning of business-intelligence applications and ensure equitable distribution of memory among concurrent process's, but more importantly also improves query performance. Oracle9i also continues to improve query performance in other areas, with innovative new technologies such as considerable enhancements to materialized view's, and the introduction of bitmap join indexes. COMPLETE BUSINESS INTELLIGENCE PLATFORM: INTEGRATED ANALYSIS AND PERSONALIZATION CAPABILITIES However, Oracle9i for business intelligence goes far beyond the primary requirements of performance, scalability, and manageability. Oracle9i is designed to be a full data warehouse platform, leveraging the Oracle database as the scalable data engine for all operations on data warehousing data. Oracle9i provides ground-breaking new functionality in three areas: Online Analytical Processing (OLAP), Extraction, Transformation and Loading (ETL), and Data-Mining. Oracle9i introduces OLAP Server, a scalable, high-performance OLAP calculation engine with fully integrated management and administration. Leveraging Oracle Express Server technology and Oracle8i's analytic SQL capabilities, OLAP Server provides a robust platform for delivering analytic applications. To increase the efficiency and reduce time taken to load and refresh critical data warehouses, Oracle9i provides support for external tables, allowing data from external systems to be quickly loaded into the database. In addition, a new data capture facility will allow incremental changes from target sources to be captured and applied to the data warehouse automatically. Other data load capabilities provided to increase data load scalability and reduce complexity include multi table insert and upsert semantics. This new ETL functionality will also be leveraged by Oracle Warehouse Builder. Oracle9i also includes new data mining capabilities. Based on Oracle's Darwin product, Oracle9i provides personalizition capabilities, which will enable customers to implement accurate, real-time recommendations and personalizition capabilities into their online operations. Oracle9i is the next step in tighter integration of data-mining and the relational database, and includes in-database scoring along with the ability to manage data-mining operations. __________________________________________________ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one Place. http://shopping.yahoo.com/ --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 Author: Nobody Win INET: application_erp_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). ------------------------------
From: "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Mon, 06 Nov 2000 09:33:42 -0400
Subject: RE: Slooow Select after Upgrade to 8.1.6 from 8.0.4
Can you build local indexes instead of a global index?
In 8i the cost-based optimizer might be able to rule out partitions =
before
it starts scanning the local indexes.
It has to be a prefixed index though, i.e. your index has to start with =
the
partition key.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst=E8mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique=20 Maritimes Region, DFO | R=E9gion des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20
-----Original Message----- From: Tom Pall [SMTP:tom_at_cdproc.com] Sent: Friday, November 03, 2000 7:05 PM To: Multiple recipients of list ORACLE-L Subject: Re: Slooow Select after Upgrade to 8.1.6 from 8.0.4 How fortunate you've moved to 8i. Now you can avail yourself of all those lovely execution plan stability features available in 8i. Part of the rationale for the features is that 3rd party software, like Crystal Reports, does notReceived on Mon Nov 06 2000 - 07:30:53 CST
 |
 |