Oracle 10g vs Oracle 9i

Posted on 2007-10-10
Last Modified: 2013-12-19
Hi All,

While considering upgrading the current oracle database 9i, I would like to know the main advantages or any majon improvemnts in Oracel 10g.

Please advise. Thanks
Question by:ee_lcpaa
    LVL 14

    Expert Comment

    In short:
     - ease of administration (many built in views to quickly see overall performance and issues)
     - enhanced RMAN (recovery manager)
     - put in the ANSI SQL92 and SQL99 standard
    LVL 73

    Expert Comment

    "      Instant Client
    "      HTML DB
    "      Recycle Bin
    "      Expression Filters
    "      XQuery
    "      Model clause
    "      More Advisors
    "      Extended Tracing built in
    "      Dbms_output limits extended!!!!!
    "      Regular Expressions (perl extensions not in conflict with POSIX)
    "      Scheduler vs dbms_jobs
    "      Web Gateway
    "      Matrix Math (UTL_NLA)
    "      Conditional Compilation
    "      Collection Operations
    "      Distributed LOBS supported
    "      Numeric types all use machine math
    "      Hierarchical query improvements
    LVL 5

    Accepted Solution

    Longer support lifetime :) -

    Auto memory management - take a look at sga_target in 10g docs.

    I also like DB_UNIQUE_NAME parameter when working with standby databases and Data Guard.

    There are Profiles which you can use to implement a better explain plan for example without need of hints and other modifications(if Oracle optimizer is smart enough to reconsider its final choice)

    some new hints

    and it goes on and on.

    LVL 73

    Expert Comment

    Anything else you want to know about 10g?

    Is there something in particular you were interested in?
    DBA features/Tools?  Developer Features/Tools?
    New Syntax?
    OEM changes?

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now