oracle10g versus oracle9i
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: oracle10g versus oracle9i

  1. #1
    Join Date
    Sep 2004
    Posts
    1

    oracle10g versus oracle9i

    Hello!

    Is there any reason i should no use oracle10g in production? Some say its too fresh?

    Egon

  2. #2
    Join Date
    Oct 2002
    Posts
    807

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253

    Re: oracle10g versus oracle9i

    Originally posted by egonr
    Is there any reason i should no use oracle10g in production? Some say its too fresh?
    There are also people who say 9i is too fresh as well ... do as you should always do with new software versions -- deploy in a test environment and test-test-test.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    10g is too fresh, I put one in production last month and need to use 9iR2 optimizer not mentioning other 10 bugs or so I found

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by pando
    10g is too fresh, I put one in production last month and need to use 9iR2 optimizer not mentioning other 10 bugs or so I found
    Working for me quite nicely -- haven't hit any bugs at all yet (DW environment, that is).
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    have you tried rman backup and recovery, there are at least two bugs

    optimizer bug, if you use connect by and inline view with distinct core dumps, need to use 9is CBO

    renaming redo log member corrupts your database (yes recreate from zero)

    TKPROFs explain option causes ORA-00922: missing or invalid option

    Querying v$sql_plna core dumps randomly

    etc etc and goes on

  7. #7
    Join Date
    Apr 2004
    Posts
    18
    Heck, we've found a few 9.2.0.4 bugs in the last month!

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    >> have you tried rman backup and recovery, there are at least two bugs

    Our idiot production DBA's won't use RMAN -- "corporate" policy. Yeah, I know.

    >> optimizer bug, if you use connect by and inline view with distinct core dumps, need to use 9is CBO

    No "connect by" used.

    >> renaming redo log member corrupts your database (yes recreate from zero)

    nope, not done it


    Boy, sucks to be you!



    Of course, being a DWh environment we're using a v. different set of features to OLTP.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width