christopher

• Oct 21st, 2005

 

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

KiranKumar Jinka

• Oct 26th, 2005

 

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

Yadav Anand V

• Oct 27th, 2005

 

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

rishu

• Nov 9th, 2005

 

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

mvsk78

 Profile Answers by mvsk78 

• Nov 10th, 2005

 

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)

ajay kumar

• Nov 14th, 2005

 

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

rangarajan

• Dec 16th, 2005

 

Hi

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

aniruth

 Profile Answers by aniruth 

• Jan 24th, 2006

 

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

puneet soni

• Feb 17th, 2006

 

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

SHAMBHU KR JHA

• Apr 1st, 2006

 

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

rajanen

 Profile Answers by rajanen Questions by rajanen

• Jul 20th, 2006

 

the main difference between 8i and 9i is

In 8i their is no concept called SPFILE.There is only PFILE..PFILE means while set of values assined for SGA parameters.It is fixed ..If u want to change the values then u have to start the server.Then only u ll see the effect of the parameter values.

But in SPFILE it is a concept in oracle 9i..some changes is made in SPFILE ,after starting of server we can see the effect...

sudha

• Aug 11th, 2006

 

Dear sir/madam

I read your answer about difference between oracle9i and oracle8i and appreciate it. Pls give me a detail idea about that and also why there is an i in oracle postfix as in Oracle9i. what does that mean.

Regards

Sudha

dilip kumar

• Oct 7th, 2006

 

thnk u for u r imformation.i am having a small doubt.please tell me

what is mean by SGA memory ?

       

MOHMMAD IQBAL

• Oct 16th, 2006

 

how many tables can be created at a time in oracle 9iand how to insert table in oracle 91

tanveer

• Nov 2nd, 2006

 

Column name of table can be RENAME in Oracle 9i, but not in Oracle 8i..

Left outer join,Full Outer Join in Oracle 9i, but not in Oracle 8i..

Function like Coalasce and ANSI way of doing Join(Using,On Clause) in Oracle 9i, not in Oracle 8i..

TimeStamp feature in Oracle 9i not in Oracle 8i..

anuradha.k

• Dec 25th, 2006

 

  

   The main differences are

        In 9i we have

               1.Merge statemet

                2.case(if then else)

                3.Nullif

                 4.composite index

                 5.Multitable statement

                  6.unconditional all

                  7.Full outerjoin

Anil Hadli

• Mar 28th, 2007

 

We cannot delete the column in Oracle 8i and in Oracle 9i we can delete a single
column. there is no autonoums transaction facility in Oracle 8i we can use autonoums
transaction in Oracle 9i.



Regards,

Anil Hadli.

S.R.Vinotha

• May 30th, 2007

 

·         System Global Area (SGA), which is shared by all server and background processes and holds the following:

o        Database buffer cache

o        Redo log buffer

o        Shared pool

o        Large pool (if configured)

·         Program Global Areas (PGA), which is private to each server and background process; there is one PGA for each process. The PGA holds the following:

o        Stack areas

o        Data areas

abhay kapse

• Jun 11th, 2007

 

1)In database buffer cache in 8i you have parameters like DB_BLOCK_BUFFER,BUFFER_pool_KEEP,BUFFER_POOL_RECYCLE

2)IN oracle9i you have parameter like
DB_CACHE_SIZE,DB_KEEP_CACHE_SIZE,DB_RECYCLE_CACHE_SIZE

3)BY default the extents are locally managed in oracle9i where as in 8i it is dictionary manage.

Ravikant Shrivas

• Jul 11th, 2007

 

Oracle 9i does differenciate NULL AND SPACE while 8i does not.

kodaliprakash

 Profile Answers by kodaliprakash 

• Jul 13th, 2007

 

Oracle 8i also allows column dropping.

Zeeshan

• Aug 2nd, 2007

 

SGA: System Global Area. Its a chuck of memory used on oracle processes.