There is a bug in 8.1.7 in which the connect/disconnect causes a memory leak
in the shared pool. You need to patch to 8.1.7 and then apply a bug fix.
Not
sure what the bug number is but its up there on the ftp site. It took me
approximately
10 hours to get the first page regarding this issue aft
It might be the bug.
The Oracle bug number is 1397603. According to Oracle, the bug involves a
memory leak in their internal caching mechanism. The workaround is to put
the following line in the init.ora file, and then restart Oracle:
_db_handles_cached = 0
This is supposed to disable the bug
t;
> John
>
> > -Original Message-
> > From: Toepke, Kevin M
> [SMTP:[EMAIL PROTECTED]]
> > Sent: 11 July 2001 14:06
> > To: Multiple recipients of list ORACLE-L
> > Subject:RE: unable to allocate 4096 bytes of
> shared memo
> Sent: 11 July 2001 14:06
> To: Multiple recipients of list ORACLE-L
> Subject: RE: unable to allocate 4096 bytes of shared memory -
> HELP
>
> That is a bug. You have to apply, I believe, the 8.1.7.3 patchset.
>
> -Original Message-
> Sent: Wedn
Kevin
Thanks...it that documented anywhere?
John
> -Original Message-
> From: Toepke, Kevin M [SMTP:[EMAIL PROTECTED]]
> Sent: 11 July 2001 14:06
> To: Multiple recipients of list ORACLE-L
> Subject: RE: unable to allocate 4096 bytes of shared memory -
> HELP!
you could do alter system flush shared_pool from the svrmgr
Baskar
-Original Message-
Sent: 11 July 2001 14:17
To: Multiple recipients of list ORACLE-L
> We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as
> follows :
>
> It appears to be related to dbms_job
>
> C
John:
List, please correct me if I'm wrong, but it appears that your
shared pool isn't big enough or is too fragmented. You can try
two things as I see it right now: (1) try pinning your large,
frequently used packages into the shared pool at instance startup
using the DBMS_SHARED_POOL package,
> We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as
> follows :
>
> It appears to be related to dbms_job
>
> Can any one help?
>
> John
>
> Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp2_28976_prtgh1.trc:
> ORA-12012: error on auto execute of job 11223917
>
> ORA-
That is a bug. You have to apply, I believe, the 8.1.7.3 patchset.
-Original Message-
Sent: Wednesday, July 11, 2001 7:41 AM
To: Multiple recipients of list ORACLE-L
We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as
follows :
It appears to be related to dbms_job
Ca
John,
Increase the Shared_Pool_Size parameter in the INIT.ORA file, and restart
the database.
I would suggest an increase of at least 50%.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Wednesday, July 11, 2001 7:41 AM
To: Multiple recipients of list ORACLE-L
W
John
There appears to be a number of excellent articles on Metalink regarding
tuning Shared pool space and
It seems your SGA needs a tune up to resolve this.
Go and search on the ORA-04031 to get the documents
If you don't have access let me know and I will see how I can help out.
Peter
At 0
> We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as
> follows :
>
> It appears to be related to dbms_job
>
> Can any one help?
>
> John
>
> Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp2_28976_prtgh1.trc:
> ORA-12012: error on auto execute of job 11223917
>
> ORA-
We have just upgraded from 8.0.5 to 8.1.7 and are getting problems as
follows :
It appears to be related to dbms_job
Can any one help?
John
Errors in file /u01/app/oracle/admin/PRTGH1/bdump/snp2_28976_prtgh1.trc:
ORA-12012: error on auto execute of job 11223917
ORA-04031: unable to allocate 4
13 matches
Mail list logo