Re: Shared Pool Size (Hard to Explain)

Does anyone know where I can get a copy of the IOUW 1995?? Is it available on CD ROM, or is it a hard-copy? Please e-mail me at

dale.nstn.ca - thanks babette dale underwood

In article <4ilggi$p44_at_news.nyc.pipeline.com>, utrankar_at_nyc.pipeline.com says...
>
>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
>>!> jcl_at_altair.csustan.edu
>>!>
 

>>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 Wed Mar 20 1996 - 00:00:00 CET