unable to allocate XXXX bytes of shared memory ("shared pool","TEXTINDEXMETHODS"

From: Ken <biggs_at_lone-star.net>
Date: 22 Jan 2002 14:21:28 -0800
Message-ID: <150b6aa0.0201221421.7436c45b@posting.google.com>

Could sure use some help,

Running oracle ver: 8.1.7.0.1 on Redhat Linux ver: 6.2 kernal version: 2.2.16-4.lfssmp on dual processor PIII 1 ghz w/ 2 gig ram & 4 gig of swap

Doing lots of context searches on a table w/2.5 million records.

Get lots of these in the java log:
ORA-04031: unable to allocate 4124 bytes of shared memory ("shared pool","TEXTINDEXMETHODS","pl/sql source","pl/sql source")

A few of these:
ORA-0431: unable to allocate 4096 bytes of shared memory ("shared pool,"CTXQUERY","PL/SQL MPCODE","BAMIMA: Bam Buffer")

here's the stuff from init.ora

db_files = 1500
db_file_multiblock_read_count = 32
db_block_buffers = 3200

shared_pool_size = 200000000
shared_pool_reserved_size = 100000000
large_pool_size = 6144000
java_pool_size = 20971520
log_checkpoint_interval = 10000
processes = 200
parallel_max_servers = 8
log_buffer = 163840
max_dump_file_size = 10240

I can't figure out how to optimize memory setup for oracle - way to complex for me. Thanks for any help!!

Ken Received on Tue Jan 22 2002 - 16:21:28 CST