hi... i realised somethings recently... companies are upgrading to oracle 9i because they wanted to keep in touch with the technology. but alas, after upgrading to all these latest, proven technologies.... , they didnt tap on the power of these stuff, example oracle 9i
i hoped that i am right in the below in regards of oracle 9
1) different categories of data block size
2) parameter changes can be changed and effective without database restart
3) better management of rollback segments other than offline/online
4) locally managed tablespace
5) extents overflow issues?
the above points are brougth up during a discussion with an oracle dba...
we were discussing about the upgrading of new technology and yet not harness their power...