Oracle 9i features, PL-SQL Programming

Bitmap Join Indexes -

This feature will increase the performance and detains the size and format of your databases in data
Character Semantics and Globalization-This feature enable in prevention of storage problems that are associated with multi-byte characters sets by using character semantics while defining table columns in data.

Data Guard-As this feature is there in every database Oracle9i Data Guard is the new name for in technology advancements ofOracle8i which Standby Database inception of a large number of new advance features.

Export and Import Enhancements in Oracle9i-this is the unique feature that is there in oracle 9I to export and import enhancement through Oracle 9i, See what new functionality has been incorporated into the Export and Import utilities in Oracle9i.

Flashback Query-this feature will allow the adept and rational view of the data at an earlier or any point in time.

High Availability Enhancements in Oracle9i-By advancing the ability it detains downtime for users by adopting the new high availability features of Oracle9i.

Index Organized Table (IOT) Enhancements in Oracle9i-It gives developer a better support for secondary indexes and much improved online maintenance as heap tables.

Apart from those above, other new features are below. They are list of differences that oracle 10g have in contrast to 9i

  1. Major changes to SQL optimizer internals
  2. Oracle Grid computing
  3. AWR and ASH tables incorporated into Oracle Performance Pack and Diagnostic Pack options.
  4. Automated Session History (ASH) materializes the Oracle Wait Interface over time
  5. Data Pump replaces imp utility with impede databases.
  6. Automatic Database Diagnostic Monitor (ADDM) which monitor databases diagnostic.
  7. SQLTuning Advisor(SQL integration)
  8. SQLAccess Advisor(Help from Database)
  9. Rolling database upgrades (using Oracle10g RAC)

In 2005 after the successful of oracle 19G oracles released another variant of oracle 10 G that is Oracle 10G release 2.

This is also having some alluring and unique features than oracle 10G relase1

Posted Date: 3/14/2013 2:17:04 AM | Location : United States







Related Discussions:- Oracle 9i features, Assignment Help, Ask Question on Oracle 9i features, Get Answer, Expert's Help, Oracle 9i features Discussions

Write discussion on Oracle 9i features
Your posts are moderated
Related Questions
set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_d

Initial thought process: Design a script which was simple and user friendly. Integrate procedures/functions to extract data under the hood. I focused on giving the user the opt

UNNEST operator in SQL The inverse operator of GROUP is UNGROUP. SQL has an operator, UNNEST, that can be used for similar purposes, but its method of invocation is somewhat p

Parameter Default Values As the illustration below shows, you can initialize the IN parameters to the default values. In that way, you can pass various numbers of actual par

MECHANISTI S THEORY-HAECKEL (1866) - Haeckel stating that after each catalysm, some new organism suddenly forms as a chance event in one stride from inanimate matter and sub

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut

Seeking a programmer to design a legal document with pre-existing fields that could allow the auto-population of client(s) information (i.e. Name, Account Number, Address etc.) int

Left and Right Joins LEFT OUTER JOIN can be used when you want to retrieve the data from the main table (table1) even if there is no match in other tables (table_2, table_3...

IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

%NOTFOUND The %NOTFOUND is the logical opposite of the %FOUND. The %NOTFOUND yields TRUE when an INSERT, UPDATE, or DELETE statement affected no rows, or the SELECT INTO state