Increase the shared pool size and db_cache_size by atleast 100m
Thanks & Regards
Naim Akhter
Oracle Database Administrator
Managed Services
3i-infotech,Vashi
Mumbai,India
-----Original Message-----
From: Suhas Vankudre
[mailto:oracledba-ezmlmshield-x13678240.[Email address protected]
Sent: Wednesday, January 31, 2007 2:28 PM
To: LazyDBA Discussion
Subject: upgradation from oracle 8.1.5 to 9.0.1
Dear all
Please help me
We have upgraded the database from Oracle8i Release 8.1.5.0.0 to Oracle9i
Enterprise Edition Release 9.0.1.1.1.
We had some errors occuring as follows
1) When the users logged in it work for sometime smoothly and afterwards it
starts giving error.
(ORA-04031 unable to allocate ____ bytes of shared memory("large pool",
"unknown object","hash-join subh","kllcqc:kllcsqit)
Shared pool size is 250MB,db_block_size 4k, db_cache_size 33554432.
we have server with 4 processor and 4 GB RAM.
please help
suhas
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---
This e-mail message may contain confidential, proprietary or legally privileged information. It should not be used by anyone who is not the original intended recipient.If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that 3i Infotech or its subsidiaries and associated companies, (collectively "3i Infotech"), are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of 3i Infotech. Before opening any attachments please check them for viruses and defects.
Oracle LazyDBA home page