Oracle - what are the extra features available in Oracle 9i as compared to oracle 8i

GeekInterview.com > Interview Questions > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 35 of 81

what are the extra features available in Oracle 9i as compared to oracle 8i

Total Answers and Comments: 7

Last Update: February 13, 2007 Asked by: Divya

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 22, 2006 09:54:19

opbang

Member Since: March 2006 Contribution: 46

RE: what are the extra features available in Oracle 9i...

In comparison with Oracle 8i 9i is have lot many new features. important is

Dynamic database parameters

Data Guard

Log Miner

Enhanced RMAN

Enhanced for Data Warehousing

Real Application Cluster

Zero Data Loss Log Transport

Granular Control over resources

Three Tier Security

Enhanced Java Support

Enhanced Data management

and many more

Oracle9i Database new features are in the categories listed below.

Availability

Scalability

Performance

Security

Manageability

Development Platform for E-Business Applications

Windows Integration

Internet Content Management

E-Business Integration

Packaged Applications

Business Intelligence

Is this answer useful? Yes | No

September 27, 2006 03:46:32

Divya

RE: what are the extra features available in Oracle 9i...

Thanks OM Prakash for ur kind help...

Is this answer useful? Yes | No

October 05, 2006 09:31:01

sree

RE: what are the extra features available in Oracle 9i...

date functions.

generic functions

Is this answer useful? Yes | No

October 16, 2006 08:00:58

manoj k jena

RE: what are the extra features available in Oracle 9i...

plz send me the answer.

Is this answer useful? Yes | No

October 27, 2006 02:01:24

PAWANAHUJAHUJA

Member Since: October 2006 Contribution: 6

RE: what are the extra features available in Oracle 9i...

the extra features in 9i as

support ANSI join sysntax merge statement debugging java stored procedure

case statement.

Regards

Pawan Ahuja.

Is this answer useful? Yes | No

February 13, 2007 12:59:47

geetha24

Member Since: March 2006 Contribution: 27

RE: what are the extra features available in Oracle 9i...

New Features in 9i are1. Multiple table inserts using a single statement2. Multilevel collections. ie. a nested table can be used in a nested table3. Case Expression - it's a extended form of decode4. Merge Statement5. Online index rebuild6. Online table rebuild7. Bitmap Join Index8. Renaming of Columns and constraints9. Primary Key Unique key and Referential keys can be created on a View10. Named index can be created on Key Columns. Ie. we can create a index on primary key column 11. Optimizer hint First_rows is now extented with First_rows(n)12. Pl/sql tables are now named as Associative array and now can be indexed by string.13. Flashback Query14. For update statement is provided with a new option Wait.15. Index Monitoring16. Index Skip Scanning.Hope this helps

Is this answer useful? Yes | No

February 13, 2007 13:08:20

geetha24

Member Since: March 2006 Contribution: 27

RE: what are the extra features available in Oracle 9i...

New Features in 9i are 1.Multiple table inserts using a single statement2. Multilevel collections. ie. a nested table can be used in a nested table3. Case Expression - it's a extended form of decode4. Merge Statement5. Online index rebuild6. Online table rebuild7. Bitmap Join Index8. Renaming of Columns and constraints9. Primary Key Unique key and Referential keys can be created on a View10. Named index can be created on Key Columns. Ie. we can create a index on primary key column 11. Optimizer hint First_rows is now extented with First_rows(n)12. Pl/sql tables are now named as Associative array and now can be indexed by string.13. Flashback Query14. For update statement is provided with a new option Wait.15. Index Monitoring16. Index Skip Scanning.Hope this helps

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank