REPOST: Re: Oracle 9i worth the switch?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Mon, 31 Dec 2001 10:23:30 +1100
Message-ID: <1$--$$-$$_%%__$__$@news.noc.cabal.int>

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

Received on Sun Dec 30 2001 - 17:23:30 CST