We help IT Professionals succeed at work.

Oracle 10g vs Oracle 9i

ee_lcpaa
ee_lcpaa asked
on
2,847 Views
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
Comment
Watch Question

Commented:
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
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
"      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
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Sean StuberDatabase Developer & Administrator
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2012

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.