RE: ORA-04031

2003-06-30 Thread Schauss, Peter
0.0 -Original Message- Sent: Friday, June 27, 2003 6:10 PM To: Multiple recipients of list ORACLE-L What patch level of 8.1.7 are you on?? --Walt --- Schauss, Peter [EMAIL PROTECTED] wrote: One of our third party applications gave us the following message: ORA-04031: unable

RE: ORA-04031

2003-06-30 Thread Regis Biassala
on?? --Walt --- Schauss, Peter [EMAIL PROTECTED] wrote: One of our third party applications gave us the following message: ORA-04031: unable to allocate 4192 bytes of shared memory Environment is Oracle 8.1.7 on AIX 4.3.2 The output from select * from v$sgastat showed about 3 mb free

RE: ORA-04031

2003-06-30 Thread Schauss, Peter
: Friday, June 27, 2003 6:10 PM To: Multiple recipients of list ORACLE-L What patch level of 8.1.7 are you on?? --Walt --- Schauss, Peter [EMAIL PROTECTED] wrote: One of our third party applications gave us the following message: ORA-04031: unable to allocate 4192 bytes of shared memory

ORA-04031

2003-06-27 Thread Schauss, Peter
One of our third party applications gave us the following message: ORA-04031: unable to allocate 4192 bytes of shared memory Environment is Oracle 8.1.7 on AIX 4.3.2 The output from select * from v$sgastat showed about 3 mb free out of a total of 40 mb of shared pool. I increased the size

Re: ORA-04031

2003-06-27 Thread Jose Luis Delgado
are interested send me a mail off-list and I'll start to look for it :-) and send it to you!. HTH JL --- Schauss, Peter [EMAIL PROTECTED] wrote: One of our third party applications gave us the following message: ORA-04031: unable to allocate 4192 bytes of shared memory Environment is Oracle 8.1.7

RE: ORA-04031

2003-06-27 Thread Weaver, Walt
What patch level of 8.1.7 are you on?? --Walt --- Schauss, Peter [EMAIL PROTECTED] wrote: One of our third party applications gave us the following message: ORA-04031: unable to allocate 4192 bytes of shared memory Environment is Oracle 8.1.7 on AIX 4.3.2 The output from

RE: ORA-04031

2003-06-27 Thread DENNIS WILLIAMS
Peter You might take a look at Note 146599.1 on Metalink, Diagnosing and Resolving Error ORA-04031. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 2:30 PM To: Multiple recipients of list ORACLE-L One of our

Export generates ORA-04031 error

2003-02-24 Thread Nguyen, David M
increase shared_pool_size? Currenlty it is increased from 500 to 900. EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN :1 := SYS.DBMS_REFR...,PL/SQL MPCODE,BAMIMA: Bam Buffer) EXP-00083: The previous problem occurred when

RE: Export generates ORA-04031 error

2003-02-24 Thread Nelson, Allan
this issue permanently? And what is the maximum limit size can I increase shared_pool_size? Currenlty it is increased from 500 to 900. EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN :1 := SYS.DBMS_REFR...,PL/SQL MPCODE

Re: ORA-04031 error

2003-02-08 Thread chao_ping
the large pool? Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) === 2003-02-07 17:28:00 ,you wrote£º=== Hi List, whats the meaning of the following error ERROR at line 1: ORA-04031: unable to allocate 4096 bytes of shared memory (large pool

ORA-04031 error

2003-02-07 Thread brain_damage
Hi List, whats the meaning of the following error ERROR at line 1: ORA-04031: unable to allocate 4096 bytes of shared memory (large pool,unknown object,sort subheap,sort key) heres the sql query ---select * from hox12 order by op desc; Oracle Release --8.1.6.1.0 OS -- RH 7.1 sort_area_size-- 2MB

RE: ORA-04031 error

2003-02-07 Thread Sony kristanto
, 2003 8:29 AM To: Multiple recipients of list ORACLE-L Subject: ORA-04031 error Hi List, whats the meaning of the following error ERROR at line 1: ORA-04031: unable to allocate 4096 bytes of shared memory (large pool,unknown object,sort subheap,sort key) heres the sql query ---select

Re: ORA-04031

2002-12-20 Thread Yechiel Adar
the database. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 20, 2002 8:48 AM I received ORA-04031 while exporting database. Can someone explain what causes it and how to fix it? . exporting post-schema procedural

RE: ORA-04031

2002-12-20 Thread Koivu, Lisa
Title: RE: ORA-04031 Hi David, I ran into this too. Try the following: 1. flush shared pool, re-execute 2. bounce database. IN addition if you search on this on Metalink you will find lots of info. HTH Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut

Re: ORA-04031

2002-12-20 Thread JApplewhite
by: cc: [EMAIL PROTECTED] Subject: ORA-04031

ORA-04031

2002-12-19 Thread Nguyen, David M
I received ORA-04031 while exporting database. Can someone explain what causes it and how to fix it? . exporting post-schema procedural objects and actions EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN :1 := SYS.DBMS_REFR

RE: ORA-04031

2002-09-12 Thread Diego Cutrone
On Wed, 2002-09-11 at 18:14, Seema Singh wrote: Hi One of instance are showing ORA-04031 error more frequntly(2 times in a week).I increased SGA ,pinned some of DBMS packages,flush SGA etc but all these are not helping at all.Let me know what could be look next. Thx -Seema

Re: ORA-04031

2002-09-12 Thread Seema Singh
its 8.1.7.4 From: Mark J. Bobak [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-04031 Date: Wed, 11 Sep 2002 21:08:18 -0800 Um, version? (To at least 4 places, please!) On the off change you are on 8.1.7.x, where x 3

RE: ORA-04031

2002-09-12 Thread Jesse, Rich
-L Subject: Re: ORA-04031 its 8.1.7.4 From: Mark J. Bobak [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-04031 Date: Wed, 11 Sep 2002 21:08:18 -0800 Um, version? (To at least 4 places, please!) On the off

RE: ORA-04031

2002-09-12 Thread Mark J. Bobak
[mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 2:18 PM To: Multiple recipients of list ORACLE-L Subject: Re: ORA-04031 its 8.1.7.4 From: Mark J. Bobak [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

RE: ORA-04031

2002-09-12 Thread Reardon, Bruce (CALBBAY)
. -Mark On Wed, 2002-09-11 at 18:14, Seema Singh wrote: Hi One of instance are showing ORA-04031 error more frequntly(2 times in a week).I increased SGA ,pinned some of DBMS packages,flush SGA etc but all these are not helping at all.Let me know what could be look next. Thx

ORA-04031

2002-09-11 Thread Seema Singh
Hi One of instance are showing ORA-04031 error more frequntly(2 times in a week).I increased SGA ,pinned some of DBMS packages,flush SGA etc but all these are not helping at all.Let me know what could be look next. Thx -Seema

RE: ORA-04031

2002-09-11 Thread Baker, Barbara
, it went away. The exact error message for us was ORA-04031: unable to allocate 1126656 bytes of shared memory (shared pool,unknown object,hash-join subh,kllcqc:kllcqslt) The 3rd parameter is hash-join subh, so I think it pertains to hash joins. For Barb, the third parameter is cursor work he

Re: ORA-04031

2002-09-11 Thread Mark J. Bobak
ORA-04031 error more frequntly(2 times in a week).I increased SGA ,pinned some of DBMS packages,flush SGA etc but all these are not helping at all.Let me know what could be look next. Thx -Seema _ Join the world’s largest e

ora-04031 and x$ksmlru

2002-05-16 Thread Baker, Barbara
Oracle 8.0.5 Solaris 2.6 shared_pool_reserved_min_alloc5K shared_pool_reserved_size 6656000 shared_pool_size 13312 total sga size is 597 megs I'm fighting a particularly difficult ora-04031 error. The error can be reproduced easily

Re: ora-04031 and x$ksmlru

2002-05-16 Thread Tim Gorman
for SORT_AREA_SIZE and HASH_AREA_SIZE are too large for the Shared Pool, hence the ORA-04031. The solution is to reduce SORT_AREA_SIZE and HASH_AREA_SIZE... What are the settings for SORT_AREA_SIZE and HASH_AREA_SIZE here? Is it possible that the users may be using ALTER SESSION SET to set their own

RE: ora-04031 and x$ksmlru

2002-05-16 Thread Jamadagni, Rajendra
Tim, I don't know if it matters, but we faced the same error in 9x, and when we set the hash_area_size to 1M, it went away. The exact error message for us was ORA-04031: unable to allocate 1126656 bytes of shared memory (shared pool,unknown object,hash-join subh,kllcqc:kllcqslt) The 3rd

RE: ora-04031 and x$ksmlru

2002-05-16 Thread Baker, Barbara
PROTECTED] Sent: Thursday, May 16, 2002 12:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: ora-04031 and x$ksmlru Thanks to the wonderful search capabilities that Steve Adams has installed on his website at www.ixora.com.au, the following page has some more information

Oracle error ORA-04031

2002-02-21 Thread rick
I'm getting an ORA-04031: unable to allocate 8192 bytes of shared memory (large pool,unknown object,sort subheap,sort key) error, and am having a hard time solving the issue. The SQL being ran is: SELECT COUNT(DISTINCT mail) theCount FROM Demo D WHERE (EXISTS (SELECT 1 FROM mails WHERE mail

Re: Oracle error ORA-04031

2002-02-21 Thread James Manning
[[EMAIL PROTECTED]] I'm getting an ORA-04031: unable to allocate 8192 bytes of shared memory (large pool,unknown object,sort subheap,sort key) error, and am having a hard time solving the issue. http://www.cryer.co.uk/brian/oracle/ORA04031.htm -- James Manning [EMAIL PROTECTED] GPG Key

Re: ERR: ORA-04031 unable to allocate

2002-02-18 Thread cjgait
] Organization: Fat City Network Services, San Diego, California Oracle 8.0.5 Solaris 2.6 List: One of our users is getting this error message running a query: ERROR: ORA-04031: unable to allocate 4194304 bytes of shared memory (shared pool,unknown object,cursor work he,KKRH Hash Table

Re: ERR: ORA-04031 unable to allocate

2002-02-15 Thread Stephane Faroult
Baker, Barbara wrote: Oracle 8.0.5 Solaris 2.6 List: One of our users is getting this error message running a query: ERROR: ORA-04031: unable to allocate 4194304 bytes of shared memory (shared pool,unknown object,cursor work he,KKRH Hash Table) The query is very simple (see below

RE: ERR: ORA-04031 unable to allocate

2002-02-15 Thread Baker, Barbara
Subject: Re: ERR: ORA-04031 unable to allocate Baker, Barbara wrote: Oracle 8.0.5 Solaris 2.6 List: One of our users is getting this error message running a query: ERROR: ORA-04031: unable to allocate 4194304 bytes of shared memory (shared pool,unknown object,cursor

RE: ERR: ORA-04031 unable to allocate

2002-02-15 Thread Baker, Barbara
] Sent: Thursday, February 14, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Subject: Re: ERR: ORA-04031 unable to allocate see http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_dat abase_id=NOTp_id=146599.1 Jared Baker, Barbara

RE: ERR: ORA-04031 unable to allocate

2002-02-15 Thread DENNIS WILLIAMS
: ERR: ORA-04031 unable to allocate see http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_dat abase_id=NOTp_id=146599.1 Jared Baker, Barbara [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/14/02 04:03 PM Please respond to ORACLE-L

RE: ERR: ORA-04031 unable to allocate

2002-02-15 Thread Baker, Barbara
To: [EMAIL PROTECTED] Sent: Friday, February 15, 2002 9:33 AM To: Multiple recipients of list ORACLE-L Subject: RE: ERR: ORA-04031 unable to allocate Barbara - Been there done that. I have stubbornly made the same statements. This is why some co-workers say DBAs

RE: ERR: ORA-04031 unable to allocate

2002-02-15 Thread Mohammad Rafiq
]] Reply To:[EMAIL PROTECTED] Sent:Thursday, February 14, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Subject: Re: ERR: ORA-04031 unable to allocate see http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_dat abase_id=NOTp_id=146599.1

RE: ERR: ORA-04031 unable to allocate

2002-02-15 Thread Jared . Still
[EMAIL PROTECTED] cc: Subject:RE: ERR: ORA-04031 unable to allocate Dennis: I DO have my reputation to consider. Cantankerous is probably the nicest thing anyone's ever said about me. I actually did find the problem. One of the tables was recently re-loaded (via some

ERR: ORA-04031 unable to allocate

2002-02-14 Thread Baker, Barbara
Oracle 8.0.5 Solaris 2.6 List: One of our users is getting this error message running a query: ERROR: ORA-04031: unable to allocate 4194304 bytes of shared memory (shared pool,unknown object,cursor work he,KKRH Hash Table) The query is very simple (see below). Happens consistently. Error

RE: ORA-04031 unable to allocate

2002-02-14 Thread Vergara, Michael (TEM)
-Original Message- Sent: Thursday, February 14, 2002 4:04 PM To: Multiple recipients of list ORACLE-L Oracle 8.0.5 Solaris 2.6 List: One of our users is getting this error message running a query: ERROR: ORA-04031: unable to allocate 4194304 bytes of shared memory (shared pool,unknown

Re: ERR: ORA-04031 unable to allocate

2002-02-14 Thread Jared . Still
] cc: Subject:ERR: ORA-04031 unable to allocate Oracle 8.0.5 Solaris 2.6 List: One of our users is getting this error message running a query: ERROR: ORA-04031: unable to allocate 4194304 bytes of shared memory (shared pool,unknown object,cursor work he,KKRH Hash Table

ora-04031 errors

2002-01-28 Thread Fedock, John (KAM.RHQ)
I have been getting ora-04031 errors, even though I have much free space within my shared_pool - probably too much free actually. I set up some scripts to run every 10 minutes and as recently as 3 minutes before my ora-04031 errors started again, my shared_pool free memory was 26M based

ORA-04031 with Oracle 8.1.7.0.0 on HP-UX 11.0. URGENT

2002-01-25 Thread Kirsch, Walter J (Northrop Grumman)
Getting: ORA-04031: unable to allocate 4256 bytes of shared memory (shared pool, unknown object, sga heap, library cache) and ORA-00604: error occurred at recursive SQL level 1 over and over in the alert log. This is a suddenly event on a production database that had been operational at 8.1.6

RE: ORA-04031 with Oracle 8.1.7.0.0 on HP-UX 11.0. URGENT

2002-01-25 Thread Deshpande, Kirti
You may be hitting a bug# 1397603 and may have to apply the 8.1.7.1 or 8.1.7.2 patch set. Pl search Metalink for this bug number. - Kirti -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 9:25 AM To: Multiple recipients of list ORACLE-L Getting: ORA

? ORA-04031

2001-11-26 Thread Glasrot, Nechama
hello ... i got the following error from a full export ... . exporting posttables actions EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4080 bytes of shared memory (shared pool,DBMS_REPCAT,PL/SQL MPCODE,B AMIMA: Bam Buffer) ORA

ORA-04031

2001-11-01 Thread Harvinder Singh
Hi, we are running batch job executing following statement in a loop about 1 million iterations: select sysdate from dual... we are getting error ora-04031 unable to allocate 2400 bytes in shared pool.. and when we check the sys tables it is showing same number of pare call

Re: ORA-04031

2001-11-01 Thread Nikunj Gupta
:25 PM Hi, we are running batch job executing following statement in a loop about 1 million iterations: select sysdate from dual... we are getting error ora-04031 unable to allocate 2400 bytes in shared pool.. and when we check the sys tables it is showing same number

RE: ORA-04031, how to prevent fragmentation

2001-10-29 Thread Blum, Marc
Thanx to all, who answered. Seems to be Bug 1397603 MEMORY LEAKS OBSERVED WHEN RUNNING CONNECTION TESTS as I can observe growing counts for 'state objects'. = apply patchset 8.1.7.2 or = set _db_handles_cached = 0 (only workaround!) Mit freundlichen Grüßen i.A. Marc Blum SOPTIM AG Grüner

Re: ORA-04031, how to prevent fragmentation?

2001-10-28 Thread A. Bardeen
. A NT-service holds a permanent connection and checks, if some data export are about to be done. The database had now an uptime of several months and each new connect raises ORA-04031. Seems to be a fragmentation problem of the shared pool. How can I prevent that? Thanx very much Mit

RE: ORA-04031, how to prevent fragmentation

2001-10-28 Thread Blum, Marc
Thanx to all, who answered. Seems to be Bug 1397603 MEMORY LEAKS OBSERVED WHEN RUNNING CONNECTION TESTS as I can observe growing counts for 'state objects'. = apply patchset 8.1.7.2 or = set _db_handles_cached = 0 (only workaround!) Mit freundlichen Grüßen i.A. Marc Blum SOPTIM AG Grüner

RE: ORA-04031, how to prevent fragmentation?

2001-10-26 Thread Mark Leith
of list ORACLE-L Dear list, we have a small database with very few users, Oracle 8.1.7, NT 4 SP5. A NT-service holds a permanent connection and checks, if some data export are about to be done. The database had now an uptime of several months and each new connect raises ORA-04031. Seems

Re: ORA-04031, how to prevent fragmentation?

2001-10-26 Thread nlzanen1
an uptime of several months and each new connect raises ORA-04031. Seems to be a fragmentation problem of the shared pool. How can I prevent that? Thanx very much Mit freundlichen Grüßen i.A. Marc Blum SOPTIM AG Grüner Weg 22-24 D-52070 Aachen Telefon:+49 241 / 9 18 79-33 Fax: +49 241

RE: ORA-04031, how to prevent fragmentation?

2001-10-26 Thread Orr, Steve
holds a permanent connection and checks, if some data export are about to be done. The database had now an uptime of several months and each new connect raises ORA-04031. Seems to be a fragmentation problem of the shared pool. How can I prevent that? Thanx very much Mit freundlichen Grüßen i.A

RE: ORA-04031

2001-09-25 Thread BELOV
need to see a trace file for more info... -Original Message- From: Eca Eca [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 7:35 PM To: Multiple recipients of list ORACLE-L Subject: ORA-04031 Friends : I am using 9i and receiving : ORA-04031: unable to allocate

RE: ORA-04031

2001-09-25 Thread Eca Eca
] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ORA-04031 Date: Tue, 25 Sep 2001 00:30:21 -0800 need to see a trace file for more info... -Original Message- From: Eca Eca [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 7:35 PM To: Multiple

ORA-04031

2001-09-24 Thread Eca Eca
Friends : I am using 9i and receiving : ORA-04031: unable to allocate 8704 bytes of shared memory (large pool,unknown object,hash-join subh,kllcqas:kllsltba) I have 2gb of memory In init.ora i have large values for pool parameters ... What is happening ? Any idea ? The db_cache_size

RE: ORA-04031

2001-09-24 Thread Cale, Rick T (Richard)
AM To: Multiple recipients of list ORACLE-L Friends : I am using 9i and receiving : ORA-04031: unable to allocate 8704 bytes of shared memory (large pool,unknown object,hash-join subh,kllcqas:kllsltba) I have 2gb of memory In init.ora i have large values for pool parameters ... What

Why am I not getting ORA-04031 errors in my alert log?

2001-06-18 Thread Cherie_Machler
We were seeing ORA-04031 errors in our log files from exports and rman backups on a recently migrated 8.1.7 database on Sun Solaris 2.6. Our end users of our web-based applications were also seeing ORA-04031 errors upon executing their application. We increased shared pool size

ORA-04031

2001-06-07 Thread Smith, Ron L.
I have a small database with only about 6-10 users. I am getting ORA-04031 errors indicating shared_pool problems. Can anyone give me a suggestion on how to size the shared pool? My current parameters are: shared_pool _reserve_size 209715 shared_pool_size 4194304 large_pool_size 614400 Ron

RE: ORA-04031

2001-06-07 Thread Mohan, Ross
might as well pin some stuff while you're at it. hth, Ross || -Original Message- || From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] || Sent: Thursday, June 07, 2001 10:03 AM || To: Multiple recipients of list ORACLE-L || Subject: ORA-04031 || || || I have a small database with only about

Re: ORA-04031

2001-04-26 Thread Mohammad Rafiq
. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 26 Apr 2001 09:32:02 -0800 Increase it... [EMAIL PROTECTED] 04/26/01 12:00PM Hi All After upgrading from 8.1.6.0. to 8.1.6.3 I am getting the following error repeatedly. ORA

ORA-04031

2001-04-26 Thread Sajid Iqbal
Hi All After upgrading from 8.1.6.0. to 8.1.6.3 I am getting the following error repeatedly. ORA-04031: unable to allocate 4096 bytes of shared memory(shared pool,TRIG_OWSSUBS,PL/SQL MPCODE,BAMIMA: Bam Buffer) Also this error appears in the Oracle Alert log (not sure wether its connected

Re: ORA-04031

2001-04-26 Thread Tim Sawmiller
Increase it... [EMAIL PROTECTED] 04/26/01 12:00PM Hi All After upgrading from 8.1.6.0. to 8.1.6.3 I am getting the following error repeatedly. ORA-04031: unable to allocate 4096 bytes of shared memory(shared pool,TRIG_OWSSUBS,PL/SQL MPCODE,BAMIMA: Bam Buffer) Also this error appears