|
|
|
|
|
|
|
|
|
|
| Re: difference between oracle 8i and 9i [message #33780 is a reply to message #33077] |
Mon, 01 November 2004 20:13   |
K.Sivakumar
Messages: 1
Registered: November 2004
|
Junior Member |
|
|
Hi,
First point i would like to inform u people, don't talk interms of difference...talk interms of added features in 9i compare to 8i.
Anywya coming to point there r many feature sadded in 9i. ie according to DBA(Database administrator) side around 250 differences r there. Then according to developer side 27 diff r there. I can't write everything but i can say some important diff. ie as follows...
As per DBA side:
1.)SPfile concept. ie nothing but dynamic SGA, without disturbing the running instance in database init.ora some of the parameters can be changed.( do remember only some of the paramaters, that u check).
2.)In 8i people use to have only rollback segment which is giving ultimate porblem like running huge transactions by single user. So if Other people try to run any other even little amt of transactions they may get error. then the solution for that u have to go for mannul optimizing concept ie. compress the rollback segment. Instead of that in 9i ORACLE introduced Undo segment concept, this is having the features for auotmatic compressions for each segment ie. if the one undo segment reaches to its optimal size it goes for compression mode by automatically.
3.)Table partioning.
4.)Query Rewrite.
5.)Parallel Query Option.
6.)Tranportable Tablespaces, ie one database to another database we can transport the tablespace.
7.)Then very important is Oracle 9i supports multiple blocksize segment. ie the block can be increaing in the following way 2 power n ie its usually goes like 2k,4k,8k,16k....in 8i what ever we r creating the datablock size should be same for all the tablespaces.
8.)When we configuring for failover server from 9i we can make all of the copies of arichived log files to apply directly ie not only copying it'll apply also...ao that the downtime time will be very less. with in some seconds the other system will come up.
9.)On 8i there was only Snapshot concept but from 9i they introduced Materialized Veiws.
10.)Row chaning and Row migrations soultions.
Acording to developer side:
1.)Flashback Query
2.)Instead of decode also they introduced case.
3.)also they increased column of the table upto 270.
Then am sorry currenlt i don't remember...if any further clarification without any hestitate u can ask me. An dalso pls don't forget to ackonwledge this mail.
Ragards
Shiva
|
|
|
|
|
|
| plz clear [message #33984 is a reply to message #33780] |
Mon, 15 November 2004 22:53 |
pramod gupta
Messages: 1
Registered: November 2004
|
Junior Member |
|
|
hi sir i read the diff. which r given by u.
I m sorry to say that i m not able to understand these
differences. Will u plz erase my doubts realted with oracle 8i & 9i.
I will wait for ur reply.
bye
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
