| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Rollback segment sizing on Ora7 vs. Ora8
Hi -
Forgetting for a few minutes how to estimate the required size for a rollback segment and so on....
I have Oracle on one system, let's call it SYS1. The version of Oracle is 7.0.16 and it has a rollback segment size of 80M. Most of the things I have to do with Oracle are importing flat files using SQL*LOAD. Typical import size file is several hundred MB. All works fine, Oracle does it loads properly. Great.
*NOW*
I'm turning over a new system, let's call it SYS2. The version of
Oracle is 8.0.5. I used the EXACT same database creation scripts.
I am testing imports in SQL*LOAD using the EXACT same files that
already work properly above in SYS1. Yet, on SYS2 - I keep running
messages about unable to extend rollback segments. I've tried
increasing the size of my rollback segment to 700M so far, and still
same problem.
The problem occurs on the 2nd trial run of the same file import
(obviously, when table is empty, the import works). The 2nd import
(when table has data in it) is when it fails.
Does anyone have any idea where I should start looking or what may be causing this problem. My guess is that there was some parameter in INIT.ORA that is either different (none that I can see that would effect this), or that there was some parameter that defaulted to a certain value in the older version of Oracle (on SYS1) that changed for the newer version (on SYS2). Some unnamed parameter?
Any help would be much appreciated.
Michael J. Loeffler
Manager of Information Systems
Teletrade, Inc.
MichaelL_at_Teletrade.com Received on Mon Aug 02 1999 - 17:20:45 CDT
 |
 |