RE: most practical 9iR2 features?
1. that Set oracle_sid=blah Sqlplus user/password Works on terminal server. 2. I like the workspace memory management features as well. 3. trace file timings in microseconds. 4. Cursor_sharing=similar (still has the odd bug). 5. HTMLDB is marketed for 10g but will install on 9.2 Niall -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Odland, Brad Sent: 15 January 2004 17:15 To: Multiple recipients of list ORACLE-L Subject: most practical 9iR2 features? 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Niall Litchfield INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: most practical 9iR2 features?
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: most practical 9iR2 features?
Brad, - External Tables have the potential to be WOW and when properly used instead of SQLLDR can meet #1 4. - Resumable transactions Stephen [EMAIL PROTECTED] 01/15/04 10:14AM 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Stephen Andert INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: most practical 9iR2 features?
This is a good question. We've been running 9i instances for 18+ months now. Here are my impressions: I would say RESUMABLE, especially for bulk loads, export/import, sqlloader is #1. This has saved HOURS!!! Dynamically modifiable SGA parameters have helped us with reliability. Less need to ever bounce! We're now letting the database name datafiles for new partitions, which, for archivable tables, makes it easier to drop partitions and datafiles and more easily reclaim space in an automated fashion. The new RMAN features, overall, make the product finally usable in our eyes. It still needs improvement, though... Undo tablespaces have significantly cut down on rollback and snapshot too old errors. But it's not perfect... Automated workarea size policy is much better than manually calculating PGA variables such as sort_area_size, etc... We haven't used much flashback or query rewrite features yet. At least not directly (some vendor code may use them). I am sure interested in seeing what others have to say. Michael Fontana Sr. DBA NTT/Verio -Original Message- Odland, Brad Sent: Thursday, January 15, 2004 11:15 AM 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Michael Fontana INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).