RE: most practical 9iR2 features?

2004-01-16 Thread Niall Litchfield
1. that Set oracle_sid= 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 Nial

RE: most practical 9iR2 features?

2004-01-15 Thread Michael Fontana
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 ev

Re: most practical 9iR2 features?

2004-01-15 Thread Stephen Andert
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 tha

RE: most practical 9iR2 features?

2004-01-15 Thread Goulet, Dick
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 pr