Init.ora modification and problem.

From: Epicentre team A <oracle_at_epicentre.fr>
Date: Sat, 24 Aug 2002 11:33:31 +0200
Message-ID: <ak7jj9$n9e$1@wanadoo.fr>

I want to change parameter file but when massives imports via Sql Loader import stop about 15 minutes. There is importants core dump errors. On server no problem with pagging or swapping operations (normal)

Platform: HP-UX
Oracle Enterprise 8.1.7
Ram 2 Go
Raid 1

Before change we have.

db_files=200
large_pool_size=614400
shared_pool_size=80485760
hash_multiblock_io_count=0
db_block_lru_latches=2
cursor_sharing_force=exact
optimizer_index_caching=50

After Change it's

db_files=150
large_pool_size=300000
shared_pool_size=81920000
hash_multiblock_io_count=8
db_block_lru_latches=4
cursor_sharing_force=force
optimizer_index_caching=99

I've you an idea ?
Denis Jeanneret Received on Sat Aug 24 2002 - 04:33:31 CDT