Re: Shared Pool Size (Hard to Explain)
Date: 1996/03/19
Message-ID: <4ilggi$p44_at_news.nyc.pipeline.com>#1/1
ghp_at_infosoft.be (Gerard H. Pille) wrote:
>In article <Pine.SUN.3.91.960311144204.16780A-100000_at_reddog.csustan.edu>,
>John Landers (jcl_at_csustan.edu) says...
>!>
>!>I am running a database that has one user doing inserts,deletes,updates
>!>and selects. There are several triggers and procedures. Currently the
>!>shared pool size is 9M and We get an ora-4031 saying to increase
>!>our shared pool size. I can rationalize how one process can need
>!>more that 9M. I think someithing else needs to be tuned. But haven't
>!>stubled on it. Any ideas or places to search please email response.
>!>If increaseing it is ok then an affirmative would be nice to here.
>!>Oracle 7.2.24 for Os/2.
>!>Thanks,
>!>
>!> John Landers
>!> Computer Science Major
>!> CSUS
>!>
>I'm afraid you might have to enlarge it. Do the 9Mb include
>db_block_buffers? The room you need depends on the size of Oracle's and
>your procedures and SQL, not on the number of users (except if you were
>using MTS, you wouldn't, would you, for one user?). So if this one user
>is running very complex queries, fires long triggers, etc. etc., you may
>run out of luck (and space). You can monitor the SGA and see what's in
>it.
>--
>Kind reGards
> \ / |
> X |
> / \ s
> Gerard
IOUW 1995 has a good paper on managing shared pool. Take a look.
utrankar_at_nyc.pipline.com (Sameer Utrankar) All of us can't be heros. Someone has to sit by the curb and clap as they go by. Received on Tue Mar 19 1996 - 00:00:00 CET