Home » RDBMS Server » Server Administration » Urgent
Urgent [message #53025] Sun, 25 August 2002 04:06 Go to next message
Pravin Raharekar
Messages: 18
Registered: April 2002
Junior Member
Dear All,

I am facing problem using oracle 9i, My db_buffer_cahce is 40 MB, shared pool 50 MB large poo is around 3 MB. There are concurent 5-6 users are accessing database. All these are firing queries which are giving heavy burden by using update, delete and insert statement. Every query is update, deleting or inserting 10000-20000 records. Many time serve gives following message:

ORA-04031: unable to allocate 76156 bytes of shared memory ("large pool","unknown object","hash-join subh","kllcqc:kllcqslt")

The OS is win NT on IBM machine. I would like to know, is my parameter are correct or I have to change them. Please give solution on this.

Thanks in advance

Pravin

Report message to a moderator

Re: Urgent [message #53029 is a reply to message #53025] Sun, 25 August 2002 11:49 Go to previous messageGo to next message
Jyothi
Messages: 12
Registered: May 2002
Junior Member
U better increase the shared pool size if u have the luxury to do so..

Hope that helps
Jyothi

Report message to a moderator

Re: Urgent [message #53032 is a reply to message #53025] Sun, 25 August 2002 20:07 Go to previous messageGo to next message
Pravin Raharekar
Messages: 18
Registered: April 2002
Junior Member
Hi,

Thanks, but after increasing size of shared pool, still the performance is slow, any solution.

Rgds

Pravin

Report message to a moderator

Re: Urgent [message #53035 is a reply to message #53025] Sun, 25 August 2002 23:18 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Increasing the shared pool doesn't always solve this errors. Better ways of doing it could be to Pin objects in shared memory or Set up shared_pool_reserved_size

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Previous Topic: Data File Lost
Next Topic: net 8 assistant problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 26 10:50:25 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.