Home » RDBMS Server » Performance Tuning » Using Loader to load 4GB into a temporary table in RAM
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?
Previous Topic: analying 10053 trace
Next Topic: Testing performance of queries (caching)
Goto Forum:
  


Current Time: Wed Feb 28 04:13:43 CST 2024