Cheap Hardware and tons of data to load

From: Sharad <estancio_at_cyberspace.org>
Date: 2000/05/23
Message-ID: <simamq23o130@corp.supernews.com>#1/1

We need to load close upwards of 100 million rows in our Oracle 8.0.4 database. The hardware is a PIII 500MHz, 256 MB RAM, Single IDE disk, 1GB swap.

I know the hardware is not sufficient for this. However, we still need to do it ( Come'on you understand...)

The issue we need to load close to a 100,000 user information into the database. When we load 500 users it loads up in under 2 minutes. The subsequent 500 users take 4 minutes and then 10 minutes and so on......

---

db_name = PER1
db_files = 1020
control_files = ("D:\apps\orant\database\PER1\\ctl1PER1.ora", "D:\apps\orant\database\PER1\\ctl2PER1.ora") db_file_multiblock_read_count = 16
db_block_buffers = 20000
shared_pool_size = 90000000
log_checkpoint_interval = 10000
processes = 100
dml_locks = 250
log_buffer = 131072

sort_area_size = 3000000
sort_area_retained_size = 3000000
open_cursors = 128

sequence_cache_entries = 30
sequence_cache_hash_buckets = 23
#audit_trail = true
#timed_statistics = true

background_dump_dest =
user_dump_dest = db_block_size =2048
compatible = 8.0.4.0.0
log_checkpoint_timeout = 0
remote_login_passwordfile = shared
max_dump_file_size = 10240

---

I tried Oracle expert. Performance pack blah blah . Does not help.

Please help.

Much appret Received on Tue May 23 2000 - 00:00:00 CDT