Re: comparsion of 9i vs. 10g

My book Oracle Database 10g New Features is a quick introduction to Oracle Database 10g and it's new features. Other cool things in 10gR2:

ORA_ROWSCN (very cool I think!)
OEM is much improved!
PL/SQL Compile time warnings
Regular Expressions (boouuuyahhhhh)
ASM and (in 10.2) easier ASM management
Recyclebin
Real compression of RMAN backups...

and sooo much more.

Robert

• Alfonso Le�n <aleon68_at_gmail.com> wrote:

> adding to the list
>
> flashback database feature
> flashback drop table with a recycle bin
> Export and Import is made now throught the server
> with dbms_datapump with a
> lot of enhanced options.
> a LOT of advisors in EM
> A basic graphical interfase to RMAN with EM
> A basic graphical interfase to sql*loader with EM
>
> On 7/7/06, Laimutis Nedzinskas
> <Laimutis.Nedzinskas_at_landsbanki.is> wrote:
> >
> > 10g seems to be a good fix. Not so much to say
> for marketing types except
> > of "g"(grid) but for dba's/developers:
> >
> > - a guaranteed undo retention
> > - automated work load repository. It was possible
> to dump database state
> > before but now Oracle is capable of dumping some
> data in what - 15 sec
> > intervals? Full snapshots are collected in 1
> minute intervals.
> > - sql profiling
> >
> > A lot of more thing cleaned up like for example:
> >
> > -dbms_output can now output 32k,
> > -sql with regular expressions (again, we could use
> owa_pattern before but
> > not so easy)
> > -even documentation is better in some areas.
> >
> > What I do not really like: OEM is something I
> refuse to trust for "one
> > button press" database management. But that may be
> is personal, may be
> > someone got OEM running stable.
> >
> >
> > ------------------------------
> > *From:* oracle-l-bounce_at_freelists.org [mailto:
> > oracle-l-bounce_at_freelists.org] *On Behalf Of *Mark
> Brinsmead
> > *Sent:* 7. j�l� 2006 03:02
> > *To:* joe_dba_at_hotmail.com
> > *Cc:* oracle-l_at_freelists.org
> > *Subject:* Re: comparsion of 9i vs. 10g
> >
> > There are, of course, lots of new features in 10g.
> I wouldn't have been
> > released otherwise, would it?
> >
> > Here's one major one that you won't find in the
> new features manual...
> >
> > Oracle 9.2: 12 months to end of "premium"
> support.
> > Oracle 10.2: More than 36 months to end of
> "premium" support.
> >
> > Your managers will probably be able to
> *understand* that one. ;-)
> >
> >
> >
> > On 7/6/06, Joe Smith <joe_dba_at_hotmail.com> wrote:
> > >
> > > I am being asked by management to compare "new
> features" of 9i to
> > > 10g. I
> > > have gone to oracle's website and looked around.
> Does anybody know
> > > where
> > > there is a comparsion chart or speadsheet
> comparing 9i to 10g?
> > >
> > > thanks.
> > >
> > >
> >
> >
> > --
> > Cheers,
> > -- Mark Brinsmead
> > Staff DBA,
> > The Pythian Group
> > http://www.pythian.com/blogs
> >
> >
> > Fyrirvari/Disclaimer
> > http://www.landsbanki.is/disclaimer
> >
>
>
>
> --
> Alfonso Leon
>

Robert G. Freeman
Author:
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Oracle Replication (Rampant Tech Press)
Mastering Oracle8i (Sybex)
Oracle8 to 8i Upgrade Exam Cram (Coriolis <RIP>) Oracle 7.3 to 8 Upgrade Exam Cram (Coriolis <RIP>)

--
http://www.freelists.org/webpage/oracle-l