Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: most practical 9iR2 features?

RE: most practical 9iR2 features?

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Thu, 15 Jan 2004 12:14:39 -0800
Message-ID: <F001.005DCF16.20040115121439@fatcity.com>


Brad,

        We're primarily using 9i with a third party time accounting system, so I haven't had too much time with a lot of 9i, but the resumable transactions are a REAL time & energy saver. The Time accounting system has to do bulk data loads from our HR system as well as it's own batch processing. All things that like to eat up tablespace and you can guess that the vendor's "estimates" (more like Guesstimates) were not up to the realities. But they did set themselves up to use the resumable transaction capability and I did manage to get the database internals setup, thank you OTS. Then when these batch jobs were run for real the jobs stopped while I got paged. In the old days the job would have failed leading to a lot of finger pointing, etc... In this case I was able to fix it & it continued without error. Now that's a FEATURE!!! :-)

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Thursday, January 15, 2004 12:15 PM To: Multiple recipients of list ORACLE-L

Hey listers....

I am doing some research and would like to get (in very short answers) features of 9iR2 that folks have implemented that meet the following goals:

  1. Ease administration
  2. Are not marketing crap
  3. Are not already in 8.1.7
  4. Increase response time and or perfromance

A quick bullet list would be way cool of stuff that make you puff up and say "...this is so cool"

We are going to be moving our MRP system from 8.1.7 to 9iR2 this year and I'd like to get a feel for which items can help our old MRP app.

Reply direct if you desire.

We'll be implementing a new box with a SAN and so we already have some plans for actually using some features in 8i that were not feasible on our old AutoRAID. (There's nothing like getting a new box...)

(I am already reading the new features doc and another doc by Howard Rogers....)

Thanks in advance

Brad O.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Odland, Brad
  INET: Brad.Odland_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Goulet, Dick
  INET: DGoulet_at_vicr.com
Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jan 15 2004 - 14:14:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US