Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 14739 invoked from network); 7 Jul 2006 03:48:03 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 7 Jul 2006 03:47:56 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BC9273938AD;
 Fri,  7 Jul 2006 04:47:39 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 12644-08; Fri, 7 Jul 2006 04:47:39 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2D9E53938C8;
 Fri,  7 Jul 2006 04:47:39 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 07 Jul 2006 04:46:52 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C1459393560
 for <oracle-l@freelists.org>; Fri,  7 Jul 2006 04:46:51 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 12345-01-5 for <oracle-l@freelists.org>;
 Fri, 7 Jul 2006 04:46:51 -0400 (EDT)
Received: from mx1.landsbanki.is (mx1.landsbanki.is [194.105.245.132])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E0C84393499
 for <oracle-l@freelists.org>; Fri,  7 Jul 2006 04:46:50 -0400 (EDT)
Received: from W03856.li01r1d.lais.net (Not Verified[172.27.100.102]) by mx1.landsbanki.is with MailMarshal (v6,1,4,441)
 id <B44ae1f800000>; Fri, 07 Jul 2006 08:46:56 +0000
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C6A1A1.E6CD6BCA"
Subject: RE: comparsion of 9i vs. 10g
Date: Fri, 7 Jul 2006 08:46:56 -0000
Message-ID: <5A8896FB2AFC5445A7DCFC5903CCA6B02CA2ED@W03856.li01r1d.lais.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: comparsion of 9i vs. 10g
thread-index: AcahcdkEdqWXTa68RISWhuWOSYMD0AALGnQA
From: "Laimutis Nedzinskas" <Laimutis.Nedzinskas@landsbanki.is>
To: <oracle-l@freelists.org>
X-archive-position: 36820
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: Laimutis.Nedzinskas@landsbanki.is
Precedence: normal
Reply-to: Laimutis.Nedzinskas@landsbanki.is
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net
------_=_NextPart_001_01C6A1A1.E6CD6BCA
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

10g seems to be a good fix. Not so much to say for marketing types except=
=20of "g"(grid) but for dba's/developers:
=20
- 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 in=
tervals? Full snapshots are collected in 1 minute intervals.
- sql profiling
=20
A lot of more thing cleaned up like for example:=20
=20
-dbms_output can now output 32k,=20
-sql with regular expressions (again, we could use owa_pattern before but=
=20not so easy) =20
-even documentation is better in some areas.
=20
What I do not really like: OEM is something I refuse to trust for "one bu=
tton press" database management. But that may be is personal, may be some=
one got OEM running stable.
=20
=20
________________________________

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org=
] On Behalf Of Mark Brinsmead
Sent: 7. j=FAl=ED 2006 03:02
To: joe_dba@hotmail.com
Cc: oracle-l@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.=20
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@hotmail.com> wrote:=20

=09I am being asked by management to compare "new features" of 9i to 10g.=
=20 I
=09have gone to oracle's website and looked around.  Does anybody know wh=
ere
=09there is a comparsion chart or speadsheet comparing 9i to 10g?=20
=09
=09thanks.
=09
=09




--=20
Cheers,
-- Mark Brinsmead
=20  Staff DBA,
=20  The Pythian Group
=20  http://www.pythian.com/blogs=20

Fyrirvari/Disclaimer
http://www.landsbanki.is/disclaimer

------_=_NextPart_001_01C6A1A1.E6CD6BCA
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-=
1">
<META content=3D"MSHTML 6.00.2900.2912" name=3DGENERATOR></HEAD>
<BODY>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2>10g seems to be a good fix. Not so much to say f=
or=20
marketing types except of "g"(grid) but for=20
dba's/developers:</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2>- a guaranteed undo retention</FONT></SPAN></DIV=
>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2>- automated work load repository. It was possibl=
e to dump=20
database state before but now Oracle is capable of dumping some data in w=
hat -=20
15 sec intervals? Full snapshots are collected in 1 minute=20
intervals.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2>- sql profiling</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2>A lot of more thing </FONT></SPAN><SPAN=20
class=3D524522008-07072006><FONT face=3DArial color=3D#0000ff size=3D2>cl=
eaned up like=20
for example: </FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2>-dbms_output can now output 32k, </FONT></SPAN><=
/DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2>-sql with regular expressions (again, we could u=
se=20
owa_pattern before but not so easy)&nbsp; </FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2>-even documentation is better in some=20
areas.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2>What I do not really like: OEM is something I re=
fuse to=20
trust for "one button press" database management. But that may be is pers=
onal,=20
may be someone got OEM running stable.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D524522008-07072006><FONT face=3D=
Arial=20
color=3D#0000ff size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> oracle-l-bounce@freelists.org=20
[mailto:oracle-l-bounce@freelists.org] <B>On Behalf Of </B>Mark=20
Brinsmead<BR><B>Sent:</B> 7. j=FAl=ED 2006 03:02<BR><B>To:</B>=20
joe_dba@hotmail.com<BR><B>Cc:</B> oracle-l@freelists.org<BR><B>Subject:</=
B> Re:=20
comparsion of 9i vs. 10g<BR></FONT><BR></DIV>
<DIV></DIV>There are, of course, lots of new features in 10g.&nbsp; I wou=
ldn't=20
have been released otherwise, would it?<BR><BR>Here's one major one that =
you=20
won't find in the new features manual...<BR><BR>Oracle=20
9.2:&nbsp;&nbsp;&nbsp;&nbsp; 12 months to end of "premium" support. <BR>O=
racle=20
10.2:&nbsp;&nbsp; More than 36 months to end of "premium" support.<BR><BR=
>Your=20
managers will probably be able to *understand* that one.&nbsp;=20
;-)<BR><BR><BR><BR>
<DIV><SPAN class=3Dgmail_quote>On 7/6/06, <B class=3Dgmail_sendername>Joe=
=20Smith</B>=20
&lt;<A href=3D"mailto:joe_dba@hotmail.com">joe_dba@hotmail.com</A>&gt;=20
wrote:</SPAN>
<BLOCKQUOTE class=3Dgmail_quote=20
style=3D"PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(2=
04,204,204) 1px solid">I=20
=20 am being asked by management to compare "new features" of 9i to=20
=20 10g.&nbsp;&nbsp;I<BR>have gone to oracle's website and looked=20
=20 around.&nbsp;&nbsp;Does anybody know where<BR>there is a comparsion c=
hart or=20
=20 speadsheet comparing 9i to 10g?=20
<BR><BR>thanks.<BR><BR></BLOCKQUOTE></DIV><BR><BR clear=3Dall><BR>--=20
<BR>Cheers,<BR>-- Mark Brinsmead<BR>&nbsp;&nbsp; Staff DBA,<BR>&nbsp;&nbs=
p; The=20
Pythian Group<BR>&nbsp;&nbsp; <A=20
href=3D"http://www.pythian.com/blogs">http://www.pythian.com/blogs</A>=20

<P><SPAN=20
style=3D"FONT-SIZE: 7.5pt; COLOR: gray; FONT-FAMILY: Arial"><BR>Fyrirvari=
/Disclaimer<BR><A=20
href=3D"http://www.landsbanki.is/disclaimer"><SPAN=20
style=3D"COLOR: gray">http://www.landsbanki.is/disclaimer</SPAN></A><o:p>=
</o:p></SPAN></P>
</BODY></HTML>

------_=_NextPart_001_01C6A1A1.E6CD6BCA--
--
http://www.freelists.org/webpage/oracle-l