RE: Rash of shared memory errors

2001-09-23 Thread Arn Klammer

Thanx, everyone, for replying so quickly!  We're on 8.1.7.1 (sorry for omitting that 
in my OP).  I'll look for the patch straight after this.  

Rahul and Connor, when you say the cause may be that the application is not using bind 
variables, do you mean that the application is using dynamic SQL, and thus almost 
every call to the DB during application execution is different, thus limiting query 
reuse?  If that's the case, then this is not the cause in our app, as we don't use 
dynamic SQL at all.  However, if you mean another way of not using bind variables, but 
in static queries, then could you please explain how this could be done, so I can 
check our app?

Thanx very much.

-arn

 [EMAIL PROTECTED] 21/9/2001 23:05:22 
This message has been scanned by MAILSweeper.


i would take a look at the application before increasing the size

 --
 From: Mercadante, Thomas F[SMTP:[EMAIL PROTECTED]] 
 Reply To: [EMAIL PROTECTED] 
 Sent: Friday, September 21, 2001 7:50 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Rash of shared memory errors
 
 Arn
 
 A shared pool size of 16 Meg is not large enough.  This error clearly
 indicates that you are out of memory.
 
 It may be larger than your test and maintenance db, but it is not large
 enough for your developers. 
 
 I don't know about you, but I have more developers on my Dev instances
 than
 testers on my testing instance!  My shared pool value in my Dev instance
 is
 80Meg, and I never get this error.
 
 Try increasing your shared pool to at least 50 Meg and see if the problem
 goes away.
 
 Hope this helps
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 Sent: Friday, September 21, 2001 3:55 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi,
 
 Just recently, we have been frequently receiving errors like the following
 in our development database:
 
 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
 pool,BEGIN
 DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)
 
 The size of our shared pool is not too small (I think); it's larger than
 our
 test and maintenance databases, for example.
 
 shared_pool_reserved_sizestring  80
 shared_pool_size string  1600
 
 What could be causing this level of frequent fragmentation?  We have been
 developing a new application in the database, but this has been ongoing
 for
 some months; the errors appeared only in the last week or so.
 
 What should I be looking for to solve this?
 
 Thanx for any advice.
 
 -arn
 
 
 
 
 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.
 
 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.
 
 www.mimesweeper.com 
 **
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: Arn Klammer
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com 
 -- 
 Author: Mercadante, Thomas F
   INET: [EMAIL PROTECTED] 
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Rahul
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY

RE: Rash of shared memory errors

2001-09-23 Thread A. Bardeen

Arn,

You could be running into bug 1397603 that is fixed in
the 8.1.7.2 patchset.  The workaround is to set
_db_handles_cached = 0 although if a db already has a
problem with latch contention, this is likely to make
it worse.  Bug 1397603 is a generic bug specific to
8.1.7.

The following query can be used to monitor the memory
usage for state objects:

SELECT * FROM V$SGASTAT WHERE NAME LIKE '%tate
object%';

This memory use should level off after the db has been
in use for a few hours.  If it's constantly growing
then it's most likely bug 1397603.  

There is a similar bug specific to 8.1.6.3, bug
1640583, that doesn't have a workaround.  There are
PSE (patchset exceptions) for this bug on most
platforms, however.  Contact OSS for the PSE.  BTW,
this PSE is mandatory for running apps 11i on 8.1.6.3.

HTH,

-- Anita

--- Arn Klammer [EMAIL PROTECTED] wrote:
 Thanx, everyone, for replying so quickly!  We're on
 8.1.7.1 (sorry for omitting that in my OP).  I'll
 look for the patch straight after this.  
 
 Rahul and Connor, when you say the cause may be that
 the application is not using bind variables, do you
 mean that the application is using dynamic SQL, and
 thus almost every call to the DB during application
 execution is different, thus limiting query reuse? 
 If that's the case, then this is not the cause in
 our app, as we don't use dynamic SQL at all. 
 However, if you mean another way of not using bind
 variables, but in static queries, then could you
 please explain how this could be done, so I can
 check our app?
 
 Thanx very much.
 
 -arn
 
  [EMAIL PROTECTED] 21/9/2001 23:05:22 
 This message has been scanned by MAILSweeper.


 
 i would take a look at the application before
 increasing the size
 
  --
  From:   Mercadante, Thomas
 F[SMTP:[EMAIL PROTECTED]] 
  Reply To:   [EMAIL PROTECTED] 
  Sent:   Friday, September 21, 2001 7:50 PM
  To: Multiple recipients of list ORACLE-L
  Subject:RE: Rash of shared memory errors
  
  Arn
  
  A shared pool size of 16 Meg is not large enough. 
 This error clearly
  indicates that you are out of memory.
  
  It may be larger than your test and maintenance
 db, but it is not large
  enough for your developers. 
  
  I don't know about you, but I have more developers
 on my Dev instances
  than
  testers on my testing instance!  My shared pool
 value in my Dev instance
  is
  80Meg, and I never get this error.
  
  Try increasing your shared pool to at least 50 Meg
 and see if the problem
  goes away.
  
  Hope this helps
  
  Tom Mercadante
  Oracle Certified Professional
  
  
  -Original Message-
  Sent: Friday, September 21, 2001 3:55 AM
  To: Multiple recipients of list ORACLE-L
  
  
  Hi,
  
  Just recently, we have been frequently receiving
 errors like the following
  in our development database:
  
  ERROR:
  ORA-04031: unable to allocate 4096 bytes of shared
 memory (shared
  pool,BEGIN
  DBMS_OUTPUT.DISABLE; E...,PL/SQL
 MPCODE,BAMIMA: Bam Buffer)
  
  The size of our shared pool is not too small (I
 think); it's larger than
  our
  test and maintenance databases, for example.
  
  shared_pool_reserved_sizestring 
 80
  shared_pool_size string 
 1600
  
  What could be causing this level of frequent
 fragmentation?  We have been
  developing a new application in the database, but
 this has been ongoing
  for
  some months; the errors appeared only in the last
 week or so.
  
  What should I be looking for to solve this?
  
  Thanx for any advice.
  
  -arn
  
  
  
  
 

**
  This email and any files transmitted with it are
 confidential and
  intended solely for the use of the individual or
 entity to whom they
  are addressed. If you have received this email in
 error please notify
  the system manager.
  
  This footnote also confirms that this email
 message has been swept by
  MIMEsweeper for the presence of computer viruses.
  
  www.mimesweeper.com 
 

**
  -- 
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com 
  -- 
  Author: Arn Klammer
INET: [EMAIL PROTECTED] 
  
  Fat City Network Services-- (858) 538-5051 
 FAX: (858) 538-5051
  San Diego, California-- Public Internet
 access / Mailing Lists
 


  To REMOVE yourself from this mailing list, send an
 E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
  the message BODY, include a line containing: UNSUB
 ORACLE-L
  (or the name of mailing list you want to be
 removed from).  You may
  also send the HELP command for other information
 (like subscribing).
  -- 
  Please see the official ORACLE-L FAQ:
 http://www.orafaq.com 
  -- 
  Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED

Rash of shared memory errors

2001-09-21 Thread Arn Klammer

Hi,

Just recently, we have been frequently receiving errors like the following in our 
development database:

ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN
DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)

The size of our shared pool is not too small (I think); it's larger than our test and 
maintenance databases, for example.

shared_pool_reserved_sizestring  80
shared_pool_size string  1600

What could be causing this level of frequent fragmentation?  We have been developing a 
new application in the database, but this has been ongoing for some months; the errors 
appeared only in the last week or so.

What should I be looking for to solve this?

Thanx for any advice.

-arn




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arn Klammer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Rash of shared memory errors

2001-09-21 Thread Rahul

almost always because of the applicaiton NOT using bind variables...

 --
 From: Arn Klammer[SMTP:[EMAIL PROTECTED]]
 Reply To: [EMAIL PROTECTED]
 Sent: Friday, September 21, 2001 2:55 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Rash of shared memory errors
 
 Hi,
 
 Just recently, we have been frequently receiving errors like the following
 in our development database:
 
 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
 pool,BEGIN
 DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)
 
 The size of our shared pool is not too small (I think); it's larger than
 our test and maintenance databases, for example.
 
 shared_pool_reserved_sizestring  80
 shared_pool_size string  1600
 
 What could be causing this level of frequent fragmentation?  We have been
 developing a new application in the database, but this has been ongoing
 for some months; the errors appeared only in the last week or so.
 
 What should I be looking for to solve this?
 
 Thanx for any advice.
 
 -arn
 
 
 
 
 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.
 
 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.
 
 www.mimesweeper.com
 **
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Arn Klammer
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



Re: Rash of shared memory errors

2001-09-21 Thread Maria Aurora VT de la Vega

are you using oracle 8.1.7?
if you are, this is caused by a bug on this version.
you will only need to add another parameter in your init.ora...
search metalink for the details of how to fix this...

hth

=)

Arn Klammer wrote:

 Hi,

 Just recently, we have been frequently receiving errors like the following in our 
development database:

 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN
 DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)

 The size of our shared pool is not too small (I think); it's larger than our test 
and maintenance databases, for example.

 shared_pool_reserved_sizestring  80
 shared_pool_size string  1600

 What could be causing this level of frequent fragmentation?  We have been developing 
a new application in the database, but this has been ongoing for some months; the 
errors appeared only in the last week or so.

 What should I be looking for to solve this?

 Thanx for any advice.

 -arn

 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.

 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.

 www.mimesweeper.com
 **
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Arn Klammer
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Rash of shared memory errors

2001-09-21 Thread Toepke, Kevin M

There is also a fix for this on Metalink (I think version 8.1.7.3)

-Original Message-
Sent: Friday, September 21, 2001 5:30 AM
To: Multiple recipients of list ORACLE-L


are you using oracle 8.1.7?
if you are, this is caused by a bug on this version.
you will only need to add another parameter in your init.ora...
search metalink for the details of how to fix this...

hth

=)

Arn Klammer wrote:

 Hi,

 Just recently, we have been frequently receiving errors like the following
in our development database:

 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN
 DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)

 The size of our shared pool is not too small (I think); it's larger than
our test and maintenance databases, for example.

 shared_pool_reserved_sizestring  80
 shared_pool_size string  1600

 What could be causing this level of frequent fragmentation?  We have been
developing a new application in the database, but this has been ongoing for
some months; the errors appeared only in the last week or so.

 What should I be looking for to solve this?

 Thanx for any advice.

 -arn

 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.

 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.

 www.mimesweeper.com
 **
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Arn Klammer
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Toepke, Kevin M
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Rash of shared memory errors

2001-09-21 Thread Weaver, Walt

Yes, one of the reasons we upgraded to 8.1.7.2 was to fix this bug. Can't
report just yet as to whether it works or not.

--Walt Weaver
  Bozeman, Montana

-Original Message-
Sent: Friday, September 21, 2001 3:30 AM
To: Multiple recipients of list ORACLE-L


are you using oracle 8.1.7?
if you are, this is caused by a bug on this version.
you will only need to add another parameter in your init.ora...
search metalink for the details of how to fix this...

hth

=)

Arn Klammer wrote:

 Hi,

 Just recently, we have been frequently receiving errors like the following
in our development database:

 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN
 DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)

 The size of our shared pool is not too small (I think); it's larger than
our test and maintenance databases, for example.

 shared_pool_reserved_sizestring  80
 shared_pool_size string  1600

 What could be causing this level of frequent fragmentation?  We have been
developing a new application in the database, but this has been ongoing for
some months; the errors appeared only in the last week or so.

 What should I be looking for to solve this?

 Thanx for any advice.

 -arn

 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.

 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.

 www.mimesweeper.com
 **
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 --
 Author: Arn Klammer
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Weaver, Walt
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Rash of shared memory errors

2001-09-21 Thread Mercadante, Thomas F

Arn

A shared pool size of 16 Meg is not large enough.  This error clearly
indicates that you are out of memory.

It may be larger than your test and maintenance db, but it is not large
enough for your developers. 

I don't know about you, but I have more developers on my Dev instances than
testers on my testing instance!  My shared pool value in my Dev instance is
80Meg, and I never get this error.

Try increasing your shared pool to at least 50 Meg and see if the problem
goes away.

Hope this helps

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Friday, September 21, 2001 3:55 AM
To: Multiple recipients of list ORACLE-L


Hi,

Just recently, we have been frequently receiving errors like the following
in our development database:

ERROR:
ORA-04031: unable to allocate 4096 bytes of shared memory (shared
pool,BEGIN
DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)

The size of our shared pool is not too small (I think); it's larger than our
test and maintenance databases, for example.

shared_pool_reserved_sizestring  80
shared_pool_size string  1600

What could be causing this level of frequent fragmentation?  We have been
developing a new application in the database, but this has been ongoing for
some months; the errors appeared only in the last week or so.

What should I be looking for to solve this?

Thanx for any advice.

-arn




**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Arn Klammer
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Rash of shared memory errors

2001-09-21 Thread Rahul

i would take a look at the application before increasing the size

 --
 From: Mercadante, Thomas F[SMTP:[EMAIL PROTECTED]]
 Reply To: [EMAIL PROTECTED]
 Sent: Friday, September 21, 2001 7:50 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  RE: Rash of shared memory errors
 
 Arn
 
 A shared pool size of 16 Meg is not large enough.  This error clearly
 indicates that you are out of memory.
 
 It may be larger than your test and maintenance db, but it is not large
 enough for your developers. 
 
 I don't know about you, but I have more developers on my Dev instances
 than
 testers on my testing instance!  My shared pool value in my Dev instance
 is
 80Meg, and I never get this error.
 
 Try increasing your shared pool to at least 50 Meg and see if the problem
 goes away.
 
 Hope this helps
 
 Tom Mercadante
 Oracle Certified Professional
 
 
 -Original Message-
 Sent: Friday, September 21, 2001 3:55 AM
 To: Multiple recipients of list ORACLE-L
 
 
 Hi,
 
 Just recently, we have been frequently receiving errors like the following
 in our development database:
 
 ERROR:
 ORA-04031: unable to allocate 4096 bytes of shared memory (shared
 pool,BEGIN
 DBMS_OUTPUT.DISABLE; E...,PL/SQL MPCODE,BAMIMA: Bam Buffer)
 
 The size of our shared pool is not too small (I think); it's larger than
 our
 test and maintenance databases, for example.
 
 shared_pool_reserved_sizestring  80
 shared_pool_size string  1600
 
 What could be causing this level of frequent fragmentation?  We have been
 developing a new application in the database, but this has been ongoing
 for
 some months; the errors appeared only in the last week or so.
 
 What should I be looking for to solve this?
 
 Thanx for any advice.
 
 -arn
 
 
 
 
 **
 This email and any files transmitted with it are confidential and
 intended solely for the use of the individual or entity to whom they
 are addressed. If you have received this email in error please notify
 the system manager.
 
 This footnote also confirms that this email message has been swept by
 MIMEsweeper for the presence of computer viruses.
 
 www.mimesweeper.com
 **
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Arn Klammer
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Mercadante, Thomas F
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).