Re: Who and What is using the shared pool.

I would, if I could, but I can't, so I won't.. We currently have the box at the max we can allocate and can notprovide any more for a larger shared_pool. We are moving to a larger box at the end of the month. But the product support manager wanted something in the
interim.

Terry Ball

Charlie Mengler wrote:

> It might be "better" to make the shared pool larger
> and avoid the problems which results when it fills up.
>
> Keep in mind that multiple users can be "sharing" the
> same SQL. This means that you could "kill" a process
> that reports high sqlpool usage and NOT free up ANY
> space within the shared pool because other folks are
> still using the same SQL code.
>
> With free advice, you get what you paid for it! ;-)
>
> HTH & YMMV!
>
> Terry Ball wrote:
> >
> > Recently we have had occurances where our shared pool fills up and we
> > have to flush the shared pool. The head of the product support group
> > wants us to kill any process that is using "too much" of the shared
> > pool. Is there any way we can identify which user/what query is using
> > the shared pool by percentage of shared pool used? Steve?
> >
> > Terry Ball
> >
> > --
> > Author: Terry Ball
> > INET: terry_ball_at_csgsystems.com
> >
> > 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: ListGuru_at_fatcity.com (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).
>
> --
> Charlie Mengler Maintenance Warehouse
> charliem_at_mwh.com 10641 Scripps Summit Ct
> 858-831-2229 San Diego, CA 92131
> If you don't learn from your mistakes, you are doomed to repeat them!
Received on Mon Aug 21 2000 - 11:10:23 CDT