Re: Reason for upgrading from 8.1.7 to 9iR2

Also, at 8.1.7.  Researching whether to upgrade to 9.2.0.5 or to 10.1? 
Anyone running 10g in production?  Any issues, reasons not to upgrade to
10g?
Thanks,
Gene
>>> mhthomas@xxxxxxxxx 5/5/2004 3:29:33 PM >>>

I've seen 9iR2 upgrades driven by a globalization
thing rather than performance. 

E.g. The UTF-8 support in 9iR2 is much nicer than 8i.
> explain the reasons for moving from 8.1.7 to 9iR2

E.g. in DBA_TAB_COLUMNS the CHAR_USED may be (B)YTES
or (C)HAR to differentiate multibyte characters:

--
DEFINE _O_VERSION      = "Oracle9i Enterprise Edition
Release 9.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP and
Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production" (CHAR)
DEFINE _O_RELEASE      = "902000400" (CHAR)
--
create table foo2 
( col_char_size VARCHAR2 ( 3 CHAR ),
  col_byte_size VARCHAR2 ( 3 BYTE ));

SQL> select char_length, data_length, char_used
  1  from dba_tab_columns
  2* where table_name = 'FOO2'
SQL> /

CHAR_LENGTH DATA_LENGTH C
----------- ----------- -
          3           9 C
          3           3 B

In 8i there were no CHAR semantics which caused
confusion on multibyte charactersets.

Regards,

Mike Thomas



    
        
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: