REPOST: Re: REPOST: Re: Oracle 9i worth the switch?

From: Stefan <sroesch3_at_attbi.com>
Date: Tue, 01 Jan 2002 04:39:47 GMT
Message-ID: <1$--$$-$-_%%%--_$$@news.noc.cabal.int>

And you forgot to mention

- compiling pl/sql programs which can give a dramatic performance boost
- if using OPS, upgrading to RAC you will see the same
- improved OCI performace in array handling
- improved dequeue performance if using AQ (Advanced Queueing)

and lots of other performance enhancements. We already upgraded and it was worth the effort

Stefan

Howard J. Rogers wrote:

> Nope. Speaking entirely personally, 9i makes 8i look a bit sad. My
> personal favorutie new feature is flashback, but automatic undo and an
> undo
> retention policy are close seconds. Then there are the Materialized Views
> that now tell you why they won't fast refresh; the end of freelist
> contention as we knew (and hated) it; an intelligent cursor_sharing
> parameter; dynamically resizable bits of the SGA; automatic tuning of the
> PGA and a rather nice join syntax. The SPFILE is worth its weight in
> gold, too.
>
> Definitely worth the upgrade, and I don't recall seeing any major hassles
> posted here regarding painful bugs encountered (I could be getting senile,
> I suppose, and just forgetting them, but I don't think so <dribble,
> dribble>).
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "Marvin Frankel" <ptang9_at_yahoo.com> wrote in message
> news:a0o472$kfm_at_dispatch.concentric.net...

>> Is Oracle 9i worth upgrading to?  Or  is it just a whole lot of trouble

> not

>> worth getting into. Perhaps mostly  marketing hype and nonsense as some
>> magazines suggest?
>>
>> Thanks
>>
>>

>
> ========= WAS CANCELLED BY =======:
> Path:
>

news.sol.net!spool0-nwblwi.newsops.execpc.com!newsfeeds.sol.net!news-out.visi.com!hermes.visi.com!newsfeed1.earthlink.net!newsfeed.earthlink.net!uunet!lax.uu.net!news.navix.net!u-n-c-a-n-c-e-l-l-e-r
> From: "Howard J. Rogers" <dba_at_hjrdba.com> Newsgroups:
> alt.config,comp.lang.c,comp.databases.oracle.server Subject: cmsg cancel
> <3c2fa193$0$2603$afc38c87_at_news.optusnet.com.au> Control: cancel
> <3c2fa193$0$2603$afc38c87_at_news.optusnet.com.au> Date: Mon, 31 Dec 2001
> 08:11:18 GMT Organization: Navix Internet Subscribers
> Lines: 2
> Message-ID: <cancel.3c2fa193$0$2603$afc38c87_at_news.optusnet.com.au>
> NNTP-Posting-Host: 166.102.15.34
> X-Trace: iac5.navix.net 1009788567 26548 166.102.15.34 (31 Dec 2001
> 08:49:27 GMT) X-Complaints-To: abuse_at_navix.net
> NNTP-Posting-Date: 31 Dec 2001 08:49:27 GMT
> X-No-Archive: yes
> Comment: Anarchy! Fuck You!
> X-Commentary: I love NewsAgent 1.10, Sandblaster Build 74 (19 March 1999)
> and the Polaris Cancel Engine V. 6.1 X-Unacanc3l: yes
>
> This message was cancelled from within Mozilla...not

• WAS CANCELLED BY =======: Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!osa.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r From: Stefan <sroesch3_at_attbi.com> Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server Subject: cmsg cancel <n4bY7.24135$NE5.147385_at_rwcrnsc53> Control: cancel <n4bY7.24135$NE5.147385_at_rwcrnsc53> Date: Wed, 2 Jan 2002 00:14:03 GMT Organization: Navix Internet Subscribers Lines: 2 Message-ID: <cancel.n4bY7.24135$NE5.147385_at_rwcrnsc53> NNTP-Posting-Host: 166.102.15.34 X-Trace: iac5.navix.net 1009944102 21023 166.102.15.34 (2 Jan 2002 04:01:42 GMT) X-Complaints-To: abuse_at_navix.net NNTP-Posting-Date: 2 Jan 2002 04:01:42 GMT X-No-Archive: yes Comment: Dude, where's my NewsAgent? Xref: news.uni-stuttgart.de control:40277481

autocancel Received on Mon Dec 31 2001 - 22:39:47 CST