Exactly, utilise the memory you have on your server.
I would also note that you have upgraded to a very old, unsupported and
bug-ridden version of Oracle. We run all of our Oracle 9i databases at a
minimum patch version of 9.2.0.7 as we found everything below that had
too many bugs for our liking. I suggest that you upgrade to a more
stable version.
Regards
Garnet
-----Original Message-----
From: John Collard
[mailto:oracledba-ezmlmshield-x60352127.[Email address protected]
Sent: 31 January 2007 10:19
To: LazyDBA Discussion
Subject: RE: upgradation from oracle 8.1.5 to 9.0.1
The error message indicates that the "Large Pool" is too small so you
are probably using Shared Server? I have seen the same error in the
same circumstances.
You have plenty of memory so follow Naim's advice and also try a Large
Pool size of 256MB.
Also, do you need to be in Shared Server mode (see previous thread)?
Regards,
John
-----Original Message-----
From: Naim Akhter
[mailto:oracledba-ezmlmshield-x77670197.[Email address protected]
Sent: 31 January 2007 09:12
To: LazyDBA Discussion
Subject: RE: upgradation from oracle 8.1.5 to 9.0.1
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.
---------------------------------------------------------------------
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
**********************************************************************
APAK Group plc, Registered in England No. 1451033. Registered office
APAK House, Badminton Court, Station Road, Yate, Bristol, BS37 5HZ.
The information contained in this message or any of its attachments may
be privileged and confidential and intended for the exclusive use of the
addressee. The views expressed may not be APAK policy but the personal
views of the originator. If you have received this message in error,
please
advise the sender immediately by reply e-mail and delete this message
and
any attachments without retaining a copy. This footnote also confirms
that
this email message has been swept for the presence of known computer
viruses before being sent.
**********************************************************************
---------------------------------------------------------------------
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
Oracle LazyDBA home page