[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2832
  • Last Modified:

Oracle 10g vs Oracle 9i

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
0
ee_lcpaa
Asked:
ee_lcpaa
  • 2
1 Solution
 
dfu23Commented:
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
0
 
sdstuberCommented:
"      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
0
 
adrian_angCommented:
Longer support lifetime :) - http://www.oracle.com/support/library/data-sheet/oracle-lifetime-support-policy-datasheet.pdf

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.





0
 
sdstuberCommented:
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?
etc.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now