Oracle 8I For Windows 2003
Tom, In my report. I am seeing the contention for lib. In lib cache latch statistics, the SQL AREA GETHITRATIO is only 0. Oracle 9i Oracle FAQOracle 9i is a version of the Oracle Database. The i stands for Internet to indicate that 9i is Internet ready. Also see Oracle 1. Oracle 1. 1g. History and Support StatuseditTwo releases are available. Oracle 8I For Windows 2003' title='Oracle 8I For Windows 2003' />Oracle 9i Release 1 9. Status Desupported. Last patch set 9. End of Error Correction Support 3. Hi Tom, Is there anyway that I can just use SQL to do string concatenation on a VARCHAR2 field much the same way that a SUM function is used on a NUMBER field. Dec 2. 00. 3End of Extended Assistance Support 3. Jun 2. 00. 6End of Extended Maintenance Support not offered. Oracle 9i Release 2 9. Status Desupported, however, Oracle has waived their usual fees for extended support until July 2. For more info, see http www. Last patch set 9. Premier Support Ends 3. Jul 2. 00. 7Extended Support Ends 3. Jul 2. 01. 0Features introducededitThe following new features were introduced with Oracle 9i. Oracle 9i Release 2 9. May 2. 00. 2editLocally Managed SYSTEM tablespaces. Oracle Streams new data sharingreplication feature can potentially replace Oracle Advance Replication and Standby DatabasesXML DB Oracle is now a standards compliant XML databaseData segment compression compress keys in tables only when loading dataCluster file system for Windows and Linux raw devices are no longer requiredCreate logical standby databases with Data Guard. Java JDK 1. 3 used inside the database JVM Oracle Data Guard Enhancements SQL Apply mode logical copy of primary database, automatic failover. Oracle Corporation. Burleson Consulting is an altruistic company and we believe in sharing our Oracle extensive knowledge through publishing Oracle books and Oracle articles, video. Security Improvements Default Install Accounts locked, VPD on synonyms, AES, Migrate Users to Directory. Oracle 9i Release 1 9. June 2. 00. 1editTraditional Rollback Segments RBS are still available, but can be replaced with automated System Managed Undo SMU. Using SMU, Oracle will create its own Rollback Segments and size them automatically without any DBA involvement. Flashback query dbmsflashback. Oracle 8I For Windows 2003' title='Oracle 8I For Windows 2003' />This feature will allow users to correct wrongly committed transactions without contacting the DBA to do a database restore. Use Oracle Ultra Search for searching databases, file systems, etc. The Ultra. Search crawler fetch data and hand it to Oracle Text to be indexed. Oracle Nameserver is still available, but deprecate in favour of LDAP Naming using the Oracle Internet Directory Server. A nameserver proxy is provided for backwards compatibility as pre 8i client cannot resolve names from an LDAP server. Oracle Parallel Servers OPS scalability was improved now called Real Application Clusters RAC. D0%A0%D1%83%D0%BA%D0%BE%D0%B2%D0%BE%D0%B4%D1%81%D1%82%D0%B2%D0%BE+%D0%BF%D0%BE+%D1%83%D1%81%D1%82%D0%B0%D0%BD%D0%BE%D0%B2%D0%BA%D0%B5+%D0%B4%D0%B5%D0%BC%D0%BE%D0%B2%D0%B5%D1%80%D1%81%D0%B8%D0%B8+%D0%B8%D0%BD%D0%B8%D1%81%D1%82+%D0%B1%D0%B0%D0%BD%D0%BA-%D0%9A%D0%BB%D0%B8%D0%B5%D0%BD%D1%82b/13590_html_m4945d0ec.png' alt='Oracle 8I For Windows 2003' title='Oracle 8I For Windows 2003' />Full Cache Fusion implemented. Any application can scale in a database cluster. Applications doesnt need to be cluster aware anymore. The Oracle Standby DB feature renamed to Oracle Data Guard. New Logical Standby databases replay SQL on standby site allowing the database to be used for normal read write operations. The Data Guard Broker allows single step fail over when disaster strikes. Scrolling cursor support. Oracle. 9i allows fetching backwards in a result set. Dynamic Memory Management Buffer Pools and shared pool can be resized on the fly. This eliminates the need to restart the database each time parameter changes were made. Dream Avatar Creator Game here. On line table and index reorganization. VI Virtual Interface protocol support, an alternative to TCPIP, available for use with Oracle Net SQLNet. VI provides fast communications between components in a cluster. Build in XML Developers Kit XDK. New data types for XML XMLType, URIs, etc. XML integrated with AQ. University Learning Disability Program. Cost Based Optimizer now also consider memory and CPU, not only disk access cost as before. PLSQL programs can be natively compiled to binaries. Deep data protection fine grained security and auditing. Put security on DB level. SQL access do not mean unrestricted access. Resumable backups and statements suspend statement instead of rolling back immediately. List partitioning partitioning on a list of values. ETL e. Xtract, transformation, load Operations with external tables and pipelining. Oracle OLAP Express functionality included in the DB. Data Mining Oracle Darwins features included in the DB. External linksedit.