Sql*Loader
Both Oracle DB version: 10.2.0.4Both OS: Red Hat Enterprise Linux Server release 5.6 (Tikanga)
We are in process of moving production db from 32 bit to 64 bit OS/DB. The Sql*Loader is running lot slower in 64 bit version then 32 bit.
the following init parameters are different between both databases.
which paramters could affect negatively with sql loader? note: the SQL* Loader script is the same in both databases as well as table structure including indexes and stats.... Or is there anything else could be a problem.
We are in process of moving production db from 32 bit to 64 bit OS/DB. The Sql*Loader is running lot slower in 64 bit version then 32 bit.
the following init parameters are different between both databases.
which paramters could affect negatively with sql loader? note: the SQL* Loader script is the same in both databases as well as table structure including indexes and stats.... Or is there anything else could be a problem.
| 32 BIT | 64 BIT | |||
| NAME | VALUE | NAME | VALUE | |
| compatible | 10.2.0.1.0 | compatible | 10.2.0.3.0 | |
| CPU_count | 8 | cpu_count | 16 | |
| db_cache_size |
0