Basics - Difference between oracle8i and oracle9i

GeekInterview.com > Interview Questions > Oracle > Basics

Go To First | Previous Question | Next Question

Basics | Question 10 of 49

Difference between oracle8i and oracle9i

Total Answers and Comments: 23

Last Update: August 02, 2007 Asked by: Rahul

Sponsored Links

Best Rated Answer

—

Submitted by: aniruth

hi,

listed below are some of the features of 9i:

1) u have automatic undo management.

2)u have automatic segment space management

3)u got these locally managed tablespaces which is better than the dictionary managed tabespaces as u can avoid fragmentation with locally managed tablespaces.

4)u have a new dbms_metadata package to extract object definitions from database.

5)multi table insert is possible with 9i

6)importanly u have this spfile in 9i.

7) also u have dynamic memory mangement facility with 9i.

8) u have tuning advisories with 9i.

9) u have multi block size parameter with 9i and many more features like these..

please go through the oracle 9i new features from oracle to have a complete knowledge of 9i..

thanks..

hari

Above answer was rated as good by the following members:
naga_272

Sorting Options

Page 1 of 3

« First

Last »

October 21, 2005 01:44:23

christopher

RE: Difference between oracle8i and oracle9i

1.what is the difference between oracle 8i and oracle 9i

2.what is the relation of dbms & rdbms

3 PLEAE SEND TO ME SOME IMPORTANT QUARIES IN SQL & PL/SOL THANK YOU

Is this answer useful? Yes | No

0 2

Overall Rating: -2

October 26, 2005 05:54:20

KiranKumar Jinka

RE: Difference between oracle8i and oracle9i

The biggest difference between Oracle8i and Oracle9i is that Oracle9i lets You resize the SGA memory areas dynamically i.e. the Database Buffer Cache DB_CACHE_SIZE or the SHARED_POOL_SIZE etc. can be resized when the database is up and running. The same is not possible with Oracle8i. You can get more information from OTN

Is this answer useful? Yes | No

0 1

Overall Rating: -1

October 27, 2005 14:06:27

Yadav Anand V

RE: Difference between oracle8i and oracle9i

Oacle 9i is an enhanced version of the Oracle 8i.Oracle 8i does not provided tomestamping facility which is provided in Oracle 9i.

Is this answer useful? Yes | No

November 09, 2005 13:52:39

rishu

RE: Difference between oracle8i and oracle9i

You can drop a column in oracle 9i using alter table command where as this is not available in oracle 8i

Is this answer useful? Yes | No

November 10, 2005 07:27:17

mvsk78

Member Since: November 2005 Contribution: 1

RE: Difference between oracle8i and oracle9i

database performanceease of managementscalabilitysecurityavailability Windows 2000 integration and application areas:Internet content managementecommerce integrationpackaged applicationsBusiness Intelligence native compilation of PL/SQLreduction in latch contention (SGA locks) and I/O improvementsbetter Java performance (better compilation improved garbage collection)distributed database performance enhancements enhanced 3-tier security (integration with LDAP ...)improved hosting security (through use of virtual private databases) fine-grained auditing and single sign-onimproved user security (more password management features etc.)ability to encrypt stored datarow-level access control (Oracle Label Security)

Is this answer useful? Yes | No

0 1

Overall Rating: -1

November 14, 2005 05:27:40

ajay kumar

Re:- what is the Extract Function

christopher Wrote: 1.what is the difference between oracle 8i and oracle 9i
2.what is the relation of dbms & rdbms
3 PLEAE SEND TO ME SOME IMPORTANT QUARIES IN SQL & PL/SOL THANK YOU

Is this answer useful? Yes | No

December 16, 2005 07:54:41

rangarajan

RE: Difference between oracle8i and oracle9i

I can some good enhancement in SQL like Decode function introduction and WITH clause is amazing. Also Cache size enhanced EJB components with respect to Form 9i and oracle 9i synchronization establishment.

Regards

Rangarajan

PL-SMS

Is this answer useful? Yes | No

0 1

Overall Rating: -1

January 24, 2006 18:51:51

aniruth

Member Since: January 2006 Contribution: 1

RE: Difference between oracle8i and oracle9i

listed below are some of the features of 9i:

1) u have automatic undo management.

2)u have automatic segment space management

3)u got these locally managed tablespaces which is better than the dictionary managed tabespaces as u can avoid fragmentation with locally managed tablespaces.

4)u have a new dbms_metadata package to extract object definitions from database.

5)multi table insert is possible with 9i

6)importanly u have this spfile in 9i.

7) also u have dynamic memory mangement facility with 9i.

8) u have tuning advisories with 9i.

9) u have multi block size parameter with 9i and many more features like these..

please go through the oracle 9i new features from oracle to have a complete knowledge of 9i..

thanks..

hari

Is this answer useful? Yes | No

1 0

Overall Rating: +1

February 17, 2006 05:50:45

puneet soni

RE: Difference between oracle8i and oracle9i

Some of the more important new features of oracle 9i over 8i...Oracle Streams (for data movement - can potentially replace Oracle Advance Replication and Standby Databases). XML DB (Oracle is now a standards compliant XML database) Data segment compression (compress keys in tables - only when loading data) Cluster file system for Windows and Linux (raw devices are no longer required). Create logical standby databases with Data Guard Java 1.3 used inside the database

Is this answer useful? Yes | No

April 01, 2006 01:38:37

#10

SHAMBHU KR JHA

RE: Difference between oracle8i and oracle9i

Your answer is wrong. Droping column is also possible in 8i using alter command. Don't Give wrong answer ON THE WEB

Is this answer useful? Yes | No

Page 1 of 3

« First

Last »

Go To Top

User Name		Remember Me?
Password

Question Bank