DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: general oracle 9i

  1. #1
    Join Date
    Oct 2002
    Posts
    391

    general oracle 9i

    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...

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    9i has a load of feature - read the ne feature doc if you want a complete list.

    Also people upgrade because Oracle was going to withdraw support for 8i. (one reason)

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    If you are still on 8i, it may make sense to directly go to 10g. 9i is already in its terminal release and no sooner you upgrade to 9i, you may be looking down the barrel of 10g.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by kris109
    If you are still on 8i, it may make sense to directly go to 10g. 9i is already in its terminal release and no sooner you upgrade to 9i, you may be looking down the barrel of 10g.
    wouldnt do that unless 10g is proven stable, never use the first version release!

  5. #5
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Originally posted by kris109
    If you are still on 8i, it may make sense to directly go to 10g. 9i is already in its terminal release and no sooner you upgrade to 9i, you may be looking down the barrel of 10g.
    Neither the second

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by aarroyob
    Neither the second
    In fact, terminal releases are my favourite.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  7. #7
    Join Date
    Oct 2002
    Posts
    391
    also, oracle 9i has this undo tablespace which we can do away with teh roll back segments?

    this undo feature is to combat the ora-1555 snapshot error?

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by yls177
    also, oracle 9i has this undo tablespace which we can do away with teh roll back segments?

    this undo feature is to combat the ora-1555 snapshot error?
    I don't think so ... I think that UNDO is just more efficient, and easier to manage. The 1555 error is a result of the consistency model that Oracle uses, and doesn't neccessarily go away withUNDO, it's just happens to be easier to configure it to avoid the error.
    David Aldridge,
    "The Oracle Sponge"

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

    Oracle ACE

  9. #9
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Originally posted by yls177
    also, oracle 9i has this undo tablespace which we can do away with teh roll back segments?

    this undo feature is to combat the ora-1555 snapshot error?
    nothing like that.. U can use "undo_retention_ parameter to minimize "ora-1555" error just like U give initial extent=next extent and minextents=20 for conventional rollback segments..

    it's upto U to use the features to avoid "ora-1555"
    -nagarjuna

  10. #10
    Join Date
    Oct 2002
    Posts
    391
    oracle 9i has some auto parameters whereby they can increase on their own, like this workarea_size_policy = AUTO in the area of PGA?

    isnt that useful then? but then on the other hand, the unknown of how much it will be used like maxextents=unlimited?

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