Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!pd7cy1no!shaw.ca!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news-out.superfeed.net!propagator2-maxim!feed-maxim.newsfeeds.com!newsfeed.pacific.net.au!spool01.syd.optusnet.com.au!spool.optusnet.com.au!not-for-mail Message-Id: <3f86c1ab$0$6610$afc38c87@news.optusnet.com.au> From: "Howard J. Rogers" Subject: Re: Oracle 9i New Features or Data Guard Course Newsgroups: comp.databases.oracle.server Date: Sat, 11 Oct 2003 00:24:31 +1000 References: <8bccbf05.0310100603.72730768@posting.google.com> Organization: Dizwell Informatics User-Agent: KNode/0.7.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit Lines: 60 NNTP-Posting-Host: 203.164.6.211 X-Trace: 1065796012 6610 203.164.6.211 Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:245012 Martyn wrote: > Hi, > I am wanting feedback from anyone that has attended one or both of > these courses as to which they thought I would benefit from most. At > the moment I am leaning towards New Features course but am open to > persuasion. > I work for an organisation that has a very limited training budget and > am trying to decide which course I should attend. > > We have many applications from many vendors (we do not do any in-house > development at all), so we are vendor driven wrt Oracle version and > all are currently at 8.x. One production application is to be migrated > from 8.1.7.0 to 9.2.0.1 in Feb 2004 and this date is set in stone. > Part of the SLA for this app. requires that we maintain a standby > database (for legal purposes) and I am aware that the standby > mechanism on 9i is vastly different to 8i. No, it *can* be vastly different. But it doesn't have to be. Indeed, if you wish it can be exactly the same as in 8i. > Currently we have in-house > scripts to maintain the standby database. > > Any feedback would be grateful as unfortunately I can only attend one > course. Can't answer your initial question, I'm afraid. Do you want or need to know about flashback, workspace management, automatic undo, ASSM, Oracle Managed Files, RAC, Resource Manager, Online Table Redefinitions, External Tables. List Partitioning, Dynamic Statistics Sampling, Dynamic SGA, new SQL commands, Unicode and the Timestamp datatype? Then go to the New Features course. If you never have any intention of using any of these features, and don't expect to be moving jobs any time soon to someplace that may, then New Features is probably overkill If all you want to know about is automated Data Guarded physical or logical standby databases, then the Data Guard course. But given that what you have now will almost certainly run unchanged in 9i, then I'd lean towards 9i new features. If you strike lucky with your instructor, you can pump him or her for additional Data Guard information over the tea break. Regards HJR > > Martyn -- -------------------------------------------- See my brand new website, soon to be full of new articles: www.dizwell.com. Nothing much there yet, but give it time!! --------------------------------------------