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
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
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
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