answersLogoWhite

0

Oracle 8i, Features * PL/SQL Server Pages (PSP's) * DBA Studio Introduced * Statspack * New SQL Functions (rank, moving average) * ALTER FREELISTS command (previously done by DROP/CREATE TABLE) * Checksums always on for SYSTEM tablespace allowing many possible corruptions to be fixed before writing to disk * XML Parser for Java * New PLSQL encrypt/decrypt package introduced * User and Schemas separated * Numerous Performance Enhancements Oracle 9i Features * Scrolling cursor support. Oracle9i 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. * On-line table and index reorganization. * VI (Virtual Interface) protocol support, an alternative to TCP/IP, available for use with Oracle Net (SQL*Net). VI provides fast communications between components in a cluster. * Build in XML Developers Kit (XDK). New data types for XML (XMLType), URI's, etc. XML integrated with AQ. * Cost Based Optimizer now also consider memory and CPU, not only disk access cost as before. * PL/SQL 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 (eXtract, transformation, load) Operations - with external tables and pipelining. * OLAP - Express functionality included in the DB. * Data Mining - Oracle Darwin's features included in the DB.

User Avatar

Wiki User

∙ 17y ago
User Avatar

What else can I help you with?

Related Questions

What is -1-9?

19 o'clock is is the UK version of 7.pm


What is latest version of jdk?

jdk 8 is the latest version that have released...but jdk 9 and 10 is under researching..


How do you get 8 and 9 island in fire red version?

through Nintendo event


How old is Pudding in Tokyo Mew Mew?

In the English Version She is 11 or in the Japanese version she is the 8 or 9 and i find this info on wiki!


How do you access island 8 and 9 in Pokemon FireRed version?

You need to use a gameshark. :/


What is the longest scripture verse in the King James version of the Bible?

Estaer 8:9


What versions of Internet Explorer are compatible with Windows XP?

Except Internet Explorer 9, Windows XP support All other version of IE from version 1 to version 8.Internet Explorer 9 can run on the Vista and Windows 7.Internet Explorer 9 : http://www.downloadatoz.com/download/108962,internet-explorer-9.html


How do you get to 8 and 9 island in fire red version?

You have to be very good at the game.you cant there is no island 8 and 9 it ends in island 7people mistake those islands for 8 and 9 but it is actually the islands where you get ho ho and lugia but you need the tickes which can only be obtainable now by cheating


What is Meaning of 9 in oracle 9i?

it implements 9 rules of E.F. Codd therefor 9i where i stands for internet


How do you get Deoxysis in Pokemon LeafGreen version?

Go to 8 or 9 island. It is unlocked by a special event that doesn't happen anymore.


What is the improper fraction for 4 9th's?

4/9 is a proper fraction and there is not an improper version.4/9 is a proper fraction and there is not an improper version.4/9 is a proper fraction and there is not an improper version.4/9 is a proper fraction and there is not an improper version.


what is the question 4 9x8?

72 9+9+9+9+9+9+9+9=72 or 8+8+8+8+8+8+8+8+8=72