| Using Loader to load 4GB into a temporary table in RAM [message #65436] |
Tue, 21 September 2004 08:20 |
scott
Messages: 73
Registered: September 1999
|
Member |
|
|
In a datawarehouse we must load lots of data from flat files which have a
total size of 8 GB. The sqlldr works fine for this. I would rather load the
data into tables in memory and never have the data hit disk because the tables
are deleted after all. I have the extra RAM for this.
What SQL/PL/SQL coding supports loading the tables into RAM from SQL*Loader?
VARRAYs? Object tables?
How is the RAM configured? PGA bigger by 8-10 GB? SGA bigger by 8-10 GB?
keep_pool bigger by 8-10 GB?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
