RE: ora-4031 & large

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Tue, 18 May 2004 17:46:27 -0700 (PDT)
Message-ID: <20040519004627.93137.qmail@web60703.mail.yahoo.com>

it gets better....

he did this when the primary DBA on that database was off on vacation. I was not informed of his changes until just before they went in (and that was accidental). I yelled and was told "he knows what he is doing, this is critical for senior management". so he put it into staging.....

and then didn't test it before it went to production several hours later.

I finally got it fixed (took hours until we figured out what was wrong). And he STILL insisted that his changes did nothing.

These days he says "oh, I don't know 9i can you look into this". Right now we are fighting about whether we should be running heavy ad hoc batch (up to 14 jobs at a time) during the day "because senior management needs it". The server is driven to its knees when they run these jobs.

I begin to feel a lot like a Gahan Wilson story "I have no mouth and I must scream"

"Bobak, Mark" <Mark.Bobak_at_il.proquest.com> wrote:
> Comment below....
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Rachel Carmichael
> Sent: Tuesday, May 18, 2004 5:17 PM
> To: oracle-l_at_freelists.org
> Subject: Re: ora-4031 & large_pool
>
> >If you are using connection pooling to access the database, you are
> >using XA. And XA needs a (no pun intended) large large_pool. Ours
> >broke when a DBA not familiar with our application and database made
> >changes to the init.ora and decreased the size of the large pool.
>
> Oh, bad DBA! No Biscuit! I'd have hated to be in your line of fire
> after that little incident...;-)
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue May 18 2004 - 20:18:18 CDT

RE: ora-4031 & large_pool